aspose file tools*
The moose likes JDBC and the fly likes HSQL problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "HSQL problem" Watch "HSQL problem" New topic
Author

HSQL problem

Matt Sall
Greenhorn

Joined: Jul 01, 2007
Posts: 19
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.



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
Greenhorn

Joined: Jul 01, 2007
Posts: 19
Problem solved, it was a driver mismatch between server and client.
G.T. Reddy
Ranch Hand

Joined: Jun 25, 2002
Posts: 45

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


could you please elaborate the above solution.

Thanks,
Reddy
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: HSQL problem
 
Similar Threads
Cannot open connection issue
jdbc hsqldb issue - table not found
HSQLDB Connection not established
HSQL Database error
sqlexception with hsqldb-please help