🚀 go-pugleaf

Curious if a solution has been found for this issue.

We are using Interbase 7.1 and when running drivers through
Rational Purify we also observe 
interbase.interclient.lscStmtHandle objects that are not being 
garbage collected.

Shaunak Mistry <no@no.com> wrote:
>David,
>
>I do have a good idea what this is about, It seems to me that the 
>XSQLVARs are not getting GCed. Seems like some where we are hanging on 
>to the older XSQLVARs.
>
>Let me look into it and will let you know what I find.
>
>Shaunak Mistry
>InterBase R&D,
>Borland Software Corporation.
>
>David Meng wrote:
>
>> 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
>> 
>> 
>