Re: remote connection with JDBC

Hi,

I am trying to connect postgresql database from a remote pc. Here is my code:

Class.forName("org.postgresql.Driver");
Connection conn = DriverManager.getConnection("jdbc:postgresql://machine.mylbl.gov:5432/mydatabase", "username", "passwd");

But I always get the following exception:

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

Exception: java.io.EOFException

Stack Trace:

java.io.EOFException

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

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

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

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

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

at org.postgresql.jdbc2.Jdbc2Connection.<init>(Jdbc2Connection.java:15)

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

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

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

at Test.main(Test.java:29)

End of Stack Trace

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

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

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

at org.postgresql.jdbc2.Jdbc2Connection.<init>(Jdbc2Connection.java:15)

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

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

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

at Test.main(Test.java:29)

Why:

Thanks,

Tony

---------------------------------
Do you Yahoo!?
Discover all thats new in My Yahoo!

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

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!

On Sun, 21 Nov 2004, Tony Smith wrote:

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

This unfortunately doesn't tell what the real problem is. Please check
your server log file to determine what's happening on the server side
of the connection. Also you did not include what authentication method
you were using (or server version) to help narrow down the problem.

Kris Jurka