Re: remote connection with JDBC

Hi:

Thank you for your email. I downloaded the new jar file and still got the same exception.
The error location is now different.

org.postgresql.util.PSQLException: The connection attempt failed.

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136)

at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:63)

at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:117)

at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)

at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)

at org.postgresql.Driver.connect(Driver.java:183)

at java.sql.DriverManager.getConnection(DriverManager.java:538)

at java.sql.DriverManager.getConnection(DriverManager.java:188)

at Test.main(Test.java:29)

Caused by: java.io.EOFException

at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:243)

at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:253)

at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:94)

... 8 more

Kris Jurka <books(at)ejurka(dot)com> wrote:

On Sun, 21 Nov 2004, Tony Smith wrote:

> java.io.EOFException
> at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:244)
> at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:222)

You should check in your server log file to see if it has anything
interesting to say about this failure. What authentication method are you
using (md5/crypt/password/...)? The driver shouldn't be bailing out with
an error like that, but it is unclear where the actual problem is. The
stacktrace line numbers don't match up with the current source, so it
would be helpful if you downloaded the lastest version of the driver.

http://jdbc.postgresql.org/download.html#jars

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

---------------------------------
Do you Yahoo!?
The all-new My Yahoo! Get yours free!