Need help getting JDBC setup.

From: Marcus Alday <alday(at)home(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Need help getting JDBC setup.
Date: 2000-06-26 09:22:47
Message-ID: 395720E7.8493B54@home.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message frank 2000-06-26 13:46:32 Re: Help ODBC Problem
Previous Message Peter Mount 2000-06-26 08:02:43 RE: Postgres JDBC driver : problem with timestamps.