Classpath for CustomSqlChange (derived) objects when using ANT task (1.9.3)

General Discussion
1

Has anyone had luck with creating a CustomSqlChange and using it with the updateDatabase in ANT?

I’ve found that I can’t just add the custom java object to the classpathref for the updateDatabase task.  If I add the object to ANT’s classpath by way of ${user.home}/ant/lib it will find it but then it won’t find Liquibase since they are presumably in different classloaders now…

then if I add Liquibase to ${user.home}/ant/lib it will work… but I don’t know if there are going to be any unintended consequences from fooling around with the classpath like this?

Am I missing somethinga and making this way too complicated?

Thanks in advance for any help.

2

I have an update target like this that is working fine for me with 1.9.4(?):

      <updateDatabase
                changeLogFile=“path/to/db.changelog.xml”
                driver="${database.driver}"
                url="${database.url}${database.schema.dataset}"
                username="${database.username}"
                password="${database.password}"
                promptOnNonLocalDatabase="${promptOnNonLocalDatabase}"
                dropFirst=“false”
                classpathref=“liquibaseclasspath”
                >
       

where liquibaseclasspath is:

       

           
           
               
           

           
               
           

           
               
           

           
           
       

and liquibase is in the apps/distributed-server/ear/lib dir

Nathan