Problem with Hibernate 2.x and HSQLDB 1.8.0

wassup · **Posted:** Wed Jul 06, 2005 11:12 am

I am trying to use latest version of HSQLDB (1.8.0) with Hibernate (2.1.8) but I have strange exception. See stacttrace below. With 1.7.3.3 version my application work well.

This is my config file

Code:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD//EN"
        "http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
  <session-factory>
    <property name="show_sql">true</property>
    <property name="use_outer_join">false</property>
    <property name="hibernate.connection.autocommit">true</property>
    <property name="hibernate.hbm2ddl.auto">create</property>
    <property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
    <property name="connection.username">sa</property>
    <property name="connection.password"/>
    <property name="hibernate.connection.url">jdbc:hsqldb:hsql://localhost</property>
    <property name="dialect">net.sf.hibernate.dialect.HSQLDialect</property>
  </session-factory>
</hibernate-configuration>

When I connect to hsqldb using sqirrel client to jdbc:hsqldb:hsql://localhost everithing works fine. I am able to create table, xecute sql.

What wrong here?? Could anybody explain me??

Code:

INFO: Server startup in 7672 ms
0    [http-8080-Processor25] ERROR net.sf.hibernate.tool.hbm2ddl.SchemaExport  - schema export unsuccessful
java.sql.SQLException: Connection is broken: Transfer corrupted
        at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.getAutoCommit(Unknown Source)
        at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:103)
        at net.sf.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:119)
        at net.sf.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:84)
        at net.sf.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:198)
        at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:805)
        at org.nanocontainer.hibernate.SessionFactoryDelegator.<init>(SessionFactoryDelegator.java:42)
        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 org.picocontainer.defaults.InstantiatingComponentAdapter.newInstance(InstantiatingComponentAdapter.java:128)
        at org.picocontainer.defaults.ConstructorInjectionComponentAdapter$1.run(ConstructorInjectionComponentAdapter.java:154)
        at org.picocontainer.defaults.ThreadLocalCyclicDependencyGuard.observe(ThreadLocalCyclicDependencyGuard.java:56)
        at org.picocontainer.defaults.ConstructorInjectionComponentAdapter.getComponentInstance(ConstructorInjectionComponentAdapter.java:182)
        at org.picocontainer.defaults.DecoratingComponentAdapter.getComponentInstance(DecoratingComponentAdapter.java:43)
        at org.picocontainer.defaults.CachingComponentAdapter.getComponentInstance(CachingComponentAdapter.java:38)
        at org.picocontainer.defaults.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:341)
        at org.picocontainer.defaults.DefaultPicoContainer.getComponentInstance(DefaultPicoContainer.java:324)
        at org.picocontainer.alternatives.ImmutablePicoContainer.getComponentInstance(ImmutablePicoContainer.java:40)
        at org.picocontainer.defaults.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:347)
        at org.picocontainer.defaults.DefaultPicoContainer.getComponentInstance(DefaultPicoContainer.java:324)
        at org.picocontainer.alternatives.ImmutablePicoContainer.getComponentInstance(ImmutablePicoContainer.java:40)
        at org.picocontainer.defaults.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:347)
        at org.picocontainer.defaults.DefaultPicoContainer.getComponentInstance(DefaultPicoContainer.java:324)
        at org.picocontainer.defaults.BasicComponentParameter.resolveInstance(BasicComponentParameter.java:80)
        at org.picocontainer.defaults.ComponentParameter.resolveInstance(ComponentParameter.java:117)
        at org.picocontainer.defaults.ConstructorInjectionComponentAdapter.getConstructorArguments(ConstructorInjectionComponentAdapter.java:191)
        at org.picocontainer.defaults.ConstructorInjectionComponentAdapter$1.run(ConstructorInjectionComponentAdapter.java:151)