/*
 * 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 database;

import csip.annotations.Resource;
import static csip.annotations.ResourceType.JDBC;
import static database.DBResources.*;

/**
 *
 * @author Brad
 */
@Resource(type = JDBC, file = "${conservation_resources.db}", id = CRDB, 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(type = JDBC, file = "${nrt.db}", id = NRT_DB, 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(type = JDBC, file = "${crlmod.db}", id = CRLMOD, 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"
})

public interface DBResources {

    public static final String CRDB = "cr_sqlserver";
    public static final String CRLMOD = "crlmod";
    public static final String NRT_DB = "nrt_sqlserver";
}