•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Java section within the Software Development category of DaniWeb, a massive community of 392,070 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,270 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Java advertiser: Lunarpages Java Web Hosting
Views: 268 | Replies: 3
![]() |
•
•
Join Date: Jul 2008
Posts: 10
Reputation:
Rep Power: 1
Solved Threads: 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:
The config file, sqltool.rc is setup as follows:
any help is appreciated.
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.
•
•
Join Date: Jul 2008
Posts: 10
Reputation:
Rep Power: 1
Solved Threads: 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:
The parameters in the config file for authentication are:
My guess is that the password needs to be filled but a password is not required for HSQL
any help is appreciated.
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.
Last edited by wrappingduke : 26 Days Ago at 2:47 pm. Reason: typo
![]() |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Java Marketplace
Other Threads in the Java Forum
- Previous Thread: buttons not visible at screen startup??
- Next Thread: class question



Linear Mode