1dataSource { 2 pooled = true 3 driverClassName = "org.hsqldb.jdbcDriver" 4 username = "sa" 5 password = "" 6} 7hibernate { 8 cache.use_second_level_cache = true 9 cache.use_query_cache = true 10 cache.provider_class = 'net.sf.ehcache.hibernate.EhCacheProvider' 11} 12// environment specific settings 13environments { 14 development { 15 dataSource { 16 dbCreate = "create-drop" // one of 'create', 'create-drop','update' 17 url = "jdbc:hsqldb:mem:devDB" 18 } 19 } 20 test { 21 dataSource { 22 dbCreate = "update" 23 url = "jdbc:hsqldb:mem:testDb" 24 } 25 } 26 production { 27 dataSource { 28 dbCreate = "update" 29 url = "jdbc:hsqldb:file:prodDb;shutdown=true" 30 } 31 } 32} 33