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]