dataSource { pooled = true driverClassName = "org.postgis.DriverWrapper" username = "postgres" password = "postgres" dialect = "PostGISDialect" logSql = false } hibernate { cache.use_second_level_cache=true cache.use_query_cache=true cache.provider_class='org.hibernate.cache.EhCacheProvider' jdbc.batch_size=10 } // environment specific settings environments { development { dataSource { dbCreate = "create-drop" // one of 'create', 'create-drop','update' //dbCreate = "update" url = "jdbc:postgresql:omardb-2.0-dev" } } test { dataSource { dbCreate = "update" url = "jdbc:postgresql:omardb-2.0-test" } } production { dataSource { dbCreate = "update" url = "jdbc:postgresql:omardb-2.0-prod" } } }