This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
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

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
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!