dataSource { pooled = true driverClassName = "org.postgis.DriverWrapper" username = "postgres" password = "postgres" dialect = "PostGISDialect" } hibernate { cache.use_second_level_cache=true cache.use_query_cache=true cache.provider_class='org.hibernate.cache.EhCacheProvider' } // environment specific settings environments { development { dataSource { dbCreate = "create-drop" // one of 'create', 'create-drop','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" } } }