• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

HSQL problem

 
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 19
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Problem solved, it was a driver mismatch between server and client.
 
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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


could you please elaborate the above solution.

Thanks,
Reddy
reply
    Bookmark Topic Watch Topic
  • New Topic