RE: Need help getting JDBC setup. - Mailing list pgsql-interfaces
From | Peter Mount |
---|---|
Subject | RE: Need help getting JDBC setup. |
Date | |
Msg-id | 1B3D5E532D18D311861A00600865478CF1AFA8@exchange1.nt.maidstone.gov.uk Whole thread Raw |
In response to | Need help getting JDBC setup. (Marcus Alday <alday@home.com>) |
List | pgsql-interfaces |
Hmmm, this is a wierd one. I can't see anything wrong with either your pg_hba.conf, nor the java code. What happens if you change password to crypt in pg_hba.conf? (crypt is virtually the same as password) -- Peter Mount Enterprise Support Maidstone Borough Council Any views stated are my own, and not those of Maidstone Borough Council -----Original Message----- From: Marcus Alday [mailto:alday@home.com] Sent: Monday, June 26, 2000 10:23 AM To: pgsql-interfaces@postgresql.org Subject: [INTERFACES] Need help getting JDBC setup. Hi, I'm trying to get the JDBC driver to interface with my database, and I can't, for the life of me, figure out what's going on. I am hoping one of the postgresql gurus out there could help me out a little. I'm running RedHat 6.2, and I'm running the standard Posgresql distribution that came with RedHat. I believe it's 6.5.2. I have downloaded the JDBC drivers and installed them at /usr/lib/pgsql/jdbc6.5.2.jar I have modified the pg_hba.conf file to have the line host all 127.0.0.1 255.255.255.255 password I have added a user 'client' by doing a 'CREATE USER client SET PASSWORD password' ( or something like that. The password is not 'password') Here is the java code I have to try and test this /*** Code from aw_pgsql_book.pdf pg 191* **/ import java.io.*; import java.sql.*; public class test { Connection conn; Statement stmt; String state_code; public test() throws ClassNotFoundException, FileNotFoundException, IOException, SQLException { Class.forName("postgresql.Driver"); conn = DriverManager.getConnection("jdbc:postgresql:coffeebreak","client","password "); stmt = conn.createStatement(); ResultSet res = stmt.executeQuery ( "SELECT * FROM coffees"); if(res != null) { while(res.next()) { String str1 = res.getString(1); System.out.println(str1); } } res.close(); stmt.close(); conn.close(); } public static void main(String args[]) { try { test t = newtest(); } catch( Exception e ) { System.err.println("Exceptioncaught: " + e ); e.printStackTrace(); } } } And the error I get is this: Exception caught: Something unusual has occured to cause the driver to fail. Please report this exception: java.sql.SQLException: Password authentication failed for user 'client' Something unusual has occured to cause the driver to fail. Please report this exception: java.sql.SQLException: Password authentication failed for user 'client' at postgresql.Driver.connect(Driver.java, Compiled Code) at java.sql.DriverManager.getConnection(DriverManager.java, Compiled Code) at java.sql.DriverManager.getConnection(DriverManager.java, Compiled Code) at test.<init>(test.java, Compiled Code) at test.main(test.java, Compiled Code) Now I'm not sure why I'm getting an authentication error, as I'm using the correct password in my code. Does anyone have an idea? thanks marcus alday alday@home.com
pgsql-interfaces by date: