AppletTalk.com

ala_halasa · Guest

Hello Group, I have an issue with hsqldb and need your help.
brief of problem is: how could I shutdown hsqldb server by command
line ?
the issue:
I have hsqldb database that has a table from csv file. there is a
script reads from the csv file. Once the script read from the file,
the db locked from writing to the csv file. The server is running by
the following command,
java org.hsqldb.Server server.properties,
What I am trying to do is to shutdown the db before access it from the
script.
I tried to use the following command:
java org.hsqldb.util.ShutdownServer mydb
and it reurns the following error:
java.sql.SQLException: S1000 General error java.lang.RuntimeException:
database alias does not exist
I tried all the possible aliases I could have:
jdbc:hsqldb:hsql://localhost:9001/mydb
and
the full path of the db
and
this is the server.properties file:

server.port=9001
server.database.0=file:/home/logs/svn/server/araby_db
server.dbname.0=araby_db
#server.no_system_exit=true

Please help me or give me suggestion as soon as possible