Read Only Grails Hibernation Session

Question

I have two grails servers:

• Server - has read / write access to the database
• Web - has read-only access to the database, and for each entry it sends a request to the server

Problem: How to make web domain objects accessible only for one place (configuration file) for the entire application launch, instead of writing caching: read-only for each domain class mapping.

Answer 1

Parameter from http://www.nabble.com/database-read-only-td20360158.html

pooled = true DataSource.groovy, org.apache.commons.dbcp.BasicDataSource. DefaultReadOnly BootStrap.groovy:

class BootStrap { 

      def dataSource 

      def init = { servletContext -> 
         dataSource.defaultReadOnly = true 
      } 

      def destroy = {} 
} 

Answer 2

1.3.7

[dataSourceUnproxied] [dataSource]