Skip to Content.
Sympa Menu

freetds - statement.close() does not close the connection

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Lam, Ralph" <Ralph.Lam AT COMPAQ.com>
  • To: 'TDS Development Group' <freetds AT franklin.oit.unc.edu>
  • Subject: statement.close() does not close the connection
  • Date: Wed, 12 Jan 2000 17:20:52 +0800


hi,

I use freetds jdbc driver to connect to mssql 6.5 in servlet.

I close each statement object explicitly in service() method
try {
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sqlString);
...
...
rs.close();
stmt.close();
}
catch(SQLException e) {
System.err.println("An SQL Exception was thrown.");
}

However, I found that the connection does not close. (I use SQL Trace to
verified)
Finally, I got error message:
An SQL Exception was thrown.java.sql.SQLException: Logon failed. Msg 17809,
Lvl 14, State 1, Unable to connect. The maximum number of '15' configured
user connections are already connected. System Administrator can configure
to a higher value with sp_configure.
, Server , Procedure , Line 0
9 connection are in use by this program

If I use other JDBC driver I found that the connection will close.

Please help

Thanks,
Ralph
Ralph.Lam AT compaq.com



  • statement.close() does not close the connection, Lam, Ralph, 01/12/2000

Archive powered by MHonArc 2.6.24.

Top of Page