04-05-2008, 01:22 AM
|
|
Pupil
Join Date: Mar 2008
Posts: 13
|
|
shell scripting with HSQLDB
Attempting to execute sql scripts against HSQLDB database using windows shell, but to no avail. I'm trying to use to RC file or config file to authenticate
db connection. Unfortunately, I don't know how to make the shell visible to determine what error I'm receving, since it's using the method (non-interactive). I've tried the /i switch to make interactive.
I've successfully used inline authentication, e.g.,
java -jar path\to\hsqldb.jar --inlineRc URL=jdbc:hsqldb:file ath/to/database/db1,USER=sa
Here's a sample of what I've done:
in config file, i have the following:
urlid personal
url jdbc:hsqldb:file:/path/to/database/db1;shutdown=true
username sa
password
in windows batch file, i have the following:
java -jar /path/to/database/db1 personal /path/to/script/script1.sql
Lastly, I've tried "/" as well "\", neither has worked.
any help is appreciated.
|
| |
|
|
|
|
|
|
Threaded Mode