<?xml version="1.0" encoding="UTF-8"?>

<Context antiResourceLocking="true" path="/DufryPP" reloadable="false">
    <Resource
        name="jdbc/dev/admin"
        scope="Shareable"
        auth="Container"
        type="javax.sql.DataSource"
        factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
        driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
        username="a-aa-dcis"
        password="a-aa-dcis"
        url="jdbc:sqlserver://chsql237q.dufry.net;databaseName=DufryAdmin;SelectMethod=cursor;ApplicationName=Dufry Pricing Application"
        defaultAutoCommit="true"
        maxActive="80"
        maxIdle="10"
        initialSize="10"
        maxWait="1000"
        removeAbandoned="true"
        removeAbandonedTimeout="1000000"
        logAbandoned="true"

        jmxEnabled="true"
        jdbcInterceptors="ConnectionState;StatementFinalizer;SlowQueryReportJmx(threshold=30000)"
        testOnBorrow="true"
        testOnReturn="false"
        testWhileIdle="false"
        validationQuery="select 1+2"
        />
    <Resource
        name="jdbc/dev/Supplier"
        scope="Shareable"
        auth="Container"
        type="javax.sql.DataSource"
        factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
        driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
        username="a-aa-dcis"
        password="a-aa-dcis"
        url="jdbc:sqlserver://chsql237q.dufry.net;databaseName=DCIS;SelectMethod=cursor;ApplicationName=Dufry Pricing Application"
        defaultAutoCommit="true"
        maxActive="80"
        maxIdle="10"
        initialSize="10"
        maxWait="1000"
        removeAbandoned="true"
        removeAbandonedTimeout="1000000"
        logAbandoned="true"

        jmxEnabled="true"
        jdbcInterceptors="StatementFinalizer;SlowQueryReportJmx(threshold=30000)"
        testOnBorrow="true"
        testOnReturn="false"
        testWhileIdle="false"
        validationQuery="select 1+2"
        />
    <Resource
            name="jdbc/pre-prod/admin"
            scope="Shareable"
            auth="Container"
            type="javax.sql.DataSource"
            factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
            driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
            username="a-aa-dcis"
            password="a-aa-dcis"
            url="jdbc:sqlserver://chsql237Q.dufry.net;databaseName=DufryAdmin;SelectMethod=cursor;ApplicationName=Dufry Pricing Application"
            defaultAutoCommit="true"
            maxActive="80"
            maxIdle="10"
            initialSize="10"
            maxWait="1000"
            removeAbandoned="true"
            removeAbandonedTimeout="1000000"
            logAbandoned="true"

            jmxEnabled="true"
            jdbcInterceptors="ConnectionState;StatementFinalizer;SlowQueryReportJmx(threshold=30000)"
            testOnBorrow="true"
            testOnReturn="false"
            testWhileIdle="false"
            validationQuery="select 1+2"
    />
    <Resource
            name="jdbc/pre-prod/Supplier"
            scope="Shareable"
            auth="Container"
            type="javax.sql.DataSource"
            factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
            driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
            username="a-aa-dcis"
            password="a-aa-dcis"
            url="jdbc:sqlserver://chsql237Q.dufry.net;databaseName=DCIS;SelectMethod=cursor;ApplicationName=Dufry Pricing Application"
            defaultAutoCommit="true"
            maxActive="80"
            maxIdle="10"
            initialSize="10"
            maxWait="1000"
            removeAbandoned="true"
            removeAbandonedTimeout="1000000"
            logAbandoned="true"

            jmxEnabled="true"
            jdbcInterceptors="StatementFinalizer;SlowQueryReportJmx(threshold=30000)"
            testOnBorrow="true"
            testOnReturn="false"
            testWhileIdle="false"
            validationQuery="select 1+2"
    />
    <Resource
            name="jdbc/prod/admin"
            scope="Shareable"
            auth="Container"
            type="javax.sql.DataSource"
            factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
            driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
            username="a-aa-dcis"
            password="a-aa-dcis"
            url="jdbc:sqlserver://chsql037.dufry.net;databaseName=DufryAdmin;SelectMethod=cursor;ApplicationName=Dufry Pricing Application"
            defaultAutoCommit="true"
            maxActive="80"
            maxIdle="10"
            initialSize="10"
            maxWait="1000"
            removeAbandoned="true"
            removeAbandonedTimeout="1000000"
            logAbandoned="true"

            jmxEnabled="true"
            jdbcInterceptors="ConnectionState;StatementFinalizer;SlowQueryReportJmx(threshold=30000)"
            testOnBorrow="true"
            testOnReturn="false"
            testWhileIdle="false"
            validationQuery="select 1+2"
    />
    <Resource
            name="jdbc/prod/Supplier"
            scope="Shareable"
            auth="Container"
            type="javax.sql.DataSource"
            factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
            driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
            username="a-aa-dcis"
            password="a-aa-dcis"
            url="jdbc:sqlserver://chsql037.dufry.net;databaseName=DCIS;SelectMethod=cursor;ApplicationName=Dufry Pricing Application"
            defaultAutoCommit="true"
            maxActive="80"
            maxIdle="10"
            initialSize="10"
            maxWait="1000"
            removeAbandoned="true"
            removeAbandonedTimeout="1000000"
            logAbandoned="true"

            jmxEnabled="true"
            jdbcInterceptors="StatementFinalizer;SlowQueryReportJmx(threshold=30000)"
            testOnBorrow="true"
            testOnReturn="false"
            testWhileIdle="false"
            validationQuery="select 1+2"
    />
</Context>