wood burning stoves*
The moose likes JDBC and the fly likes hsqldb and jenny the db code generator Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "hsqldb and jenny the db code generator" Watch "hsqldb and jenny the db code generator" New topic

hsqldb and jenny the db code generator

James Bacon

Joined: Apr 13, 2004
Posts: 4
When I run my code using jenny I get the following exception:
java.sql.SQLException: Connection is broken: Software caused connection abort: socket write error
at org.hsqldb.Trace.getError(Unknown Source)
at org.hsqldb.Trace.error(Unknown Source)
at org.hsqldb.jdbcConnection.executeHSQL(Unknown Source)
at org.hsqldb.jdbcConnection.execute(Unknown Source)
at org.hsqldb.jdbcConnection.close(Unknown Source)
at com.javaranch.db.DBFacade.search(DBFacade.java:370)
at com.javaranch.db.DBFacade.search(DBFacade.java:393)
at com.javaranch.db.TableFacade.search(TableFacade.java:61)
at src.testdb.SampleTable$Implementation.getRow(SampleTable.java:145)
at src.testdb.SampleTable.getRow(SampleTable.java:439)
at src.testdb.testdb.main(testdb.java:138)
Exception in thread "main"

I am using J2SE v1.4.2-b28 and hsqldb v1.7.1. I downloaded jenny's jar yesterday. My code is a very simple query to a populated database table called 'sample_table'.

and here is my properties file:

I am relatively new to hsqldb. Can anyone help me with my code exception? Thanks.
[ April 13, 2004: Message edited by: James Bacon ]
I agree. Here's the link: http://aspose.com/file-tools
subject: hsqldb and jenny the db code generator