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.

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?

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.