无法解包装为请求的类型javax.sql.datasource-Spring hibernate java配置

Question

有没有人能告诉我如何修复这个配置？

谢谢

import java.util.Properties;

import org.apache.tomcat.jdbc.pool.DataSource;
import org.hibernate.SessionFactory;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.annotation.Bean;
import org.springframework.orm.hibernate5.HibernateTransactionManager;
import org.springframework.orm.hibernate5.LocalSessionFactoryBuilder; 
import org.springframework.transaction.annotation.EnableTransactionManagement;

@EnableTransactionManagement
@SpringBootApplication
public class MegLabApplication
{

public static void main(String[] args)
{
    SpringApplication.run(MegLabApplication.class, args);
}

@Value("${spring.datasource.driverClassName}")
private String databaseDriverClassName;

@Value("${spring.datasource.url}")
private String datasourceUrl;

@Value("${spring.datasource.username}")
private String databaseUsername;

@Value("${spring.datasource.password}")
private String databasePassword;

@Bean
public SessionFactory sessionFactory()
{
    Configuration configuration = new Configuration();
    configuration.setProperties(getHibernateProperties());

    ServiceRegistry serviceRegistry = new StandardServiceRegistryBuilder()
            .applySettings(configuration.getProperties()).build();

    LocalSessionFactoryBuilder builder = new LocalSessionFactoryBuilder(dataSource());

    builder.scanPackages("com.xxx.models");

    return builder.buildSessionFactory(serviceRegistry);
}

private Properties getHibernateProperties()
{
    Properties prop = new Properties();
    prop.put("hibernate.connection.pool_size", "10");

    prop.put("hibernate.c3p0.min_size", "5");
    prop.put("hibernate.c3p0.max_size", "20");
    prop.put("hibernate.c3p0.timeout", "300");
    prop.put("hibernate.c3p0.max_statements", "50");
    prop.put("hibernate.c3p0.idle_test_period", "60");

    prop.put("hibernate.format_sql", "true");
    prop.put("hibernate.show_sql", "true");
    prop.put("hibernate.dialect", "org.hibernate.dialect.MySQL5InnoDBDialect");
    prop.put("hibernate.hbm2ddl.auto", "update");
    return prop;
}

@Bean(name = "dataSource")
public DataSource dataSource()
{
    DataSource ds = new DataSource();
    ds.setDriverClassName(databaseDriverClassName);
    ds.setUrl(datasourceUrl);
    ds.setUsername(databaseUsername);
    ds.setPassword(databasePassword);
    return ds;
}

@Bean
public HibernateTransactionManager txManager()
{
    return new HibernateTransactionManager(sessionFactory());
}
}

Answer 1

好吧，我终于把这一切都搞定了...

Spring boot使用hibernate 4.3.11。我最初配置中的HibernateTransactionManager类使用的是Hibernate5，所以我将类版本更改为4。我的C3P0依赖也是版本5，所以我将它降级为版本4。

我还必须将连接细节添加到hibernate属性中，并通过指定类显式地告诉它使用C3P0连接提供程序。

prop.put("hibernate.connection.provider_class", "org.hibernate.c3p0.internal.C3P0ConnectionProvider")