Re: socket problem - Mailing list pgsql-jdbc
| From | Scot P. Floess |
|---|---|
| Subject | Re: socket problem |
| Date | |
| Msg-id | 3E6CB90B.8040308@mindspring.com Whole thread Raw |
| In response to | socket problem ("Brian Harris" <brian.harris@optdatainc.com>) |
| List | pgsql-jdbc |
Brian:
Can you connect using psql? Also, make sure you are using the default port where postgres is running - as I can see by your URI that you are using the default port. One other thing, you could try netstat on the machine where postgres is running to make sure it is listening on the port you assume it is.
Scot
Brian Harris wrote:
Can you connect using psql? Also, make sure you are using the default port where postgres is running - as I can see by your URI that you are using the default port. One other thing, you could try netstat on the machine where postgres is running to make sure it is listening on the port you assume it is.
Scot
Brian Harris wrote:
> when I try to connect via remote host I get this error:
>
> The connection attempt failed because Exception:
> java.net.SocketException: Connection reset by peer: connect
> Stack Trace:
> java.net.SocketException: Connection reset by peer: connect
> at java.net.PlainSocketImpl.socketConnect(Native Method)
> at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
> at
> java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:171)
> at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:158)
> at java.net.Socket.connect(Socket.java:426)
> at java.net.Socket.connect(Socket.java:376)
> at java.net.Socket.<init>(Socket.java:291)
> at java.net.Socket.<init>(Socket.java:119)
> at org.postgresql.PG_Stream.<init>(PG_Stream.java:38)
> at
> org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:160)
> at org.postgresql.Driver.connect(Driver.java:122)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:193)
> at optdata.zbeans.ZServerJdbc.createConnection(ZServerJdbc.java:85)
> at atrs.utility.dbclean.CvtReti.<init>(CvtReti.java:29)
> at atrs.utility.dbclean.CvtReti.main(CvtReti.java:161)
> End of Stack Trace
> at
> org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:171)
> at org.postgresql.Driver.connect(Driver.java:122)
> at java.sql.DriverManager.getConnection(DriverManager.java:512)
> at java.sql.DriverManager.getConnection(DriverManager.java:193)
> at optdata.zbeans.ZServerJdbc.createConnection(ZServerJdbc.java:85)
> at atrs.utility.dbclean.CvtReti.<init>(CvtReti.java:29)
> at atrs.utility.dbclean.CvtReti.main(CvtReti.java:161)
> java.lang.NullPointerException
> at atrs.utility.dbclean.CvtReti.<init>(CvtReti.java:30)
> at atrs.utility.dbclean.CvtReti.main(CvtReti.java:161)
> My connection string looks like this:
> jdbc:postgresql://190.85.90.37/test?user=BrianH
> postmaster started with -i
> Anybody seen anything like this before??Please help.
-- Scot P. Floess - 27 Lake Royale - Louisburg, NC 27549 - 252-478-8087 Open Source Home Page -------------------------------------- http://javapim.sourceforge.net http://jplate.sourceforge.net http://jwaretechniques.sourceforge.net Open Source Project Host ----------------------------------------------- http://sourceforge.net/projects/javapim http://sourceforge.net/projects/jplate http://sourceforge.net/projects/jwaretechniques
pgsql-jdbc by date: