Changeset 148

Timestamp:

Oct 9, 2009, 9:21:12 AM (15 years ago)

Author:

gav

Message:

Update DataSource?.groovy to include MySQL settings and comments.

File:

• trunk/grails-app/conf/DataSource.groovy (modified) (2 diffs)

trunk/grails-app/conf/DataSource.groovy

@@ -1 +1 @@
 dataSource {
-        pooled = true
-        driverClassName = "org.hsqldb.jdbcDriver"
-        username = "sa"
-        password = ""
+    pooled = true
+    /** HSQLDB  */
+    driverClassName = "org.hsqldb.jdbcDriver"
+    username = "sa"
+    password = ""
+    /** MySQL */
+//     driverClassName = "com.mysql.jdbc.Driver"
+//     username = "gnumimsadmin"
+//     password = "gnumimsadmin"
 }
 hibernate {
@@ -11 +16 @@
 }
 
-//environment specific settings
-//create-drop:  drop tables and data between sessions, then insert from Bootstrap.
-//create:       drop data between sessions, can't explain the rest.
-//update:       keep data, update tables as required, keeps inserting from BootStrap.
+// Environment specific settings.
+// create-drop:  drop tables and data between sessions, then call Bootstrap.
+// create:        drop data between sessions, can't explain the rest of the behaviour.
+// update:       keep data, update tables as required, then call BootStrap.
 environments {
-        development {
-                dataSource {
-                        dbCreate = "create-drop" // one of 'create', 'create-drop','update'
-                        url = "jdbc:hsqldb:mem:devDB"
-                }
-        }
-        test {
-                dataSource {
-                        dbCreate = "update"
-                        url = "jdbc:hsqldb:mem:testDb"
-                }
-        }
-        production {
-                dataSource {
-                        //Delete dbCreate line after setup!
+    development {
+        dataSource {
+            /** HSQLDB - In memory */
             dbCreate = "create-drop"
-                        //url = "jdbc:hsqldb:file:prodDb;shutdown=true"
             url = "jdbc:hsqldb:mem:devDB"
-                }
-        }
+            /** MySQL */
+//             dbCreate = "create-drop"
+//             url = "jdbc:mysql://host:3306/gnumims_dev"
+        }
+    }
+    test {
+        dataSource {
+            /** HSQLDB - In memory */
+            dbCreate = "update"
+            url = "jdbc:hsqldb:mem:devDb"
+            /** MySQL */
+//             dbCreate = "update"
+//             url = "jdbc:mysql://host:3306/gnumims_test"
+        }
+    }
+    production {
+        dataSource {
+            /** HSQLDB - In memory */
+            //Delete dbCreate line after setup!
+            dbCreate = "create-drop"
+            url = "jdbc:hsqldb:mem:devDB"
+            /** HSQLDB - In file */
+//             dbCreate = "update"
+//             url = "jdbc:hsqldb:file:prodDb;shutdown=true"
+            /** MySQL */
+//             dbCreate = "update"
+//             url = "jdbc:mysql://host:3306/gnumims_prod"
+        }
+    }
 }