RE: Need help getting JDBC setup. - Mailing list pgsql-interfaces
From | Joe Shevland |
---|---|
Subject | RE: Need help getting JDBC setup. |
Date | |
Msg-id | MJEMLFCFPOPOFFFLIIDGIEFLCAAA.shevlandj@kpi.com.au Whole thread Raw |
In response to | Need help getting JDBC setup. (Marcus Alday <alday@home.com>) |
List | pgsql-interfaces |
Looks all fine to me. What are the results of doing a 'psql -U' and specifying the username and password from the commandline? Regards, Joe >-----Original Message----- >From: pgsql-interfaces-owner@hub.org >[mailto:pgsql-interfaces-owner@hub.org]On Behalf Of Marcus Alday >Sent: Monday, 26 June 2000 7:23 PM >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 = new test(); > } > catch( Exception e ) > { > System.err.println("Exception caught: " + 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: