[wrappingduke]

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.

[wrappingduke]

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.