DataSource properties

gistfile1.groovy

    properties {
        /** The maximum number of active connections that can be allocated from
         * this pool at the same time, or zero for no limit.
         * Make it '-1' to prevent performance problems with idle connections
         */
        maxActive = -1
        /**
         * The maximum number of active connections that can remain idle in the
         * pool, without extra ones being released, or zero for no limit.
         */
        maxIdle = 8
        /**
         * The minimum number of active connections that can remain idle in the
         * pool, without extra ones being created, or 0 to create none.
         */
        minIdle = 0
        /**
         * The maximum number of milliseconds that the pool will wait (when there
         * are no available connections) for a connection to be returned before
         * throwing an exception, or -1 to wait indefinitely.
         */
        maxWait = 180000

        minEvictableIdleTimeMillis = 1000 * 60 * 15
        timeBetweenEvictionRunsMillis = 1000 * 60 * 15
        numTestsPerEvictionRun = 3

        testOnBorrow = true
        testWhileIdle = true
        testOnReturn = false

        validationQuery = "select 1"
    }