search

ebean-orm / ebean-migration

DB Migration runner (similar to Flyway) which can be used standalone or with Ebean (run migrations on EbeanServer start)
Apache License 2.0
9 stars 5 forks source link

SQL syntax error with SQLite #25

Closed Mijyuoon closed 7 years ago

Mijyuoon commented 7 years ago

Migration runner fails with SQL syntax error when SQLite is used as target DB platform.

The problem is because of this code. It uses SELECT _ FOR UPDATE statement that SQLite does not support.

I believe simply replacing it with normal SELECT when SQLite is used should work without causing any problems.

rbygrave commented 7 years ago

Fixed. So with SQLite we won't have locking on the migration table.