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

Tx for the answer,
Glad to hear this... but I have no clue about what should I do next

I had tried to use an older driver (7.1 driver, jar called like this:
jdbc7.1-1.2.jar) but gives me the following exception :

Exception: The authentication type 5 is not supported. Check that you have
configured the pg_hba.conf file to include the clients IP address or Subnet,
and that it is using an authentication scheme supported by the driver.

Do you have any sugestions?

Tx,
dovle


> 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