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

Last change on this file since 606 was 606, checked in by gav, 9 years ago

Set select background since select borders cannot be styled in IE.
Add dialect example to data source comments.

File size: 3.2 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
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            /** MSSQL */
67            //For more info see the docs that you downloaded with the driver.
68//             dialect = org.hibernate.dialect.SQLServerDialect // Useful with `grails schema-export`
69//             driverClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
70//             username = "gnumimsadmin"
71//             password = "gnumimsadmin"
72//             dbCreate = "update"
73//             url = "jdbc:sqlserver://gnumimssql01:1433;databaseName=gnumims_prod"
74            /** MySQL */
75            driverClassName = "com.mysql.jdbc.Driver"
76            username = "gnumimsadmin"
77            password = "gnumimsadmin"
78            dbCreate = "update"
79            url = "jdbc:mysql://gnumimssql01:3306/gnumims_prod?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
80        }
81
82    }
83}
Note: See TracBrowser for help on using the repository browser.