Re: socket problem

Поиск
Список
Период
Сортировка
От Scot P. Floess
Тема Re: socket problem
Дата
Msg-id 3E6CB90B.8040308@mindspring.com
обсуждение исходный текст
Ответ на socket problem  ("Brian Harris" <brian.harris@optdatainc.com>)
Список 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:
> 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
>  postmaster started with -i
> Anybody seen anything like this before??Please help.
Brian Harris
Optdata Inc/ATRS
brian.harris@optdatainc.com

-- 
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 по дате отправления:

Предыдущее
От: "Brian Harris"
Дата:
Сообщение: socket problem
Следующее
От: Per-Olof Norén
Дата:
Сообщение: Re: socket problem