DBResources.java [src/java/wqm/utils] Revision: Date:
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package wqm.utils;
import csip.annotations.Resource;
import static csip.annotations.ResourceType.JDBC;
import static wqm.utils.DBResources.*;
/**
*
* @author od
*/
@Resource(type = JDBC, file = "${ssurgo.db}", id = WQM_ID, env = {
"removeAbandonedTimeout=30", "defaultReadOnly=true",
"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 = 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", "defaultReadOnly=true",
"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_READONLY, 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 = "${soils.database.db}", id = EROSION_SQLSVR, env = {
"removeAbandoned=true", "defaultReadOnly=true", "defaultAutoCommit=false", "maxWait=300000", "jmxEnabled=false",
"jdbcInterceptors=org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;"
+ "org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;"
+ "org.apache.tomcat.jdbc.pool.interceptor.ResetAbandonedTimer"
})
@Resource(from = soils.db.DBResources.class)
public interface DBResources {
static final String WQM_ID = "wqm";
static final String WQM_READONLY_ID = "wqm-readonly";
static final String SSURGO_ID = "ssurgo";
static final String SSURGO_READONLY = "ssurgo-readonly";
static final String EROSION_SQLSVR = "csip.soils.sqlsvr";
}