🚀 go-pugleaf

Hi,

I am using interbase 7, I have a Java client retriving data from interbase
using JDBC connection pool, however I got memory leak problem. When tracing
the problem in Optimizeit, it pointed to:
interbase.interclient.lscStmtHandle which hold a lot of references to
java.util.ArrayList object that can't be garbage collected. Does anyone have
any idea about this problem, thanks for your help.

Here is the sample code I used:

          Statement stmt = null;
          ResultSet rst = null;
          Connection conn = null;

          try {
                  conn = connectionPool.getConnection();
                  stmt = conn.createStatement();
                  rst = stmt.executeQuery(sql);
                  if (rst.next())
                  {
                    result = rst.getString(columnName);
                  }
          }
          catch (SQLException e) {
            e.printStackTrace();
            throw e;
          }
          finally {
                  if (rst != null) {
                          try {rst.close();}catch(Exception e) {}
                          rst = null;
                  }
                  if (stmt != null) {
                          try {stmt.close();}catch(Exception e) {}
                          stmt = null;
                  }
                  if (conn != null) {
                    connectionPool.freeConnection(conn);
                  }
          }

Regards,
David Meng