Re: JDBC java.net.BindException connecting to Postgres 7.4 running on Cygwin Win2K

I'm getting the exception below when I try to connect to my locally
running instance of Postgres 7.4 (via Cygwin on Win2K). I'm trying to
connect via a DataSource configured with Tomcat 4.1.24. I can connect to
instances of Postgres this way on other machines, just not my locally
running instance. I can connect to the local instance just fine using
psql (with or without using TCP/IP via '-h 127.0.0.1') and applications
like pgAdmin are able to connect to it as well. This looks like the same
error noted in

http://archives.postgresql.org/pgsql-jdbc/2003-07/msg00058.php

but I didn't find any followups that addressed the problem for me (this
error happens every time I try to get a connection, including the first
attempt when there are no active connections to the database).

Has anyone been able to find a solution to this error?

Thanks in advance,
Matt

java.net.BindException: Address already in use: 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.core.PGStream.<init>(PGStream.java:47)
at
org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:197)
at org.postgresql.Driver.connect(Driver.java:139)
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:184)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source)
at
org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:117)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312)
[snip]

One other piece of the puzzle is that when I don't connect via the
Tomcat DataSource, i.e. I use the DriverManager, the connection works!

-- m@

Matt Magoffin wrote:

> java.net.BindException: Address already in use: 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.core.PGStream.<init>(PGStream.java:47)
> at
> org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc1Connection.java:197)
>
> at org.postgresql.Driver.connect(Driver.java:139)
> at
> org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
>
> at
> org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:184)
>
> at
> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown
> Source)
> at
> org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:117)
>
> at
> org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
>
> at
> org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312)
>
> [snip]

On 24/12/2003 23:32 Matt Magoffin wrote:
> I'm getting the exception below when I try to connect to my locally
> running instance of Postgres 7.4 (via Cygwin on Win2K). I'm trying to
> connect via a DataSource configured with Tomcat 4.1.24. I can connect to
> instances of Postgres this way on other machines, just not my locally
> running instance. I can connect to the local instance just fine using
> psql (with or without using TCP/IP via '-h 127.0.0.1') and applications
> like pgAdmin are able to connect to it as well. This looks like the same
> error noted in
>
> http://archives.postgresql.org/pgsql-jdbc/2003-07/msg00058.php
>
> but I didn't find any followups that addressed the problem for me (this
> error happens every time I try to get a connection, including the first
> attempt when there are no active connections to the database).
>
> Has anyone been able to find a solution to this error?
>
> Thanks in advance,
> Matt
>
> java.net.BindException: Address already in use: connect

Its a Windows thing. I suggest following the links provided in the posting.

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+