I just downloaded postgres and the jdbc driver, have both installed, but 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
Anybody seen anything like this before??Please help.