Pooled DataSource configuration in Grails

DataSource.groovy

dataSource {
    pooled = true 
    driverClassName = "oracle.jdbc.driver.OracleDriver"
    username = "user"
    password = "password"

    properties {
        maxActive   = 10
        maxIdle     = 10
        minIdle     =  0
        initialSize =  3

        maxWait = 60 * 1000;                                 //... Timeout for borrowConnection()

	minEvictableIdleTimeMillis    = 30 * 60 * 1000       //... Evict Connections idle for 30 mins
        timeBetweenEvictionRunsMillis = 15 * 60 * 1000       //... Run Evictor every 15 mins
        numTestsPerEvictionRun        = 3                    //... Test 3 connections everytime the evictor runs

        testOnBorrow  = true
        testOnReturn  = false
        testWhileIdle = true

        validationQuery = "SELECT 1 FROM dual"
    }
}

hibernate {
    generate_statistics          = true
    cache.use_second_level_cache = true
    cache.use_query_cache        = true
    cache.provider_class         = 'net.sf.ehcache.hibernate.EhCacheProvider'
}

environments {
    development {
        dataSource {
            dbCreate = "" // one of 'create', 'create-drop','update'
            url      = "jdbc:oracle:thin:@<server>:<port>/<service>"
        }
    }

    test {
        dataSource {
            dbCreate = "" 
            url      = "jdbc:oracle:thin:@<server>:<port>/<service>"
        }
    }

    production {
        dataSource {
            dbCreate = "" 
            url      = "jdbc:oracle:thin:@<server>:<port>/<service>"
        }
    }
}