Open JdbcTemplate connection in read-only mode?

Question

Can I open a JdbcTemplate connection in read-only mode so that I cannot make any changes to the underlying data source?

Answer 1

I do not believe the JDBC connectivity API allows this.

You have two options:

• GRANT appropriate permissions for the database level to allow only SELECT operations;
• Use Spring AOP and Security to intercept calls to record operations in the DAO and disallow them for specific roles.

The second choice is obviously more flexible and in the spirit of Spring’s natural idiom.

Answer 2

Spring readOnly. . http://static.springsource.org/spring/docs/2.5.6/reference/transaction.html#transaction-declarative-annotations

Answer 3

I am using a helper method like this

private void setConnectionReadOnly(boolean readOnly) {
    try {
        jdbcTemplate.getDataSource().getConnection().setReadOnly(readOnly);
    } catch (SQLException e) {
        e.printStackTrace();
    }
}