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

Last change on this file since 945 was 945, checked in by gav, 8 years ago

Introduce appNameLowerCase variable for production database naming convention, part 2.
Also change default production SQL host to 'sql01'.

File size: 2.1 KB
Line 
1dataSource {
2    // Open separate connections to database for every request or pool connections.
3    pooled = true
4}
5hibernate {
6    cache.use_second_level_cache=true
7    cache.use_query_cache=true
8    cache.provider_class='net.sf.ehcache.hibernate.EhCacheProvider'
9}
10
11// dbCreate options.
12// create-drop: Drop and re-create the database tables on restart. Deletes existing data.
13// create:       Create the database if it doesn't exist, but don't modify it if it does. Deletes existing data.
14// update:     Create the database if it doesn't exist, and modify it if it does exist. Keep data.
15// If nothing specified then do nothing to database schema.
16
17def appNameLowerCase = appName.toLowerCase()
18
19// Environment specific settings.
20// All production config is in external config.
21environments {
22    development {
23        dataSource {
24            /** HSQLDB - In memory */
25            driverClassName = "org.hsqldb.jdbcDriver"
26            username = "sa"
27            password = ""
28            dbCreate = "create-drop"
29            url = "jdbc:hsqldb:mem:devDb"
30            /** MySQL */
31//             dialect = org.hibernate.dialect.MySQL5InnoDBDialect
32//             driverClassName = "com.mysql.jdbc.Driver"
33//             username = "${appNameLowerCase}admin"
34//             password = "${appNameLowerCase}admin"
35//             dbCreate = "create-drop"
36//             url = "jdbc:mysql://host:3306/${appNameLowerCase}_dev?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
37        }
38    }
39    test {
40        dataSource {
41            /** HSQLDB - In memory */
42            driverClassName = "org.hsqldb.jdbcDriver"
43            username = "sa"
44            password = ""
45            dbCreate = "update"
46            url = "jdbc:hsqldb:mem:devDb"
47            /** MySQL */
48//             dialect = org.hibernate.dialect.MySQL5InnoDBDialect
49//             driverClassName = "com.mysql.jdbc.Driver"
50//             username = "${appNameLowerCase}admin"
51//             password = "${appNameLowerCase}admin"
52//             dbCreate = "update"
53//             url = "jdbc:mysql://host:3306/${appNameLowerCase}_test?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
54        }
55    }
56}
Note: See TracBrowser for help on using the repository browser.