在SpringBoot+Spring data JPA+MySql项目中配置SessionFactory

Question

我一直在用SpringBoot+Spring Data JPA编写我的第一个项目。我使用MySql作为我的数据库提供程序。我对春靴和冬眠有点陌生。

我遵循了http://blog.netgloo.com/2014/10/27/using-mysql-in-spring-boot-via-spring-data-jpa-and-hibernate/提供的教程。

@Repository
public class ReadDaoImpl implements ReadDao{

    private static SessionFactory sessionFactory;

    public static SessionFactory getSessionFactory() {
        return sessionFactory;
    }

    @Autowired
    public static void setSessionFactory(SessionFactory sessionFactory) {
        TenderReadDaoImpl.sessionFactory = sessionFactory;
    }

    @Override
    public List<Read> getAllReads() {

        System.out.println("DEBUG: Inside ReadDaoImpl.getAllReads");

        Session session = sessionFactory.openSession(); // I think that the issue comes from here
        Transaction tx = null;
        ..............................
        ..............................
    }
}

Session session = sessionFactory.openSession();

# ===============================
# = DATA SOURCE
# ===============================

# Set here configurations for the database connection

# Connection url for the database 
spring.datasource.url = jdbc:mysql://localhost:3306/readsdb?useSSL=false

# Username and password
spring.datasource.username = root
spring.datasource.password = password

# Keep the connection alive if idle for a long time (needed in production)
spring.datasource.testWhileIdle = true
spring.datasource.validationQuery = SELECT 1

# ===============================
# = JPA / HIBERNATE
# ===============================

# Use spring.jpa.properties.* for Hibernate native properties (the prefix is
# stripped before adding them to the entity manager).

# Show or not log for each sql query
spring.jpa.show-sql = true

# Hibernate ddl auto (create, create-drop, update): with "update" the database
# schema will be automatically updated accordingly to java entities found in
# the project
spring.jpa.hibernate.ddl-auto = create-drop

# Naming strategy
spring.jpa.hibernate.naming-strategy = org.hibernate.cfg.ImprovedNamingStrategy

# Allows Hibernate to generate SQL optimized for a particular DBMS
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect

在我的项目中，没有任何配置文件。我需要添加一个来创建SessionFactorybean吗？我遇到了一个名为EntityManagerFactory的东西。对于这个基于Spring Jpa的项目，我需要通过它来配置SessionFactory吗？如果是，怎么做？

我现在完全没有解决办法。引导我完成这件事。如果能指出做这件事的详尽方法，对我会有很大帮助。

谢谢…！

Answer 1

以这种方式在@Configuration类中显式配置SessionFactory。从属性文件中删除配置。我使用Oracle，您可以相应地替换mysql属性：

@Configuration
public class myConfiguration {
 //datasource bean
    @Bean("dataSource")
    public DataSource  getDataSource() {        
        DataSourceBuilder b = DataSourceBuilder.create();
         b.url("jdbc:oracle:thin:@localhost:1521:xe");
         b.driverClassName("oracle.jdbc.driver.OracleDriver");
         b.username("system");
         b.password("system");
        return b.build();
    }


    //sessionfactory bean
    @Bean
    public SessionFactory getSessionFactory(DataSource dataSource) {

        LocalSessionFactoryBuilder builder = new LocalSessionFactoryBuilder(dataSource);

        builder.addProperties(getHibernateProperties());
        builder.scanPackages("ORM.Model");

        return builder.buildSessionFactory();       
    }

    //Hibernate properties:
    private Properties getHibernateProperties() {       
        Properties properties = new Properties();

        properties.put("hibernate.dialect", "org.hibernate.dialect.Oracle9Dialect");        
        properties.put("hibernate.show_sql", "true");
        properties.put("hibernate.format_sql", "true");     
        properties.put("hibernate.hbm2ddl.auto", "create");

        return properties;
    }

    //transaction manager bean
    @Bean
    public HibernateTransactionManager getTransactionManager(SessionFactory sessionFactory) {
        HibernateTransactionManager transactionManager = new HibernateTransactionManager(sessionFactory);
        return transactionManager;
    }