src/java/wqm/utils/DBResources.java
| @@ -19,6 +19,14 @@ |
| + "org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;" |
| + "org.apache.tomcat.jdbc.pool.interceptor.ResetAbandonedTimer" |
| }) |
| + |
| +@Resource(type = JDBC, file = "${wqm.db}", id = WQM_READONLY_ID, env = { |
| + "removeAbandoned=true", "defaultReadOnly=true", "defaultAutoCommit=false", |
| + "jdbcInterceptors=org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;" |
| + + "org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;" |
| + + "org.apache.tomcat.jdbc.pool.interceptor.ResetAbandonedTimer" |
| +}) |
| + |
| @Resource(type = JDBC, file = "${ssurgo.db}", id = SSURGO_ID, env = { |
| "removeAbandonedTimeout=30", |
| "jdbcInterceptors=org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;" |
| @@ -28,5 +36,6 @@ |
| public interface DBResources { |
| |
| static final String WQM_ID = "wqm"; |
| + static final String WQM_READONLY_ID = "wqm-readonly"; |
| static final String SSURGO_ID = "ssurgo"; |
| } |