freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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.