/*
 * 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 = "${wqm.db}", id = WQM_ID, env = {
    "removeAbandonedTimeout=30",
    "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 = "${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;"
    + "org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;"
    + "org.apache.tomcat.jdbc.pool.interceptor.ResetAbandonedTimer"
})
public interface DBResources {

    static final String WQM_ID = "wqm";
    static final String WQM_READONLY_ID = "wqm-readonly";
    static final String SSURGO_ID = "ssurgo";
}