src/grails/grails-app/conf/DataSource.groovy

   1 dataSource {
   2         pooled = true
   3         driverClassName = "org.hsqldb.jdbcDriver"
   4         username = "sa"
   5         password = ""
   6 }
   7 hibernate {
   8     cache.use_second_level_cache=true
   9     cache.use_query_cache=true
  10     cache.provider_class='com.opensymphony.oscache.hibernate.OSCacheProvider'
  11 }
  12 // environment specific settings
  13 environments {
  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 }