Tweaking Column Types in Grails

We had been working on this Grails 2 app for a few weeks and we were finally ready to put it on a test server (instead of running it like run-app locally). More importantly we were ready to point it away from an H2 database and to SQLServer. But then we ran into problems….

SQLServer doesn’t have a boolean type, but instead will use int. And we were using CLOBS and Hibernate was mapping them to text, which is deprecated in SQLServer in favor of nvarchar(max). And a lot of other little things. The CLOB was important to us because we were using that a lot in this app. And there was a bit difference on how H2 handled it as opposed to how SQLServer did.

After googling around the solution came to be to write your own Hibernate Dialiact. That sounded daunting but it actually wasn’t. This is what we came up with:

And then you have to tell Grails about it. In the DataSource.groovy add this to the SQLServer entries:

 dialect = com.foo.MySqlServerDialect

And that should be it.

About the Author

Object Partners profile.

One thought on “Tweaking Column Types in Grails

  1. Charl says:

    Very helpful, thanks!

Leave a Reply to Charl Cancel reply

Your email address will not be published.

Related Blog Posts
Natively Compiled Java on Google App Engine
Google App Engine is a platform-as-a-service product that is marketed as a way to get your applications into the cloud without necessarily knowing all of the infrastructure bits and pieces to do so. Google App […]
Building Better Data Visualization Experiences: Part 2 of 2
If you don't have a Ph.D. in data science, the raw data might be difficult to comprehend. This is where data visualization comes in.
Unleashing Feature Flags onto Kafka Consumers
Feature flags are a tool to strategically enable or disable functionality at runtime. They are often used to drive different user experiences but can also be useful in real-time data systems. In this post, we’ll […]
A security model for developers
Software security is more important than ever, but developing secure applications is more confusing than ever. TLS, mTLS, RBAC, SAML, OAUTH, OWASP, GDPR, SASL, RSA, JWT, cookie, attack vector, DDoS, firewall, VPN, security groups, exploit, […]