environments {
    development {
        dataSource {
            dbCreate = "update" // one of 'create', 'create-drop', 'update', 'validate', ''
            //url = "jdbc:h2:mem:devDb;MVCC=TRUE;LOCK_TIMEOUT=10000;DB_CLOSE_ON_EXIT=FALSE"
            url = "jdbc:mysql://localhost/frontdesk2db?useUnicode=yes&characterEncoding=UTF-8"
            username = "root"
            password = "admin"

            pooled = true
            properties {
                jmxEnabled = true
                initialSize = 5
                maxActive = 200
                minIdle = 20
                maxIdle = 100
                maxWait = 10000
                maxAge = 10 * 60 * 1000
                timeBetweenEvictionRunsMillis = 15000
                minEvictableIdleTimeMillis = 60000
                validationQuery = "SELECT 1"
                validationQueryTimeout = 3
                validationInterval = 30000
                testOnBorrow = true
                testWhileIdle = true
                testOnReturn = false

                removeAbandoned = true
                removeAbandonedTimeout = 600

                jdbcInterceptors = "ConnectionState;StatementCache(max=200)"
                defaultTransactionIsolation = java.sql.Connection.TRANSACTION_READ_COMMITTED
            }
        }
    }
}