I've upgraded an application from grails 2 to grails 3. This also meant an upgrade from hibernate 4 to hibernate 5. As the application is deployed on premise in quite few installations, we've used external-config to avoid migrating configurations (from groovy to yaml). In our current config, we have:
dataSource.dialect = org.hibernate.dialect.SQLServerDialect
However, this doesn't work. Changing this to SQLServer2012Dialect solves the problem, but requires manually changing this on every installation.
Are there any settings (e.g. in hibernate) that solves this issue? We're using jtds as driver
