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

Your email address will not be published.

Related Blog Posts
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, […]
Building Better Data Visualization Experiences: Part 1 of 2
Through direct experience with data scientists, business analysts, lab technicians, as well as other UX professionals, I have found that we need a better understanding of the people who will be using our data visualization products in order to build them. Creating a product utilizing data with the goal of providing insight is fundamentally different from a typical user-centric web experience, although traditional UX process methods can help.
Kafka Schema Evolution With Java Spring Boot and Protobuf
In this blog I will be demonstrating Kafka schema evolution with Java, Spring Boot and Protobuf.  This app is for tutorial purposes, so there will be instances where a refactor could happen. I tried to […]
Redis Bitmaps: Storing state in small places
Redis is a popular open source in-memory data store that supports all kinds of abstract data structures. In this post and in an accompanying example Java project, I am going to explore two great use […]