File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Other Java Products and Servers and the fly likes Unable to create hsqldb for spring Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "Unable to create hsqldb for spring" Watch "Unable to create hsqldb for spring" New topic

Unable to create hsqldb for spring

Tyagi Ashish

Joined: Jul 12, 2009
Posts: 9
Hello there,
I have been following the spring tutorial (

When I tried to create database using following command

For Windows add:


java -classpath ..\war\WEB-INF\lib\hsqldb.jar org.hsqldb.Server -database test

Now you can open a command window, change to the 'springapp/db' directory and start the database by running one of these startup scripts. I am getting following error.

C:\RSAWorkspace\spring\firstspring\db>java -classpath ..\war\WEB-INF\lib\hsqldb.jar org.hsqldb.Server -database test
[Server@6ca1c]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@6ca1c]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@6ca1c]: [Thread[main,5,main]]: Failed to set properties
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.String.substring(Unknown Source)
at java.lang.String.substring(Unknown Source)
at org.hsqldb.server.ServerProperties.validateMultiProperty(Unknown Source)
at org.hsqldb.server.ServerProperties.validate(Unknown Source)
at org.hsqldb.server.Server.setProperties(Unknown Source)
at org.hsqldb.server.Server.main(Unknown Source)

Could anyone tell me what I am doing wrong. I am using latest hsqldb.jar file in my lib folder.
Hadi Teo

Joined: Nov 20, 2006
Posts: 1
Hi Tyagi,

I have encountered exactly the same issue. Subsequently i googled to the hsqldb user guide (

According to the user guide, the following command is recommended in order to start the server :


hadi teo
I agree. Here's the link:
subject: Unable to create hsqldb for spring
It's not a secret anymore!