Hibernate HSQLDB Issue

[akula.pratap]

Hi all,

I am facing an issue while using HSQLDB1.7.3 with jBPM's Hibernate.

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

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:
....

<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:.;sql.enforce_strict_size=true</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.

[kukeltje]

Sounds like a hsqldb issue or a network issue. Maybe you can see more if you turn on debugging for the hsqldb driver. Look on the hsqldb site for that