FWIW, I've posted another answer to the Stackoverflow question about jooq and spring which is referenced in the JOOQ FAQ:
http://stackoverflow.com/questions/4474365/jooq-and-spring It explains how to get the Connection for JOOQ from a container managed DataSource, without any need to use a JDBCTemplate.
