Re: JDBC driver problem ? - Mailing list pgsql-jdbc

From Daniel Serodio
Subject Re: JDBC driver problem ?
Date
Msg-id 1036764282.24409.23.camel@kelly
Whole thread Raw
In response to JDBC driver problem ?  (Alex Dovlecel <dovle@kbs.twi.tudelft.nl>)
Responses Re: JDBC driver problem ?  (Alex Dovlecel <dovle@kbs.twi.tudelft.nl>)
List pgsql-jdbc
The "FATAL 1" message comes from the backend (server), so this means
you're able to connect to it at the network level, so it must be running
with -i.

It's probably a problem in the authentication setup of the server.
(pg_hba.conf). I don't know which types of authentication the driver
supports, but we use "trust" for our internal network:

host         all         192.168.0.0   255.255.0.0         trust

On Fri, 2002-11-08 at 11:34, Alex Dovlecel wrote:
> Hello to all,
> This is my first question, so don't be mad if it is gonna be a silly one.
>
> I have a psql account on a psql server that runs psql 7.2.1. I want to
> connect to it by using java (jdbc).
>
> I downloaded the JDBC 2.0 driver (pgjdbc2.jar) and I am doing the following:
>
> System.out.println(" + Loading the driver" );
> Class.forName( "org.postgresql.Driver" ) ;
>
> System.out.println(" + Creating a connection " );
> con = DriverManager.getConnection(
>         "jdbc:postgresql://myserver:5432/Test",
>         "myaccount",
>         "mypasswd" ) ;
>
> Loading the driver works. But can't obtain a connection due to:
>
> Exception: Something unusual has occured to cause the driver to fail. Please
> report this exception: Exception: java.sql.SQLException: FATAL 1:  Password
> authentication failed for user "dovle"
>
> Stack Trace:
>
> java.sql.SQLException: FATAL 1:  Password authentication failed for user
> "myaccount"
>
>         at org.postgresql.Connection.openConnection(Connection.java:178)
>         at org.postgresql.Driver.connect(Driver.java:149)
>         at java.sql.DriverManager.getConnection(DriverManager.java:512)
>         at java.sql.DriverManager.getConnection(DriverManager.java:171)
>         at Main.main(Main.java:18)
> End of Stack Trace
>
>
> But the password is correct!!!
>
> What could be wrong ?
>
> What should happen if the postgres does not run with the -i parameter ? Could
> this be the wrong thing that happened ?
>
> dovle
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
[]'s
Daniel Serodio


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: possible memory leak??
Next
From: "Michael Paesold"
Date:
Subject: Re: possible memory leak??