/*
 * $Id$
 *
 * This file is part of the Cloud Services Integration Platform (CSIP),
 * a Model-as-a-Service framework, API, and application suite.
 *
 * 2012-2017, OMSLab, Colorado State University.
 *
 * OMSLab licenses this file to you under the MIT license.
 * See the LICENSE file in the project root for more information.
 */
package adb;

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

/**
 *
 * @author Shaun Case
 */
@Resource(type = JDBC, file = "${soils.gis.database.db}", id = EROSION_SQLSVR, env = {
    "removeAbandoned=true", "removeAbandonedTimeout=300000", "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 = "${soils.gis.database.1.3.db}", id = EROSION_SQLSVR_1_3, 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 = "${soils.r2gis.database.db}", id = R2GIS_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"
})

public interface DBResources {
    static final String EROSION_SQLSVR_1_3 = "csip.soils.sqlsvr.1.3";
    static final String EROSION_SQLSVR = "csip.soils.sqlsvr";
    static final String R2GIS_SQLSVR = "csip.soils.r2gis.sqlsvr";
}