If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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.

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.