[Springframework-developer] Sql error codes

[Rod J. <rod...@in...>]

Thomas,

I think build.xml needs to ensure that sql-error-codes.xml is included in
both jdbc and full Jars. Anyone who wants to override it with custom values
can put their own version of the file earlier on their classpath. Or, better
still, contribute their additional error codes.

From some benchmarks I did today, it seems that getting the connection
metadata when creating a JdbcTemplate is a very modest cost, at least with
Oracle 9i. Using the batch prepared statement capabilities of Spring JDBC I
reworked a complicated piece of JDBC code that took 7 seconds with raw JDBC
and prepared statements to run in 1 second with the JdbcTemplate.

Regards,
Rod