Tech and Tips

The H2 console application nicely lets you interact with any of your locally created H2 databases. It gives you access via your web browser so it also works for remote machines, as long as you can start the console application there and access the box via HTTP.
More info on the H2 website.

The you get something which looks like this:



For reference:
The name H2 stands for Hypersonic 2, however H2 does not share code with Hypersonic SQL or HSQLDB. H2 is built from scratch.
More info from wikipedia here.

While googling for some answer regarding JPA identity generators and how they behave according to which DB you use, I found this very nice blog post!

Very informative!

Here a 3 part blog post showing how to use JUnit and Hibernate (and Hypersonic) to test your database layer. Often using an ORM makes this superfluous but in some cases it can be an interesting to do.

Part 1
Part 2
Part 3