java - Open JdbcTemplate connection in read only mode? -


Is it possible to open a JdbcTemplate connection in read only mode, so that I can not make any changes to the underlying data Source?

I do not think the JDBC connection API allows this.

You have two options:

  1. Allow to select appropriate permissions at the database level;
  2. To block calls to use action AOP and security to write action on the DAO

The second choice is clearly more flexible and the natural idioms of Spring in the sense.


Comments

Post a Comment