HSQL problem

[Matt Sall]

Hi,

I have started a HSQL server on a linux machine. I can reach it with the database manager, and do select and update querys and everything works fine. However when trying to use the SELECT statment from java code in eclipse an exception is thrown; java.sql.SQLEXception: Connection is broken : Transfer corrupt. But I can do UPDATE, no problem with that.

    
Connection conn=null;
Statement statement=null;
Class.forName("org.hsqldb.jdbcDriver");
conn = DriverManager.getConnection("jdbc:hsqldb:hsql://192.168.0.2:9001/db", "sa", "");
statement = conn.createStatement(); //This works
 
System.out.println(conn.isClosed()); //prints out "false"
 
String expression = "SELECT * FROM PUBLIC.BOOKS";
ResultSet rs = statement.executeQuery(expression); //does NOT works, throws java.sql.SQLException: Connection is broken. Transfer corrupt
 
statement.executeUpdate("INSERT INTO publishers (id, name) VALUES ('1', 'a Name'"); //This works flawlessly (I do have to comment out the the executeQuery above though..)
 
rs.close();
statement.close();
conn.close();
 
//try/catch-cluases removed
      

Server is started with "java org.hsqldb.Server -database dataBase -dbname db -address 192.168.0.2 -port 9001 -silent false -trace true"
Wher dataBase is the name in dataBase.lck, dataBase.script, dataBase.properties, dataBase.log.
The table data is loaded from the script-file when the server starts, could this be the problem?

I can see on my server that user SA is trying to connect, but is the disconnected, any ideas or better still, solutions?

Kind regards,
Mattias

[Matt Sall]

Problem solved, it was a driver mismatch between server and client.

[G.T. Reddy]

Problem solved, it was a driver mismatch between server and client.


could you please elaborate the above solution.

Thanks,
Reddy