shell scripting with HSQLDB

[wrappingduke]

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:fileath/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.

[Hack]

Well it is kind of difficult to offer suggestions on fixing an error if you don't know what the error is.

Are you having a problem with ALL scripts or just one or two?

[wrappingduke]

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.