Leaking memory in JDBC Connection

Posted in 2004

NoSpam — Tue, 2 Mar 2004 00:09:28 GMT — source: Usenet: comp.databases.informix

Hello. We have an app querying numbers of fairly large blob sets using Java JDBC (JDBC 4). Trouble is, the app seems to grow till an OutOfMemoryError results. We suspect JDBC Connection class because disconnecting and reconnecting clears the excess memory usage. We are using the following options at connect time: ";lobcache=-1;OPTOFC=1;IFX_AUTOFREE=1;FET_BUF_SIZE=32767"; However variations and exclusions of these settings changes only performance and not the memory leak. Are there other settings? Are there other means to release internal buffers? Your advice is appreciated. Steve.