Index: branches/features/grailsUpgrade/grails-app/conf/DataSource.groovy
===================================================================
--- branches/features/grailsUpgrade/grails-app/conf/DataSource.groovy	(revision 880)
+++ branches/features/grailsUpgrade/grails-app/conf/DataSource.groovy	(revision 881)
@@ -26,4 +26,5 @@
             url = "jdbc:hsqldb:mem:devDb"
             /** MySQL */
+//             dialect = org.hibernate.dialect.MySQL5InnoDBDialect
 //             driverClassName = "com.mysql.jdbc.Driver"
 //             username = "gnumimsadmin"
@@ -42,4 +43,5 @@
             url = "jdbc:hsqldb:mem:devDb"
             /** MySQL */
+//             dialect = org.hibernate.dialect.MySQL5InnoDBDialect
 //             driverClassName = "com.mysql.jdbc.Driver"
 //             username = "gnumimsadmin"
@@ -66,5 +68,5 @@
             /** 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,4 +75,5 @@
 //             url = "jdbc:sqlserver://gnumimssql01:1433;databaseName=gnumims_prod"
             /** MySQL */
+            dialect = org.hibernate.dialect.MySQL5InnoDBDialect
             driverClassName = "com.mysql.jdbc.Driver"
             username = "gnumimsadmin"
Index: branches/features/grailsUpgrade/grails-app/views/assetSubItemDetailed/show.gsp
===================================================================
--- branches/features/grailsUpgrade/grails-app/views/assetSubItemDetailed/show.gsp	(revision 880)
+++ branches/features/grailsUpgrade/grails-app/views/assetSubItemDetailed/show.gsp	(revision 881)
@@ -135,5 +135,5 @@
                             <td  valign="top" style="text-align:left;" class="value">
                                 <ul>
-                                <g:each var="s" in="${assetSubItemInstance.subItems}">
+                                <g:each var="s" in="${assetSubItemInstance.subItems.sort { p1, p2 -> p1.name.compareToIgnoreCase(p2.name) } }">
                                     <li><g:link controller="assetSubItemDetailed" action="show" id="${s.id}">${s?.encodeAsHTML()}</g:link></li>
                                 </g:each>