Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp
[b]Hibernate version:[/b]
3.1.3
[b]Mapping documents:[/b]
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.bancassurance.test.Test" table="TESTTAB">
<id name="id" column="ID"><generator class="native" /></id>
<property name="name" column="NAME"/>
</class>
</hibernate-mapping>
[b]Code between sessionFactory.openSession() and session.close():[/b]
Transaction tx = null;
Session session = null;
try {
session = HibernateUtil.currentSession();
tx = session.beginTransaction();
Test t = new Test();
t.setName("merin");
session.save(t);
tx.commit();
HibernateUtil.closeSession();
}catch(Exception e)
{
e.printStackTrace();
}
[b]Full stack trace of any exception that occurs:[/b]
log4j:INFO Using URL [file:/D:/Merin/eclipse-SDK-3.1.2-win32/eclipse/Workspace/First/WEB-INF/classes/log4j.properties] for automatic log4j configuration of repository named [default].
12:27:20,062 INFO Environment:479 - Hibernate 3.1.3
12:27:20,077 INFO Environment:509 - hibernate.properties not found
12:27:20,077 INFO Environment:525 - using CGLIB reflection optimizer
12:27:20,077 INFO Environment:555 - using JDK 1.4 java.sql.Timestamp handling
12:27:20,171 INFO Configuration:1308 - configuring from resource: /hibernate.cfg.xml
12:27:20,171 INFO Configuration:1285 - Configuration resource: /hibernate.cfg.xml
12:27:20,468 INFO Configuration:469 - Reading mappings from resource: com/bancassurance/test/Test.hbm.xml
12:27:20,608 INFO HbmBinder:309 - Mapping class: com.bancassurance.test.Test -> TESTTAB
12:27:20,640 INFO Configuration:1419 - Configured SessionFactory: null
12:27:20,733 INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
12:27:20,733 INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
12:27:20,733 INFO DriverManagerConnectionProvider:45 - autocommit mode: false
12:27:20,733 INFO DriverManagerConnectionProvider:80 - using driver: org.hsqldb.jdbcDriver at URL: jdbc:hsqldb:hsql://localhost
12:27:20,733 INFO DriverManagerConnectionProvider:86 - connection properties: {user=sa, password=****}
12:27:20,858 WARN SettingsFactory:103 - Could not obtain connection metadata
java.sql.SQLException: Connection is broken: Transfer corrupted
at org.hsqldb.jdbc.jdbcUtil.sqlException(jdbcUtil.java:67)
at org.hsqldb.jdbc.jdbcConnection.getAutoCommit(jdbcConnection.java:931)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:112)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1881)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1174)
at com.stabilix.util.HibernateUtil.<clinit>(HibernateUtil.java:19)
at com.stabilix.hibernate.TestHib.testConnection(TestHib.java:49)
at com.stabilix.hibernate.TestHib.main(TestHib.java:71)
12:27:20,889 INFO Dialect:103 - Using dialect: org.hibernate.dialect.HSQLDialect
12:27:20,905 INFO TransactionFactoryFactory:31 - Using default transaction strategy (direct JDBC transactions)
12:27:20,921 INFO TransactionManagerLookupFactory:33 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
12:27:20,921 INFO SettingsFactory:125 - Automatic flush during beforeCompletion(): disabled
12:27:20,921 INFO SettingsFactory:129 - Automatic session close at end of transaction: disabled
12:27:20,921 INFO SettingsFactory:144 - Scrollable result sets: disabled
12:27:20,921 INFO SettingsFactory:152 - JDBC3 getGeneratedKeys(): disabled
12:27:20,921 INFO SettingsFactory:160 - Connection release mode: auto
12:27:20,921 INFO SettingsFactory:187 - Default batch fetch size: 1
12:27:20,921 INFO SettingsFactory:191 - Generate SQL with comments: disabled
12:27:20,921 INFO SettingsFactory:195 - Order SQL updates by primary key: disabled
12:27:20,921 INFO SettingsFactory:338 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
12:27:20,921 INFO ASTQueryTranslatorFactory:24 - Using ASTQueryTranslatorFactory
12:27:20,921 INFO SettingsFactory:203 - Query language substitutions: {}
12:27:20,921 INFO SettingsFactory:209 - Second-level cache: enabled
12:27:20,921 INFO SettingsFactory:213 - Query cache: disabled
12:27:20,921 INFO SettingsFactory:325 - Cache provider: org.hibernate.cache.NoCacheProvider
12:27:20,921 INFO SettingsFactory:228 - Optimize cache for minimal puts: disabled
12:27:20,921 INFO SettingsFactory:237 - Structured second-level cache entries: disabled
12:27:20,936 INFO SettingsFactory:257 - Echoing all SQL to stdout
12:27:20,936 INFO SettingsFactory:264 - Statistics: disabled
12:27:20,936 INFO SettingsFactory:268 - Deleted entity synthetic identifier rollback: disabled
12:27:20,936 INFO SettingsFactory:283 - Default entity-mode: pojo
12:27:20,983 INFO SessionFactoryImpl:154 - building session factory
12:27:21,374 INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
12:27:21,374 INFO SchemaUpdate:115 - Running hbm2ddl schema update
12:27:21,374 INFO SchemaUpdate:126 - fetching database metadata
12:27:21,389 ERROR SchemaUpdate:134 - could not get database metadata
java.sql.SQLException: Connection is broken: Transfer corrupted
at org.hsqldb.jdbc.jdbcUtil.sqlException(jdbcUtil.java:67)
at org.hsqldb.jdbc.jdbcConnection.getAutoCommit(jdbcConnection.java:931)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:112)
at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:27)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:127)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:296)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1176)
at com.stabilix.util.HibernateUtil.<clinit>(HibernateUtil.java:19)
at com.stabilix.hibernate.TestHib.testConnection(TestHib.java:49)
at com.stabilix.hibernate.TestHib.main(TestHib.java:71)
12:27:21,389 ERROR SchemaUpdate:165 - could not complete schema update
java.sql.SQLException: Connection is broken: Transfer corrupted
at org.hsqldb.jdbc.jdbcUtil.sqlException(jdbcUtil.java:67)
at org.hsqldb.jdbc.jdbcConnection.getAutoCommit(jdbcConnection.java:931)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:112)
at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:27)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:127)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:296)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1176)
at com.stabilix.util.HibernateUtil.<clinit>(HibernateUtil.java:19)
at com.stabilix.hibernate.TestHib.testConnection(TestHib.java:49)
at com.stabilix.hibernate.TestHib.main(TestHib.java:71)
12:27:21,452 WARN JDBCExceptionReporter:71 - SQL Error: -3, SQLState: 08003
12:27:21,452 ERROR JDBCExceptionReporter:72 - Connection is broken: Transfer corrupted
org.hibernate.exception.JDBCConnectionException: Cannot open connection
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:129)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290)
at com.stabilix.hibernate.TestHib.testConnection(TestHib.java:50)
at com.stabilix.hibernate.TestHib.main(TestHib.java:71)
Caused by: java.sql.SQLException: Connection is broken: Transfer corrupted
at org.hsqldb.jdbc.jdbcUtil.sqlException(jdbcUtil.java:67)
at org.hsqldb.jdbc.jdbcConnection.getAutoCommit(jdbcConnection.java:931)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:112)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
... 6 more
[b]Name and version of the database you are using:[/b]
HSQLDB Server 1.8.0
Hi,
I am trying to run a basic application with hibernate and HSQLDB. I have a table already created in the database and I am trying to insert a record in it. I am not able to establish the connection. The configuration and error details are mentioned above.
Please help.
Thanks & Regards
Merin
Login
FAQ
Search
