Dropwizard JDBI

I’ve made a test project for Dropwizard 7.1 using JDBI to interact with a DB.

Also using Flyway and H2 to create an in memory DB with test data for integration testing. Flyway solution can be expanded to create a fully featured Database Migration process using any JBDC compatible Database you can connect to. Using it here was overkill as I could have just used a simple script, I wanted to try it out as a comparison to Liquibase.

Code for JDBI integration was trivial, most of the effort was getting my head around the fact that I didn’t have to do anything to startup the H2 instance (it starts itself as embedded instance when you try to connect to the local DB file by black magic). For reference the most useful stuff is probably in the build.gradle, libraries and plugins used.

No major changes between using 6.2 and 7.1 with JDBI, just package names. Didn’t do integration tests as I figured for a real project it would make more sense to do full stack integration testing against the service and the production DB.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s