Problem with JDBC -- Eating up Ports/Processes!

We are using JDBC to connect to a SQL Server 2000 database using JDBC.
We're having an odd problem, and I cannot find anybody else who is
having this issue. The application server machine (WAS 6.0) is eating
up ports and generating SQL Server processes like there is no tomorrow.


SQL Server is listening on port 1433, but if I do a "netstat" I see
something like this:

TCP 127.0.0.1:4479 127.0.0.1:1433 ESTABLISHED
TCP 127.0.0.1:4480 127.0.0.1:1433 ESTABLISHED
TCP 127.0.0.1:4481 127.0.0.1:1433 ESTABLISHED
TCP 127.0.0.1:4482 127.0.0.1:1433 ESTABLISHED
TCP 127.0.0.1:4483 127.0.0.1:1433 ESTABLISHED
TCP 127.0.0.1:4484 127.0.0.1:1433 ESTABLISHED
TCP 127.0.0.1:4485 127.0.0.1:1433 ESTABLISHED
TCP 127.0.0.1:4486 127.0.0.1:1433 ESTABLISHED
TCP 127.0.0.1:4487 127.0.0.1:1433 ESTABLISHED
TCP 127.0.0.1:4488 127.0.0.1:1433 ESTABLISHED
TCP 127.0.0.1:4489 127.0.0.1:1433 ESTABLISHED

There are dozens -- sometimes hundreds, thousands -- of these
connections. On SQL Server, each of these connections is generating a
SQL Server process (visible under "Process Info" in Enterprise Manager)
with a status of "sleeping." Eventually, these processes "go away" if
there's no activity, but if not, the connections eventually choke the
machine and we need to reboot.

I know we're not generating excess connections, because if I change the
JDBC driver to DB2, we only get one connection.

Does anybody have any idea what might be happening? Is there a SQL
Server or JDBC setting I am not aware of? Any help would be
appreciated, we're going nuts over here!!!

Thanks in advance!

.

Relevant Pages

  • Re: sendStringParameterAsUnicode: How to insert unicode data corre
    ... After checking with Microsoft it turns out that transmitting Unicode ... requires a change in the data format sent to the JDBC Receiver channel. ... We have contacted SAP and Microsoft. ... We are using SAP XI and connecting it to SQL Server 2005 using JDBC. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: BUG: JDBC connection disconnected, cant reconnect
    ... we've replaced the MS JDBC driver with jTDS JDBC driver, ... There is really nothing the driver can do that will take down SQL Server. ... Our problem is that the JDBC connection running on the localhost ... and then we can't reconnect to the database ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: SQL Server SP3a via JDBC SP2
    ... | Subject: RE: SQL Server SP3a via JDBC SP2 ... | Content-Type: text/plain; ... | Carb Simien, thanks for your reply, but the query ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: Installing SS 2005 JDBC Driver 1.1
    ... SQL Server 2005 JDBC Driver\sqljdbc_1.1) ... I see the .jar file but I have no idea how/where I am to define the ... Panel that a SQL Server JDBC is installed. ... How do I install this? ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: JDBC - Cant get unicode with ResultSet.getString()
    ... The data is correct in Sql Server - I viewed it there. ... And it is the jdbc getString() that returns it wrong, ... So for somereason the Microsoft Sql Server JDBC driver is not returning ...
    (microsoft.public.sqlserver.odbc)
Loading