/*
 * 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";
}