source: trunk/grails-app/conf/DataSource.groovy @ 146

Last change on this file since 146 was 81, checked in by gav, 16 years ago

Change datasource to use in memory for production war.

File size: 985 bytes
Line 
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='com.opensymphony.oscache.hibernate.OSCacheProvider'
11}
12
13//environment specific settings
14//create-drop:  drop tables and data between sessions, then insert from Bootstrap.
15//create:       drop data between sessions, can't explain the rest.
16//update:       keep data, update tables as required, keeps inserting from BootStrap.
17environments {
18        development {
19                dataSource {
20                        dbCreate = "create-drop" // one of 'create', 'create-drop','update'
21                        url = "jdbc:hsqldb:mem:devDB"
22                }
23        }
24        test {
25                dataSource {
26                        dbCreate = "update"
27                        url = "jdbc:hsqldb:mem:testDb"
28                }
29        }
30        production {
31                dataSource {
32                        //Delete dbCreate line after setup!
33            dbCreate = "create-drop"
34                        //url = "jdbc:hsqldb:file:prodDb;shutdown=true"
35            url = "jdbc:hsqldb:mem:devDB"
36                }
37        }
38}
Note: See TracBrowser for help on using the repository browser.