Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

java.sql.SQLException: Address already in use: connect

843854Oct 10 2002 — edited Aug 14 2003
We are running 3 webservers, all are Dual PIII, NT4 sp6a machines. All machines run a Tomcat webserver and One machine hosts a SQL server database as well. The two machines that do not host the SQL server database frequently (but intermittently) report the following error when trying to connect to the SQL server machine. The machine that hosts the SQL server (and is most heavily used) does not report the problem.

java.sql.SQLException: [AVEConnect][JDBC SQL Server Driver] Address already in use: connect
at net.avenir.jdbc2.x.<init>(Unknown Source)
at net.avenir.jdbc2.Driver.connect(Driver.java:399)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)

Nothing strange appears in netstat and there are very few connections established or in TIME_WAIT on the problem machines compared to the OK machine.
Port scans also show that there are no hanging connections blocking port 1433.
The problem occurs whether the connection is across the firewall or not.
Nothing is entered in any log indicating a system or application problem and there are no processes blocking the call in SQL server.

I'm stumped, any ideas?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2003
Added on Oct 10 2002
6 comments
356 views