› ~/

Flyway, SQLite and Java


It wasn’t clearly documented on flyway’s homepage how to get started with the Java API in combination with SQLite, so I thought I would save a couple of minutes if anyone else is looking for it.


You need to install flyway db and a driver for SQLite as dependencies in the project.


Information regarding SQLite driver can be found here

Property names

The property names are defined in the flyway-maven-plugin and all properties should be prefixed with flyway., I guess that makes sense. I spent too much time not realizing this. 🤦‍♂️

If you don’t prefix your url property, you’ll probably end up getting the following error: Unable to connect to the database. Configure the url, user and password!. Which isn’t very helpful if you don’t know that you have to prefix your properties.

Properties properties = new Properties();
properties.setProperty("flyway.url", "jdbc:sqlite:/YOUR_DB_FILE.db");

Hopefully it saved some minutes for someone! ⌚

Written by