Hibernate 4.1.2 hhh000342: Unable to get a connection with query metadata: No drivers suitable for JDBC: HSQLDB: MEM: TEST

 
 
 org.hibernate.ejb.HibernatePersistence
 User
 
 
  
 
 
 
 
 
 
 
 

...
Persistence.createEntityManagerFactory("Test")
...

try {
 Class.forName("org .hsqldb.jdbcDriver");
} catch (ClassNotFoundException e) {
 // TODO Auto-generated catch block
 e.printStackTrace();
 }

What did I do wrong?

My persistence.xml

 
 
 org.hibernate.ejb.HibernatePersistence
 User
 
 
  
 
 
 
 < property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect"/>
 
 
 
 

My code

...
Persistence.createEntityManagerFactory("Test")
...

I received this error

javax.persistence.PersistenceException: [PersistenceUnit: Test] Unable to build EntityManagerFactory
 at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:915)
 at org.hibernate.ejb.Ejb3Configuration. buildEntityManagerFactory(Ejb3Configuration.java:890)
 at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:57)
 at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63)
 at javax.persistence.Persistence.createEntityManagerFactory(Persistence. java:47)
 at com.aol.biz.vendor.persistence.TestVpsUser.setUp(TestVpsUser.java:32)
 at junit.framework.TestCase.runBare(TestCase.java:125)
 at junit.framework.TestResult$1.protect(TestResult.java:106)
 at junit.framework.TestResult.runProtected(TestResult.java:124)
 at junit.framework.TestResult.run( TestResult.java:109)
 at junit.framework.TestCase.run(TestCase.java:118)
 at junit.framework.TestSuite.runTest(TestSuite.java:208)
 at junit .framework.TestSuite.run(TestSuite.java:203)
 at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
 at org.eclipse .jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
 at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
 at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
 at org.eclipse.jdt.internal.junit .runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
 at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
Caused by: 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:170)
 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.c fg.SettingsFactory.buildSettings(SettingsFactory.java:71)
 at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2274)
 at org.hibernate.cfg.Configuration.buildSettings(Configuration. java:2270)
 at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1739)
 at org.hibernate.ejb.EntityManagerFactoryImpl.(EntityManagerFactoryImpl.java:93)
 at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:905)
 ... 18 more

But! !

If I manually load the jdbc driver class before creating the factory-everything works. O_O

try {
 Class.forName("org .hsqldb.jdbcDriver");
} catch (ClassNotFoundException e) {
 // TODO Auto-generated catch block
 e.printStackTrace();
 }

< p>How can I do all this without this step? Plz help!

I have a similar problem with 4.1.2.Final. But if I go back to 4.1.1.Final, my program runs normally.