Closed
Description
We are using:
Spring Session 1.3.1
Spring Security 4.3.2
Oracle 12g
I got an error, "Can not insert null SPRING_SESSION.SPRING_SESSION_PK". This can easily be resolved by adding a Sequence and a trigger for Oracle.
CREATE SEQUENCE "SPRING_SESSION_SEQ"
minvalue 1024
nomaxvalue
increment by 1
start with 1024
cache 1000
noorder
nocycle;
create or replace trigger SPRING_SESSION_TRG
before insert on SPRING_SESSION
for each row
when (new.PRIMARY_ID is null)
begin
select SPRING_SESSION_SEQ.nextval into :new.PRIMARY_ID from DUAL;
end;
web.xml
<filter>
<filter-name>springSessionRepositoryFilter</filter-name>
<filter-class>org.springframework.web.filter.DelegatingFilterProxy</filter-class>
</filter>
<filter-mapping>
<filter-name>springSessionRepositoryFilter</filter-name>
<url-pattern>/*</url-pattern>
<dispatcher>REQUEST</dispatcher>
<dispatcher>ERROR</dispatcher>
</filter-mapping>
<filter>
<filter-name>springSecurityFilterChain</filter-name>
<filter-class>org.springframework.web.filter.DelegatingFilterProxy</filter-class>
</filter>
<filter-mapping>
<filter-name>springSecurityFilterChain</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
applicationContext.xml
<context:annotation-config/>
<bean class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<constructor-arg ref="dataSource"/>
</bean>
<bean class="org.springframework.session.jdbc.config.annotation.web.http.JdbcHttpSessionConfiguration"/>