Thread: remote connection with JDBC

remote connection with JDBC

From
Tony Smith
Date:
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 that�s new in My Yahoo!

Re: remote connection with JDBC

From
Kris Jurka
Date:

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

Re: remote connection with JDBC

From
Tony Smith
Date:
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@ejurka.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!

Re: remote connection with JDBC

From
Kris Jurka
Date:

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