Open JdbcTemplate connection in read only mode?

java, jdbc, jdbctemplate, readonly, spring

Solution

Use Spring Transactions and declare the transaction as readOnly. See http://static.springsource.org/spring/docs/2.5.6/reference/transaction.html#transaction-declarative-annotations

Problem

is it possible to open a JdbcTemplate connection in read only mode, so that I can't perform any changes to the underlying data source?

Original source