Originally posted by Dave Salter:
I'd also recommend using PreparedStatements if you can instead of Statements.
Always true (at least in my view), although the pointers I gave will work around a known JDBC-ODBC issue where statements get cached in the Driver and require an extra operation to flush them.