From: "Joe Shevland" <shevlandj@kpi.com.au>
To: "Marcus Alday" <alday@home.com>, <pgsql-interfaces@postgresql.org>
Subject: RE: Need help getting JDBC setup.
Date: Wed, 28 Jun 2000 13:36:33 +1000
Message-ID: <MJEMLFCFPOPOFFFLIIDGIEFLCAAA.shevlandj@kpi.com.au>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Importance: Normal
In-Reply-To: <395720E7.8493B54@home.com>
Content-Transfer-Encoding: 8bit

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@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
>
>
>