正确决解Hibernate4.*中：Connection cannot be null when 'hibernate.dialect' not set

最新推荐文章于 2022-03-01 19:22:47 发布

fenglai0802

最新推荐文章于 2022-03-01 19:22:47 发布

阅读量816

点赞数

分类专栏： java

java 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

今天在做Hibernate4.*的项目中，使用了以下的配置：

hibernate.cfg.xml

 1  <?xml version='1.0' encoding='utf-8'?>
 2  <!DOCTYPE hibernate-configuration PUBLIC
 3      "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
 4      "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
 5  <hibernate-configuration>
 6      <session-factory>
 7          <property name="show_sql">true</property>
 8          <property name="format_sql">true</property>
 9          <property name="dialect">org.hibernate.dialect.SQLiteDialect</property>
10          <property name="connection.driver_class">org.sqlite.JDBC</property>
11          <property name="connection.url">jdbc:sqlite:D:\Documents\Dbs\test.db</property>
12          <property name="connection.username"></property>
13          <property name="connection.password"></property>
14  
15          <mapping resource="test/model/Blackey.hbm.xml" />
16      </session-factory>
17  </hibernate-configuration>

然后在Text.java中测试：

 
         import  
         org.hibernate.Session; 
        
         import  
         org.hibernate.SessionFactory; 
        
         import  
         org.hibernate.cfg.Configuration; 
        
         import  
         org.hibernate.service.ServiceRegistryBuilder; 
        
         import  
         test.model.Blackey; 
        
         public  
         class  
         Test { 
        
         public  
         static  
         void  
         main(String [] args){ 
        
         Blackey bk =  
         new  
         Blackey(); 
        
         bk.setName( 
         "测试" 
         ); 
        
         bk.setVersion( 
         "1.0.4" 
         ); 
        
         bk.setUid( 
         "Test" 
         ); 
        
         bk.setKey( 
         "1fD46a709C920a01477632" 
         ); 
        
         bk.setDescribe( 
         "该注册码只能用于该版本！" 
         ); 
        
         Configuration cfg =  
         new  
         Configuration().configure(); 
        
         SessionFactory sf = cfg.buildSessionFactory( 
         new  
         ServiceRegistryBuilder().buildServiceRegistry());　　 
         //以前的cfg.buildSessionFactory()方法被废弃，查网上大多使用该方法 
        
         Session session = sf.openSession(); 
        
         session.beginTransaction(); 
        
         session.save(bk); 
        
         session.getTransaction().commit(); 
        
         session.close(); 
        
         sf.close(); 
        
         } 
        
         }

　　结果显示报错：

 
         Exception in thread  
         "main"  
         org.hibernate.HibernateException: Connection cannot be  
         null  
         when  
         'hibernate.dialect'  
         not set 
        
         at org.hibernate.service.jdbc.dialect.internal.DialectFactoryImpl.determineDialect(DialectFactoryImpl.java: 
         97 
         ) 
        
         at org.hibernate.service.jdbc.dialect.internal.DialectFactoryImpl.buildDialect(DialectFactoryImpl.java: 
         67 
         ) 
        
         at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java: 
         174 
         ) 
        
         at org.hibernate.service.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java: 
         75 
         ) 
        
         at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java: 
         159 
         ) 
        
         at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java: 
         131 
         ) 
        
         at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java: 
         73 
         ) 
        
         at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java: 
         2283 
         ) 
        
         at org.hibernate.cfg.Configuration.buildSettings(Configuration.java: 
         2279 
         ) 
        
         at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java: 
         1748 
         ) 
        
         at Test.main(Test.java: 
         19 
         )

　　一直让人很费解，因为显而易见，我的dialect是明确定义了的（说明一下：我个人已经把org.hibernate.dialect.SQLiteDialect文件打包到了hibernate-core-4.1.*.jar中，所以不会有此类不存在的可能），但为什么说我的dialect未定义呢？

　　在网上找相关资料，发现很多人都存在这个问题，可惜没有发现很好的解决办法，有人只是测试使用 hibernate.properties来进行配置，则可以成功。个人还是觉得使用xml配置好，转向国外网站查看，终于看到了一个老外的解决办法：

将

 
         SessionFactory sf = cfg.buildSessionFactory( 
         new  
         ServiceRegistryBuilder().buildServiceRegistry());

替换成

 
         SessionFactory sf = cfg.buildSessionFactory( 
         new  
         ServiceRegistryBuilder().applySettings(cfg.getProperties()).buildServiceRegistry());

表示应用hibernate.cfg.xml中的属性配置，接着运行，发现又错了：

 
         Exception in thread  
         "main"  
         org.hibernate.HibernateException: Error applying BeanValidation relational constraints 
        
         at org.hibernate.cfg.beanvalidation.BeanValidationIntegrator.applyRelationalConstraints(BeanValidationIntegrator.java: 
         219 
         ) 
        
         at org.hibernate.cfg.beanvalidation.BeanValidationIntegrator.integrate(BeanValidationIntegrator.java: 
         126 
         ) 
        
         at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java: 
         301 
         ) 
        
         at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java: 
         1750 
         ) 
        
         at Test.main(Test.java: 
         19 
         ) 
        
         Caused by: java.lang.reflect.InvocationTargetException 
        
         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
        
         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 
         39 
         ) 
        
         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 
         25 
         ) 
        
         at java.lang.reflect.Method.invoke(Method.java: 
         597 
         ) 
        
         at org.hibernate.cfg.beanvalidation.BeanValidationIntegrator.applyRelationalConstraints(BeanValidationIntegrator.java: 
         208 
         ) 
        
         ...  
         4  
         more 
        
         Caused by: org.hibernate.HibernateException: Unable to build the  
         default  
         ValidatorFactory 
        
         at org.hibernate.cfg.beanvalidation.TypeSafeActivator.getValidatorFactory(TypeSafeActivator.java: 
         524 
         ) 
        
         at org.hibernate.cfg.beanvalidation.TypeSafeActivator.applyDDL(TypeSafeActivator.java: 
         119 
         ) 
        
         ...  
         9  
         more 
        
         Caused by: javax.validation.ValidationException: Unable to instantiate Configuration. 
        
         at javax.validation.Validation$GenericBootstrapImpl.configure(Validation.java: 
         272 
         ) 
        
         at javax.validation.Validation.buildDefaultValidatorFactory(Validation.java: 
         111 
         ) 
        
         at org.hibernate.cfg.beanvalidation.TypeSafeActivator.getValidatorFactory(TypeSafeActivator.java: 
         521 
         ) 
        
         ...  
         10  
         more 
        
         Caused by: java.lang.NullPointerException 
        
         at java.util.ResourceBundle.getBundle(ResourceBundle.java: 
         960 
         ) 
        
         at org.hibernate.validator.engine.ResourceBundleMessageInterpolator.loadBundle(ResourceBundleMessageInterpolator.java: 
         202 
         ) 
        
         at org.hibernate.validator.engine.ResourceBundleMessageInterpolator.getFileBasedResourceBundle(ResourceBundleMessageInterpolator.java: 
         182 
         ) 
        
         at org.hibernate.validator.engine.ResourceBundleMessageInterpolator.<init>(ResourceBundleMessageInterpolator.java: 
         81 
         ) 
        
         at org.hibernate.validator.engine.ResourceBundleMessageInterpolator.<init>(ResourceBundleMessageInterpolator.java: 
         73 
         ) 
        
         at org.hibernate.validator.engine.ConfigurationImpl.<init>(ConfigurationImpl.java: 
         57 
         ) 
        
         at org.hibernate.validator.HibernateValidator.createGenericConfiguration(HibernateValidator.java: 
         43 
         ) 
        
         at javax.validation.Validation$GenericBootstrapImpl.configure(Validation.java: 
         269 
         ) 
        
         ...  
         12  
         more

从网上搜了一下，发现还需要在hibernate.cfg.xml中加入一条配置：

<property name="javax.persistence.validation.mode">none</property>

关键在于Unable to instantiate Configuration，如不添加默认会要求Validation provider。

做完这些，然后运行Test.java，一切正常。 OK，问题解决。

fenglai0802

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
正确决解Hibernate4.*中：Connection cannot be null when 'hibernate.dialect' not set

今天在做Hibernate4.*的项目中，使用了以下的配置：hibernate.cfg.xml 1 xml version='1.0' encoding='utf-8'?> 2 DOCTYPE hibernate-configuration PUBLIC 3 "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
复制链接

扫一扫