1 Reply Latest reply on Oct 12, 2005 3:31 PM by Ronald van Kuijk

    Hibernate HSQLDB Issue

    Sivajee Akula Newbie

      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.