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

Last change on this file since 87 was 80, checked in by keesvb, 10 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.