classpath - Flyway not finding the migrations in a jar file -

-

i implemented flyway in number of applications support , worked dream.

however deployed applications test environment migrations stopped working.

after investigation found migrations not being located flyway when loaded jar file, when not zipped (like when working in eclipse or if extract jar classpath) works expected.

due plugin architecture of applications not in position use "default" setting , such setting flyway object this:

flyway flyway = new flyway(); flyway.setdatasource(datasource); flyway.setbasedir("za/co/company/application/plugin1/db/migration"); flyway.settable(tablename); flyway.setbasepackage("za.co.company.application.plugin1.db.migration"); flyway.init(); flyway.migrate();

if 1 unzip jar file sql files located in: za/co/company/application/db/migration

as mentioned know migrations work, not when in jar file. code above executes perfectly, it's there no sql files found run part of migration.

although originaly developed using flyway-core-1.6 have tried (with same negative results) 1.6.1 , 1.7_snapshot release found here , here similar problem reported.

edit: additional info

os: windows xp
jdk: 1.7.0_04
db: sql server 2005
running straight command window via bat file. 

2012-06-27 15:50:05.855 main: flyway.migrate() 2012-06-27 15:50:05.886 database: microsoft sql server 2012-06-27 15:50:05.902 schema: dbo 2012-06-27 15:50:05.902 unable find path sql migrations: za\co\company\application\plugin1\db\migration 2012-06-27 15:50:05.918 scanning url: jar:file:/c:/temp/lib/plugin1.jar!/za/co/company/application/plugin1/db/migration 2012-06-27 15:50:05.918 filtering out resource: za/co/company/application/plugin1/db/migration/ (filename: ) 2012-06-27 15:50:05.918 filtering out resource: za/co/company/application/plugin1/db/migration/v1_1__allows_cancelations.sql (filename: v1_1__allows_cancelations.sql) 2012-06-27 15:50:05.918 filtering out resource: za/co/company/application/plugin1/db/migration/v1__base_version.sql (filename: v1__base_version.sql) 2012-06-27 15:50:05.933 main: done migrate.

i have confirmed using default prefix (v) , suffix (.sql). , names of migration files mentioned in log being filtered out indeed migrations have performed.

edit: still more info. cloned source repository , got stack trace before resource logged being filtered out.

at com.googlecode.flyway.core.util.scanner.classpathscanner.filterresourcenames(classpathscanner.java:203) @ com.googlecode.flyway.core.util.scanner.classpathscanner.findresourcenames(classpathscanner.java:136) @ com.googlecode.flyway.core.util.scanner.classpathscanner.scanforclasses(classpathscanner.java:67) @ com.googlecode.flyway.core.migration.jdbc.jdbcmigrationresolver.resolvemigrations(jdbcmigrationresolver.java:51) @ com.googlecode.flyway.core.migration.compositemigrationresolver.collectmigrations(compositemigrationresolver.java:175) @ com.googlecode.flyway.core.migration.compositemigrationresolver.dofindavailablemigrations(compositemigrationresolver.java:156) @ com.googlecode.flyway.core.migration.compositemigrationresolver.resolvemigrations(compositemigrationresolver.java:119) @ com.googlecode.flyway.core.flyway$1.execute(flyway.java:565) @ com.googlecode.flyway.core.flyway$1.execute(flyway.java:1) @ com.googlecode.flyway.core.flyway.execute(flyway.java:850) @ com.googlecode.flyway.core.flyway.migrate(flyway.java:561)

i have confirmed time migrations filtered out when finds them in jar file. if .sql migrations not scanned when re inside jar file.

i still poking around , update accordingly.

edit: source code query: not overly familiar flyway source code have been poking around in few hours...

what piece of code in resolvemigrations method of sqlmigrationresolver class supposed do? if remove code sqlmigrations load jar file, if not don't load , warning logged.

    if (stringutils.hastext(normalizedbasedir)) && !new classpathresource(normalizedbasedir + "/").exists() ) {         log.warn("unable find path sql migrations: " + location);         return migrations;     }

try newly released 1.7. offending statement has been removed.


Comments

Post a Comment

Popular posts from this blog

c# - SVN Error : "svnadmin: E205000: Too many arguments" -

-
i trying reposotries using c# code process svncommand = null; var psi = new processstartinfo("svnadmin"); psi.redirectstandardoutput = true; psi.redirectstandarderror = true; psi.useshellexecute = false; psi.arguments= @"dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump"; using (svncommand = process.start(psi)) { var myoutput = svncommand.standardoutput; var myerror = svncommand.standarderror; debug.write("output :" + environment.newline + environment.newline + myoutput.readtoend() + environment.newline + "error :" + environment.newline + environment.newline + myerror.readtoend()); svncommand.close(); } when use dump command commandline svnadmin dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump it works fine when try ...
Read more

c++ - Using OpenSSL in a multi-threaded application -

-
i have been writing soap client application in c++ on ubuntu using openssl https transport , pthreads threading. have number of threads - 1 central data acquisition thread periodically gets worker threads make soap requests via shared mutex protected queues. reading documentation openssl found is openssl thread-safe? in openssl faq describes mechanisms required ensure thread safety when using openssl. implemented , works fine. the reason question conceptual difficulty really. thinking implementing same functionality application has already, instead of using threads, create 2 seperate applications : 1 worker thread (of multiple copies running) , main data acquisition thread. use tcp sockets communicate between 2 rather mutex protected queues. may bad idea not important - confusing me would have implement same functions required ensure openssl thread safety in second approach or not? my guess not have , treated independent (indeed surely must many applications use openssl) re...
Read more

All overlapping substrings matching a java regex -

-
is there api method returns (possibly overlapping) substrings match regular expression? for example, have text string: string t = 04/31 412-555-1235; , , have pattern: pattern p = new pattern("\\d\\d+"); matches strings of 2 or more characters. the matches are: 04, 31, 412, 555, 1235. how overlapping matches? i want code return: 04, 31, 41, 412, 12, 55, 555, 55, 12, 123, 1235, 23, 235, 35. theoretically should possible -- there obvious o(n^2) algorithm enumerates , checks substrings against pattern. edit rather enumerating substrings, safer use region(int start, int end) method in matcher . checking pattern against separate, extracted substring might change result of match (e.g. if there non-capturing group or word boundary check @ start/end of pattern). edit 2 actually, it's unclear whether region() expect zero-width matches. specification vague, , experiments yield disappointing results. for example: string line = "xx90xx"; strin...
Read more