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

Last change on this file since 227 was 178, checked in by gav, 15 years ago

Resolve ticket #12 again.
Turn query cache on again since this did not resolve the problem.
Implement fix as per http://jira.codehaus.org/browse/GRAILS-5111, add flush:true to save.
Adjust templates to include above and remove home url.
Re-generate all non detailed views and controllers.
Manually add flush:true and remove home url to detailed views and controllers.

File size: 2.7 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='com.opensymphony.oscache.hibernate.OSCacheProvider'
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
17// Environment specific settings.
18environments {
19    development {
20        dataSource {
21            /** HSQLDB - In memory */
22            driverClassName = "org.hsqldb.jdbcDriver"
23            username = "sa"
24            password = ""
25            dbCreate = "create-drop"
26            url = "jdbc:hsqldb:mem:devDB"
27            /** MySQL */
28//             driverClassName = "com.mysql.jdbc.Driver"
29//             username = "gnumimsadmin"
30//             password = "gnumimsadmin"
31//             dbCreate = "create-drop"
32//             url = "jdbc:mysql://host:3306/gnumims_dev?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
33        }
34    }
35    test {
36        dataSource {
37            /** HSQLDB - In memory */
38            driverClassName = "org.hsqldb.jdbcDriver"
39            username = "sa"
40            password = ""
41            dbCreate = "update"
42            url = "jdbc:hsqldb:mem:devDb"
43            /** MySQL */
44//             driverClassName = "com.mysql.jdbc.Driver"
45//             username = "gnumimsadmin"
46//             password = "gnumimsadmin"
47//             dbCreate = "update"
48//             url = "jdbc:mysql://host:3306/gnumims_test?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
49        }
50    }
51    production {
52        dataSource {
53            /* Delete dbCreate line after setup! */
54            /** HSQLDB - In memory */
55//             driverClassName = "org.hsqldb.jdbcDriver"
56//             username = "sa"
57//             password = ""
58//             dbCreate = "create-drop"
59//             url = "jdbc:hsqldb:mem:devDB"
60            /** HSQLDB - In file */
61//             driverClassName = "org.hsqldb.jdbcDriver"
62//             username = "sa"
63//             password = ""
64//             dbCreate = "update"
65//             url = "jdbc:hsqldb:file:prodDb;shutdown=true"
66            /** MySQL */
67            driverClassName = "com.mysql.jdbc.Driver"
68            username = "gnumimsadmin"
69            password = "gnumimsadmin"
70            dbCreate = "update"
71            url = "jdbc:mysql://gnumimssql01:3306/gnumims_prod?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
72        }
73    }
74}
Note: See TracBrowser for help on using the repository browser.