Warning! This blog's new home now is here.
Recently I'm working quite heavily with straight JDBC and I'm learning some things from best practices and some others the hard way. One tool that I've found useful is JDBC Lint: it's a tool that acts as a dynamic proxy for Connection
objects (so that it can be used transparently) and reports errors at runtime on the standard error channel.
For a primer on some JDBC best practices, see this post.