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

Last change on this file since 87 was 80, checked in by keesvb, 9 years ago

added Event and ProtocolInstance? classes, updated DataSource? to work with 1.2, added packages to dbnp.transcriptomics.data classes, added a number of scaffold controllers, added Selenium tests

  • Property svn:keywords set to Date Author Rev
File size: 1.4 KB
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='net.sf.ehcache.hibernate.EhCacheProvider'
11}
12// environment specific settings
13environments {
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                        /*
29                         * when releasing a new stable to the live environment
30                         * you would probably comment out the dbCreate option
31                         * so hibernate won't try to update (which is does not
32                         * do so well) and you update the live database yourself
33                         *
34                         * @see http://grails.org/plugin/autobase
35                         * @see http://wiki.github.com/RobertFischer/autobase/example-usage
36                         */
37                        dbCreate = "update"
38                        username = "gscf"
39                        password = "dbnp"
40
41                        // PostgreSQL
42                        driverClassName = "org.postgresql.Driver"
43                        url = "jdbc:postgresql://localhost:5432/gscf"
44                        dialect = org.hibernate.dialect.PostgreSQLDialect
45
46                        // MySQL
47                        //driverClassName = "com.mysql.jdbc.Driver"
48                        //url = "jdbc:mysql://localhost/gscf"
49                        //dialect = "org.hibernate.dialect.MySQL5InnoDBDialect"
50
51                        //In memory
52                        //url = "jdbc:hsqldb:file:prodDb;shutdown=true"
53                }
54        }
55}
Note: See TracBrowser for help on using the repository browser.