wrappingduke
04-05-2008, 01:22 AM
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:path/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.
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:path/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.