Changeset 176

Timestamp:

Oct 31, 2009, 11:12:37 AM (15 years ago)

Author:

gav

Message:

Add InnoBD config for MySQL since we will require transactions and row locking from now on.

File:

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

trunk/grails-app/conf/DataSource.groovy

@@ -30 +30 @@
 //             password = "gnumimsadmin"
 //             dbCreate = "create-drop"
-//             url = "jdbc:mysql://host:3306/gnumims_dev"
+//             url = "jdbc:mysql://host:3306/gnumims_dev?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
         }
     }
@@ -46 +46 @@
 //             password = "gnumimsadmin"
 //             dbCreate = "update"
-//             url = "jdbc:mysql://host:3306/gnumims_test"
+//             url = "jdbc:mysql://host:3306/gnumims_test?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
         }
     }
@@ -69 +69 @@
             password = "gnumimsadmin"
             dbCreate = "update"
-            url = "jdbc:mysql://gnumimssql01:3306/gnumims_prod"
+            url = "jdbc:mysql://gnumimssql01:3306/gnumims_prod?autoReconnect=true&sessionVariables=storage_engine=InnoDB"
         }
     }