shell scripting with HSQLDB
Hello,
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.
shell scripting with HSQLDB
As mentioned in the previous post, I was able to use inline authentication successfully with the script, so the script is fine. I agree it's hard to determine what the error is if I don't know what the error is. That is why if how to make the shell interactive, i.e. visibile to see what error is returned. I also tried piping the result (if any) into a file, e.g. > test1.txt, but to no avail.
any help is appreciated.