Lists: | pgsql-jdbc |
---|
From: | Tony Smith <quickome(at)yahoo(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | remote connection with JDBC |
Date: | 2004-11-21 17:30:00 |
Message-ID: | 20041121173000.77040.qmail@web41604.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-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!
From: | Kris Jurka <books(at)ejurka(dot)com> |
---|---|
To: | Tony Smith <quickome(at)yahoo(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: remote connection with JDBC |
Date: | 2004-11-21 20:29:22 |
Message-ID: | Pine.BSO.4.56.0411211524320.24919@leary.csoft.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
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
From: | Tony Smith <quickome(at)yahoo(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: remote connection with JDBC |
Date: | 2004-11-22 04:55:55 |
Message-ID: | 20041122045555.84774.qmail@web41610.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-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!
From: | Kris Jurka <books(at)ejurka(dot)com> |
---|---|
To: | Tony Smith <quickome(at)yahoo(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: remote connection with JDBC |
Date: | 2004-11-22 05:42:48 |
Message-ID: | Pine.BSO.4.56.0411220039440.3486@leary.csoft.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
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