[autopatch-users] sql patches showing up twice, erroring

[Derrick S. <der...@gm...>]

Hi, I'm just getting started with autopatch, integrating it into an existing
environment.

I've renamed my existing SQL scripts to fit the autopatch naming convention
(patchNNNN_text.sql) and configured autopatch to find them in the classpath
(I'm running the web application version). The problem is that it's finding
each patch twice, and of course complaining that multiple patches have the
same number. I have 18 existing SQL patches, and autopatch tells me it finds
36.

I've looked in the war that's being deployed with the patches, and there's
only one copy of each file. I assume later patches will fail legitimately as
things like create tables fail on the existing schema, but the first patch
is just a no-op sql script.

My migration.properties lists this:
appdb.patch.path=patches.appdb

And my patches/appdb directory has files such as
patch0001_no_op.sql
...
patch0018_user_table_last_login.sql

I cranked up autopatch's logging level, and sure enough, it says "found 36
patches" and then proceeds to log about each one from the same directory.

This is with autopatch 1.0.2, but it also failed on 1.2-b (I went to the
earlier version thinking it might be a bug).

Thanks for your help
Derrick

-- 
Writer. Programmer. Puzzle Designer.
http://www.obsessionwithfood.com