Memory Leak with 5.0.6 and 5.1.2-beta
"Clemens Eisserer" <[email protected]> Thu, 19 Jul 2007 00:18:01 +0200
| Newsgroups | gmane.comp.db.mysql.java |
|---|---|
| Message-ID | <[email protected]> |
Hello,
I am currently writing code that uses javax.sql.RowSet quite a lot and
I am fighting with memory problems.
I've tons's of PreparedStatement-entries in com.mysql.jdbc.Connection
in the openStatements HashMap.
It seems the problem only happens in a library I work on, I tried to
create an isolated test-case (attached below) but this does not leak.
With the Postgres-8.2 jdbc driver the problem does not occur, I tested
J/Connector versions 5.0.6 and 5.1.2-beta with mysql-5.1.20-beta
server running on Linux.
Any ideas what could cause so many PreparedStatement in the openStatement's Map?
Thank you in advance, lg Clemens
Statement st = _ssConnection.getConnection().createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs = st.executeQuery("Select * from firma WHERE firmennummer
> "+i+" order by firmennummer LIMIT 1;");
RowSet rowset = new JdbcRowSetImpl(rs);
rowset.getMetaData();
rowset.next();
rowset.getInt("firmennummer");
rowset.getString("name");
rs.close();
--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/[email protected]