Changeset 878

Timestamp:

Apr 11, 2011, 2:59:55 PM (14 years ago)

Author:

gav

Message:

Add MySQL5InnoDBDialect to DataSource.groovy, helps with schema generation and checking.

File:

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

trunk/grails-app/conf/DataSource.groovy

@@ -26 +26 @@
             url = "jdbc:hsqldb:mem:devDb"
             /** MySQL */
+//             dialect = org.hibernate.dialect.MySQL5InnoDBDialect
 //             driverClassName = "com.mysql.jdbc.Driver"
 //             username = "gnumimsadmin"
@@ -42 +43 @@
             url = "jdbc:hsqldb:mem:devDb"
             /** MySQL */
+//             dialect = org.hibernate.dialect.MySQL5InnoDBDialect
 //             driverClassName = "com.mysql.jdbc.Driver"
 //             username = "gnumimsadmin"
@@ -66 +68 @@
             /** MSSQL */
             //For more info see the docs that you downloaded with the driver.
-//             dialect = org.hibernate.dialect.SQLServerDialect // Useful with `grails schema-export`
+//             dialect = org.hibernate.dialect.SQLServerDialect // MSSQL 2000+2005 Useful with `grails schema-export`
 //             driverClassName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
 //             username = "gnumimsadmin"
@@ -73 +75 @@
 //             url = "jdbc:sqlserver://gnumimssql01:1433;databaseName=gnumims_prod"
             /** MySQL */
+            dialect = org.hibernate.dialect.MySQL5InnoDBDialect
             driverClassName = "com.mysql.jdbc.Driver"
             username = "gnumimsadmin"