File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Database access problems Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Database access problems" Watch "Database access problems" New topic
Author

Database access problems

tom davies
Ranch Hand

Joined: Apr 27, 2012
Posts: 168
Ok this problem has confused me, i will outline what the program does first before i tell you the issue i am having.
I have set up HSQLDB i have created a program which reads from my database.properties file and connects to the database.
I then use this connection to perform some SQL commands such as add, remove and update entries from a simple console menu. If i enter my connection details manually so the url, username, password and driver it connects fine. When doing it manually i have username and password both as "", so the value is null. It all works fine then, my menu works, i can add, delete, update and display my table. If however, i try and connect by directing my program to the details in my database.properties file which also has a blank username and password field i cannot connect, i get this error message.

Exception in thread "main" java.sql.SQLInvalidAuthorizationSpecException: invalid authorization specification - not found: SA

I wanted to see what values were being used to connect so i put a println in to display the username and password when entering my details manually and also from reading from the file.
So when i attempt to establish a connection it shows me this line first. They both display username=null and password= null but if i link to the database.properties file i get the error message mentioned above . . . .It doesn't make sense to me as if a password/username were required, why can i connect by manually setting these to "" in my connection program?

Below is the connection program, you can see in the getConnection method i have the username and password field set to "". To use the values read from the file i use username and password instead.
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

But isn't that just a repost of this thread: http://www.coderanch.com/t/594246/JDBC/databases/Connecting-database?

It looks to me as if you have ignored almost everything which was said in that thread.
tom davies
Ranch Hand

Joined: Apr 27, 2012
Posts: 168
Paul Clapham wrote:But isn't that just a repost of this thread: http://www.coderanch.com/t/594246/JDBC/databases/Connecting-database?

It looks to me as if you have ignored almost everything which was said in that thread.

Not really because i can read the file now, that is no longer the problem. The issue is that i can connect to the database by manually entering the details, but if i use the same (blank) details i read from the file it wont let me access the database and gives me the above error message. I have checked that i can read the details correctly from the properties file, the problem is explained in more detail in my first post.
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18541
    
    8

As I already said in that other thread, you aren't calling the init() method anywhere. You still aren't calling it anywhere.
tom davies
Ranch Hand

Joined: Apr 27, 2012
Posts: 168
Paul Clapham wrote:As I already said in that other thread, you aren't calling the init() method anywhere. You still aren't calling it anywhere.

Turns out i followed your advice for my test program but did not implement it into my actual program!
Apologise, and thanks for the slap round the head.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Database access problems
 
Similar Threads
Connecting to a database
Unable to register Derby driver
Help finding database.properties file in Eclipse
NullPointerException
Can not find driver?