解决springboot重启后保持原会话id不变

学习使我快乐——玉祥

于 2024-12-16 15:37:02 发布

阅读量138

点赞数 1

CC 4.0 BY-SA版权

本文章作者主页，https://blog.csdn.net/qq_43319748，未经作者允许禁止转载，如有问题，欢迎指正！☺☺☺

本文链接：https://blog.csdn.net/qq_43319748/article/details/144510306

引入依赖

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!-- Spring Session JDBC -->
        <dependency>
            <groupId>org.springframework.session</groupId>
            <artifactId>spring-session-jdbc</artifactId>
        </dependency>

在默认dataSource创建表

CREATE TABLE `spring_session` (
  `PRIMARY_ID` varchar(255) DEFAULT NULL,
  `SESSION_ID` varchar(255)  NOT NULL,
  `CREATION_TIME` bigint DEFAULT NULL,
  `LAST_ACCESS_TIME` bigint DEFAULT NULL,
  `MAX_INACTIVE_INTERVAL` bigint DEFAULT NULL,
  `EXPIRY_TIME` bigint DEFAULT NULL,
  `PRINCIPAL_NAME` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`SESSION_ID`)
) ENGINE=InnoDB;

CREATE TABLE `spring_session_attributes` (
  `SESSION_ID` varchar(50) NOT NULL,
  `SESSION_PRIMARY_ID` varchar(50)  DEFAULT NULL,
  `ATTRIBUTE_NAME` varchar(200)  NOT NULL,
  `ATTRIBUTE_BYTES` blob NOT NULL,
  PRIMARY KEY (`SESSION_ID`,`ATTRIBUTE_NAME`)
) ENGINE=InnoDB;

重启就能解决