• 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

Problems Starting HSQLDB server

 
Ranch Hand
Posts: 59
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
I have downloaded HSQLDB and copied it to C:\hsqldb folder.
I added C:\hsqldb\lib\hsqldb.jar file to CLASSPATH and tried to run the server by C:\hsqldb\bin\runServer.bat, which is giving the following error.is there any thing left Apart from setting the CLASSPATH?
Please help me to resolve this issue.
Thanks in advance.
--Deepika.
 
Deepika Saxena
Ranch Hand
Posts: 59
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
please find some more information on this issue.
HSQLDB : hsqldb-1.9.0-rc4.zip
OS : WinXP
JDk : jdk1.6.0_14
CLASSPATH setting: C:\set classpath="c:\hsqldb\lib\hsqldb.jar;.;"
*********************************************************
Error :is there any setting that i am missing? please help.
Thanks.
--Deepika.
 
Sheriff
Posts: 10445
227
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Where is the hsqldb.jar located and does it contain the org.hsqldb.Server class?
 
Ranch Hand
Posts: 32
Hibernate Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Here hsqldb.jar build with java 1.4 so you have to rebuild it with java 1.6

steps
1. use command "ant jar" for rebuild hsqldb.jar it will create new hsqldb.jar and place it in lib folder

2. Use command "C:\hsqldb-1.9.0-rc4\hsqldb\bin>java -classpath ..\lib\hsqldb.jar org.hsqldb.util
.DatabaseManager" to run server

Thanks
Tekchand
 
Deepika Saxena
Ranch Hand
Posts: 59
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks jaikiran and Tekchand.
Jai, the jar file IS located in

c:\hsqldb\lib

folder. but it doesn't contain Server.class file.I followed all the steps that Tekchand suggested and regenerated the jar file.still the Servler.class is missing from the jar file and throwing the same exception kindly tell me how to get that class in the jar file.
Thanks for your valuable help.
--Deepika.
 
Tekchand Prasad
Ranch Hand
Posts: 32
Hibernate Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Use command "C:\hsqldb-1.9.0-rc4\hsqldb\bin>java -classpath ..\lib\hsqldb.jar org.hsqldb.util
.DatabaseManager" to run server

and let me know if error comes
 
Greenhorn
Posts: 18
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
In runServer.bat, the path of Server class is incorrect
Change it to org.hsqldb.server.Server and then run. It works
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic