Grails H2 Database 1.4.M1 Issue

August 28, 2011 Grails

I’ve noticed a peculiar behavior that I’m documenting here for others. I’m using Grails 1.4.M1 and it bundles with it H2 database version [H2 1.2.147 (2010-11-21)]

If you decide to run H2 in a server mode, you would most likely download the latest version of H2 Database from the website. As of writing this article, the stable version of H2 is [H2 1.3.158 (2011-07-17)].

Issue: If you run your Grails application using 1.2.147 and your external H2 database happens to be 1.3.158, then the SELECT’s work fine but when you run INSERT or UPDATE statements, they are not committed.

When I switched the H2 version to 1.2.147, then the .save() worked fine.

Enterprise Software Architect and Developer currently working at Leidos as a consultant for the Modern Development Environment Group at SSA.gov developing the next generation of DevOps solutions and services. My passions include all things Open Source including Java, Python, GoLang, JavaScript, Linux, Arduino, ARM, Embedded Devices, Web Development and micro controllers. Coming from an Electrical and Computer Engineering background, working in developing and designing enterprise grade distributed, highly scalable software requires a unique set of software skills with a good understanding of the hardware. This makes my work challenging and interesting each and every day. I enjoy spending my free time with my family, friends and our pet dog. I enjoy researching on topics including - world ancient history, yoga, science, biology, chemistry and all things interesting. Visit the 'About' section up top for more details.