Spring+Hibernate+Maven项目前后端联调：添加SessionFactory后异常

Hey there! Let's tackle this issue you're facing. You mentioned everything worked smoothly until you added private SessionFactory sessionFactory; to your CategoryDAOImpl.java—that's a classic spot where Spring/Hibernate configuration gaps pop up. Let's break down what might be going wrong, starting with the code you shared.

First, let's format your Category.java snippet properly #

package src.main.java.myshoppingbackend.dto;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "category")
public class Category {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;

    @Column(name = "name", nullable = false)
    private String categoryName;

    // Add your constructors, getters, and setters here
}

(I filled in the incomplete javax.persistence import since it likely cuts off at @Id—adjust if your actual code differs)

Common Causes & Fixes for the SessionFactory Error #

When adding SessionFactory to your DAO, the most frequent issues boil down to missing injection, misconfigured beans, or missing dependencies. Here's how to fix each:

1. You Forgot to Inject the SessionFactory

Spring can't magically wire up the SessionFactory unless you tell it to. Add the @Autowired annotation to your field in CategoryDAOImpl.java:

@Repository // Make sure this annotation is present to mark it as a DAO bean
public class CategoryDAOImpl implements CategoryDAO {

    // Add @Autowired to trigger dependency injection
    @Autowired
    private SessionFactory sessionFactory;

    // Your DAO methods (e.g., getCategoryById, listAllCategories) go here
}

2. Your Spring Configuration Lacks a SessionFactory Bean

Spring needs a properly configured SessionFactory bean to inject. Here are two ways to set this up:

Option A: XML Configuration (applicationContext.xml)

Add this bean definition to your Spring config file:

<!-- Data Source (connect to your database) -->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
    <property name="url" value="jdbc:mysql://localhost:3306/your_database_name?useSSL=false"/>
    <property name="username" value="your_db_username"/>
    <property name="password" value="your_db_password"/>
</bean>

<!-- Hibernate Session Factory -->
<bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
    <property name="dataSource" ref="dataSource"/>
    <!-- Scan your DTO package for JPA entities -->
    <property name="packagesToScan" value="src.main.java.myshoppingbackend.dto"/>
    <property name="hibernateProperties">
        <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.MySQL8Dialect</prop>
            <prop key="hibernate.show_sql">true</prop>
            <prop key="hibernate.hbm2ddl.auto">update</prop>
        </props>
    </property>
</bean>

<!-- Enable component scanning for DAOs and services -->
<context:component-scan base-package="src.main.java.myshoppingbackend"/>

Option B: Java Configuration (HibernateConfig.java)

If you prefer annotation-based config, create this configuration class:

package src.main.java.myshoppingbackend.config;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.PropertySource;
import org.springframework.core.env.Environment;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import org.springframework.orm.hibernate5.LocalSessionFactoryBean;
import org.springframework.transaction.annotation.EnableTransactionManagement;

import javax.sql.DataSource;
import java.util.Properties;

@Configuration
@EnableTransactionManagement
@ComponentScan("src.main.java.myshoppingbackend")
@PropertySource("classpath:db.properties") // Create this file with your DB credentials
public class HibernateConfig {

    @Autowired
    private Environment env;

    @Bean
    public LocalSessionFactoryBean sessionFactory() {
        LocalSessionFactoryBean sessionFactory = new LocalSessionFactoryBean();
        sessionFactory.setDataSource(dataSource());
        sessionFactory.setPackagesToScan("src.main.java.myshoppingbackend.dto");
        sessionFactory.setHibernateProperties(hibernateProperties());
        return sessionFactory;
    }

    @Bean
    public DataSource dataSource() {
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName(env.getProperty("jdbc.driver"));
        dataSource.setUrl(env.getProperty("jdbc.url"));
        dataSource.setUsername(env.getProperty("jdbc.username"));
        dataSource.setPassword(env.getProperty("jdbc.password"));
        return dataSource;
    }

    private Properties hibernateProperties() {
        Properties properties = new Properties();
        properties.put("hibernate.dialect", env.getProperty("hibernate.dialect"));
        properties.put("hibernate.show_sql", env.getProperty("hibernate.show_sql"));
        properties.put("hibernate.hbm2ddl.auto", env.getProperty("hibernate.hbm2ddl.auto"));
        return properties;
    }
}

3. Missing Dependencies in Your Build File

Ensure your pom.xml (Maven) or build.gradle (Gradle) includes all required Spring/Hibernate dependencies:

Maven (pom.xml)

<!-- Spring Core & ORM -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-core</artifactId>
    <version>5.3.20</version> <!-- Match your project's Spring version -->
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-orm</artifactId>
    <version>5.3.20</version>
</dependency>

<!-- Hibernate Core -->
<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate-core</artifactId>
    <version>5.6.9.Final</version> <!-- Compatible with Spring 5.3.x -->
</dependency>

<!-- MySQL Driver -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.29</version>
</dependency>

Quick Checklist to Verify #

• Does your CategoryDAOImpl have the @Repository annotation?
• Is the SessionFactory annotated with @Autowired?
• Does your Spring config correctly define the SessionFactory and DataSource beans?
• Are all required dependencies present in your build file?

Go through these steps one by one, and you should resolve the error. If you run into a specific exception message, share it, and we can narrow it down further!

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