Driver memory problem

Joe Sam Shirah

Regardless of DBMS, there's no particular reason to close a Statement until you are done with your operations - assuming 1) a JDBC compliant driver works normally; 2) that there aren't extended periods when the Statement isn't used and 3) you aren't using a connection pool, which would mean closing the Statement before returning the connection to the pool.

Depending on what you are doing, the memory usage may be completely normal; In the JVM, memory usage will rise until the garbage collector kicks in. It may well be that the driver has memory leaks - you should check their site/support/forums - but the factors above are still true.