import org.springframework.jdbc.core.JdbcTemplate
...
jdbcTemplate(JdbcTemplate) {
   dataSource = ref('dataSource')
...
}

dataSource {
    configClass = GrailsAnnotationConfiguration.class
    pooled = true
    autoreconnect= true
}

hibernate {
    generate_statistics=true
    cache.use_second_level_cache=true
    cache.use_query_cache=true
    cache.region.factory_class = 'org.hibernate.cache.ehcache.SingletonEhCacheRegionFactory'

}


environments {
   development {
      dataSource {
         driverClassName = "com.mysql.jdbc.Driver"
         username = "test"
         password = "test"
         dbCreate = "update" // one of 'create', 'create-drop','update'
         pooled = true
         jmxExport = true
         url = "jdbc:mysql://host:port/dbName?autoReconnect=true"
    }
}


}

def jdbcTemplate

def someMethod(){
    jdbcTemplate.queryForList(somequery)
}