0

hello,

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.

3
Contributors
3
Replies
4
Views
9 Years
Discussion Span
Last Post by Ezzaral
0

Changed command and was able to gain access to the config file, however, now receiving error w/ authenitication parameters. Here's the error rec'v:

Failed to retrieve connection info for database 'urlid': url or username or password not set for
'urlid' in file '\path\to\sqltool.rc'

The changed command is as follows:

java -jar /path/to/hsqldb.jar --rcfile /path/to/sqltool.rc urlid personal /path/to/Export_Data.sql 2>err.txt

The parameters in the config file for authentication are:

# A personal, local, persistent database 
urlid personal
url jdbc:hsqldb:file:/path/to/database/MyDB1;shutdown=true
username sa
password

My guess is that the password needs to be filled but a password is not required for HSQL

any help is appreciated.

0

Do not hijack threads for completely unrelated (and poorly written) requests for help.

Especially not with "urgent plz" in it.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.