Attempting to connect HSQL db by calling a config file from a java command line. However, receiving the following error message:
Failed to retrieve connection info for database 'personal': Please set up authentication file 'C:\Documents and Settings\user\sqltool.rc'
Here's a sample of the command:
java -jar \pathto\hsqldb.jar personal /pathto/Export_Data.sql 2>err.txt
The config file, sqltool.rc is setup as follows:
urlid personal url jdbc:hsqldb:file:pathto/MyDB1;shutdown=true username sa password
any help is appreciated.