非Spring Boot环境下@EnableJdbcHttpSession配置问题求助

Hey there! Let's work through getting your Spring Session JDBC setup up and running properly—this is a common hurdle, but we can break it down step by step.

You already added spring-session-jdbc, but make sure you have all required supporting dependencies:

• For Spring Boot projects: Add spring-boot-starter-jdbc (to handle DataSource management) and your database driver (e.g., mysql-connector-j for MySQL, postgresql for PostgreSQL).
• For non-Boot Spring projects: Include Spring JDBC (spring-jdbc) and your database driver, plus ensure a DataSource bean is defined.

Example pom.xml snippet for Spring Boot + MySQL:

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
    <groupId>com.mysql</groupId>
    <artifactId>mysql-connector-j</artifactId>
    <scope>runtime</scope>
</dependency>
<dependency>
    <groupId>org.springframework.session</groupId>
    <artifactId>spring-session-jdbc</artifactId>
</dependency>

Spring Session JDBC needs a valid DataSource to connect to your database. For Spring Boot, add these properties to application.properties (or application.yml):

# Database connection details
spring.datasource.url=jdbc:mysql://localhost:3306/your_session_db?useSSL=false&serverTimezone=UTC
spring.datasource.username=your_db_user
spring.datasource.password=your_db_password
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

# Explicitly set session store type to JDBC
spring.session.store-type=jdbc

Create a configuration class and add the @EnableJdbcHttpSession annotation. This tells Spring to replace the default session management with JDBC-backed storage:

import org.springframework.context.annotation.Configuration;
import org.springframework.session.jdbc.config.annotation.web.http.EnableJdbcHttpSession;

@Configuration
@EnableJdbcHttpSession(maxInactiveIntervalInSeconds = 1800) // Optional: Set session timeout (30 mins here)
public class HttpSessionConfig {
    // No extra beans needed if using Spring Boot's auto-configured DataSource
}

Make sure this configuration class is scanned by Spring (it should be in a package covered by @SpringBootApplication or @ComponentScan).

Spring Session requires specific tables to store session data. By default, it only auto-creates these tables for embedded databases (like H2). For external databases (MySQL, PostgreSQL), you have two options:

1. Auto-initialize tables (Spring Boot only)
   Add this property to application.properties to force table creation on startup:

spring.session.jdbc.initialize-schema=always

2. Manual table creation
   Run the database-specific SQL script provided by Spring Session. For MySQL, here's the core schema:

CREATE TABLE SPRING_SESSION (
    PRIMARY_ID CHAR(36) NOT NULL,
    SESSION_ID CHAR(36) NOT NULL,
    CREATION_TIME BIGINT NOT NULL,
    LAST_ACCESS_TIME BIGINT NOT NULL,
    MAX_INACTIVE_INTERVAL INT NOT NULL,
    EXPIRY_TIME BIGINT NOT NULL,
    PRINCIPAL_NAME VARCHAR(100),
    PRIMARY KEY (PRIMARY_ID)
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;

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 CHAR(36) NOT NULL,
    ATTRIBUTE_NAME VARCHAR(200) NOT NULL,
    ATTRIBUTE_BYTES BLOB NOT NULL,
    PRIMARY KEY (SESSION_PRIMARY_ID, ATTRIBUTE_NAME),
    CONSTRAINT SPRING_SESSION_ATTRIBUTES_FK FOREIGN KEY (SESSION_PRIMARY_ID) REFERENCES SPRING_SESSION(PRIMARY_ID) ON DELETE CASCADE
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;

You can find scripts for other databases in the Spring Session JDBC JAR under org/springframework/session/jdbc/.

To verify everything works, create a simple test controller:

@RestController
public class SessionTestController {

    @GetMapping("/set-session")
    public String setSession(HttpSession session) {
        session.setAttribute("user", "todor27");
        return "Session ID: " + session.getId() + " | User set";
    }

    @GetMapping("/get-session")
    public String getSession(HttpSession session) {
        String user = (String) session.getAttribute("user");
        return "Session ID: " + session.getId() + " | User from session: " + user;
    }
}

• First, hit /set-session on one node.
• Then, hit /get-session on a different node. If you see the user value returned, your JDBC session storage is working!

Common pitfalls to check: #

• Version mismatch: Ensure Spring Session version matches your Spring/Spring Boot version (e.g., Spring Boot 3.x requires Spring Session 3.x, Spring Boot 2.x uses Spring Session 2.x).
• DataSource issues: Check logs for database connection errors—make sure your credentials and URL are correct.
• Table creation failures: If auto-initialization isn't working, verify the database user has CREATE TABLE permissions.
• Annotation placement: Double-check @EnableJdbcHttpSession is on a valid @Configuration class that's being scanned.

内容的提问来源于stack exchange，提问作者Todor27