[FB-Discuss] Some more JDBC bug patterns

Lukas Eder lukas.eder at datageekery.com
Tue Feb 4 07:55:13 EST 2014


Hello,

I was wondering if there was room for some additional bug pattern recognition in the area of JDBC. Apart from the more obvious forgotten close() calls, there are also various free() methods, which *should* be called in my opinion. In fact, any Array, Blob, Clob whose scope is entirely controlled within a local block should have its free() method called in a finally block. What do you guys think?

For more details, see:

- http://blog.jooq.org/2014/02/04/jdbc-4-0s-lesser-known-clob-free-and-blob-free-methods/
- http://docs.oracle.com/javase/tutorial/jdbc/basics/blob.html#release_large_objects

Cheers
Lukas

--
Lukas Eder - Head of R&D | lukas.eder at datageekery.com | +41 44 586 82 56
Data Geekery GmbH | Binzstrasse 23 | CH-8045 Zürich | Switzerland

http://www.datageekery.com | Get back in control of your SQLT






More information about the Findbugs-discuss mailing list