JDBC your H2 DB (in-memory vs embedded vs server mode)

OK, so I've been digging around for some documentation on the different ways to integrate the H2 database with Java. In case you are too, let me save you the time and effort! I found these two articles to be very helpful, enjoy!