SpringBoot2默认使用tomcat8,我使用的是jdk1.8, oracle版本是11.2,所以在做jdbc依赖时,使用的是ojdbc6。
建表语句如下:
CREATE TABLE SPRING_SESSION (
PRIMARY_ID nvarchar2(36) NOT NULL,
SESSION_ID nvarchar2(36) NOT NULL,
CREATION_TIME number NOT NULL,
LAST_ACCESS_TIME number NOT NULL,
MAX_INACTIVE_INTERVAL INT NOT NULL,
EXPIRY_TIME number NOT NULL,
PRINCIPAL_NAME nvarchar2(100),
CONSTRAINT SPRING_SESSION_PK PRIMARY KEY (PRIMARY_ID)
);
CREATE UNIQUE INDEX SPRING_SESSION_IX1 ON SPRING_SESSION (SESSION_ID);
CREATE INDEX SPRING_SESSION_IX2 ON SPRING_SESSION (EXPIRY_TIME);
CREATE INDEX SPRING_SESSION_IX3 ON SPRING_SESSION (PRINCIPAL_NAME);
CREATE TABLE SPRING_SESSION_ATTRIBUTES (
SESSION_PRIMARY_ID nvarchar2(36) NOT NULL,
ATTRIBUTE_NAME nvarchar2(200) NOT NULL,
ATTRIBUTE_BYTES BLOB NOT NULL,
CONSTRAINT SPRING_SESSION_ATTRIBUTES_PK PRIMA