RE: Need help getting JDBC setup.

Looks all fine to me. What are the results of doing a 'psql -U' and specifying the username and password from the command line?

Regards,
Joe

>-----Original Message-----
>From: pgsql-interfaces-owner(at)hub(dot)org
>[mailto:pgsql-interfaces-owner(at)hub(dot)org]On Behalf Of Marcus Alday
>Sent: Monday, 26 June 2000 7:23 PM
>To: pgsql-interfaces(at)postgresql(dot)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(at)home(dot)com
>
>
>