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

any help is appreciated.

Recommended Answers

All 3 Replies

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

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

any help is appreciated.

anyone who cn help me for a mini project in java...........urgent plz

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

Especially not with "urgent plz" in it.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.