H2 Embedded Database

Doesn't work exactly like Oracle

Recently, I have been using the H2 embedded database at work to stage financial data for processing. H2 is really convenient to set up. I don’t have to install anything on the web server. No need to start/stop the database server when deploying the application. All I need to do is to add the dependency in Maven and I’m good to go. As convenient as H2 is, I got tripped by last week by a few unexpected differences between H2 and Oracle, the database that I was using previously to stage data. [Read More]