Hibernate HSQLDB Issue

aspratap · **Joined:** Tue Oct 11, 2005 1:48 am **Posts:** 4

Hi all,

I am facing an issue while using Hibernate 3.x with HSQLDB1.7.3.

While getting the connection to the database I am getting the following exception.

Quote:

java.sql.SQLException: Connection is broken: Transfer corrupted
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.getAutoCommit(Unknown Source)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:112)
at org.jbpm.db.JbpmSchema.createConnection(JbpmSchema.java:261)
at org.jbpm.db.JbpmSchema.execute(JbpmSchema.java:223)
at org.jbpm.db.JbpmSchema.createSchema(JbpmSchema.java:149)
at jbpm.poc.LeaveTest.<clinit>(LeaveTest.java:43)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at junit.framework.TestSuite.createTest(TestSuite.java:131)
at junit.framework.TestSuite.addTestMethod(TestSuite.java:114)
at junit.framework.TestSuite.<init>(TestSuite.java:75)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.getTest(RemoteTestRunner.java:366)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:404)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:311)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)

Following is part of the hibernate-cfg.xml:

Quote:

....

<property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>
<property name="hibernate.connection.driver_class">org.hsqldb.jdbcDriver</property>

<property name="hibernate.connection.url">jdbc:hsqldb:hsql://localhost/jBPMTest</property>
<property name="hibernate.connection.username">sa</property>
<property name="hibernate.connection.password"></property>

......

Please help me in resolving this issue.

d · **Joined:** Mon Jul 04, 2005 5:19 pm **Posts:** 720

is this something that has worked in the past. you might want to try a different driver.

aspratap · **Joined:** Tue Oct 11, 2005 1:48 am **Posts:** 4

Previously I had ran it on an in-memory database of HSQLDB. Now I am trying to connect to a database server. I made sure that the database server is running fine. I was able to connect to the DB server using database manager.