hsqldb and jenny the db code generator

[James Bacon]

Hi,
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'.

package src.testdb;
import java.sql.*;
import java.util.* ;
import src.testdb.*;
import src.testdb.SampleTable.*;
public class testdb {
    public static void main(String[] args) throws Exception {
        SampleTable.Row row = SampleTable.getRow(SampleTable.strColColumnName,"Honda");
        System.out.println( "ID=" + row.getID() + "NumCol=" + row.getNumCol() );
     }
}

and here is my properties file:

 
Driver=org.hsqldb.jdbcDriver
URL=jdbc:hsqldb:hsql://localhost
UserName=***#left out for security
Password=***#left out for security
Destination=/Program Files/hsqldb/hsqldb/src/testdb/jennydb/
Package=src.testdb
Facade=mydbFacade
FacadeDriver=org.hsqldb.jdbcDriver
FacadeURL=jdbc:hsqldb:hsql://localhost
FacadeUserName=***#left out for security
FacadePassword=***#left out for security
MockDestination=/Program Files/hsqldb/hsqldb/src/testdb/jennydb/

I am relatively new to hsqldb. Can anyone help me with my code exception? Thanks.
James
[ April 13, 2004: Message edited by: James Bacon ]