User Name Password Register
DaniWeb IT Discussion Community
All
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
Reply
Join Date: Jul 2008
Posts: 10
Reputation: wrappingduke is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 0
wrappingduke wrappingduke is offline Offline
Newbie Poster

jdbc connection w/ config file

  #1  
28 Days Ago
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.
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Jul 2008
Posts: 10
Reputation: wrappingduke is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 0
wrappingduke wrappingduke is offline Offline
Newbie Poster

Re: jdbc connection w/ config file

  #2  
26 Days Ago
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.
Last edited by wrappingduke : 26 Days Ago at 2:47 pm. Reason: typo
Reply With Quote  
Join Date: Jul 2008
Posts: 1
Reputation: pks_compete is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
pks_compete pks_compete is offline Offline
Newbie Poster

Re: jdbc connection w/ config file

  #3  
22 Days Ago
anyone who cn help me for a mini project in java...........urgent plz
Reply With Quote  
Join Date: May 2007
Location: USA
Posts: 2,602
Reputation: Ezzaral is just really nice Ezzaral is just really nice Ezzaral is just really nice Ezzaral is just really nice Ezzaral is just really nice 
Rep Power: 11
Solved Threads: 257
Featured Poster
Ezzaral's Avatar
Ezzaral Ezzaral is online now Online
Posting Maven

Re: jdbc connection w/ config file

  #4  
21 Days Ago
Do not hijack threads for completely unrelated (and poorly written) requests for help.

Especially not with "urgent plz" in it.
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

DaniWeb Java Marketplace
Thread Tools Display Modes

Similar Threads
Other Threads in the Java Forum

All times are GMT -4. The time now is 11:57 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC