Geek Answers Handbook

Using Liquibase Extensions with Maven

I am trying to use Liquibase Oracle extensions from the maven-liquidibase-plugin , but I cannot get it to work. I have no problem with the same changeLog file from the command line, but in Maven I get the following error message

SEVERE 21/11/11 14:49:liquibase: Error thrown as a SAXException: Unknown Liquibase extension: dropTrigger. Are you missing a jar from your classpath?

In the change file I'm using

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ora="http://www.liquibase.org/xml/ns/dbchangelog-ext" xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">
    <changeSet author="PE1926" id="ONCHANGE" runOnChange="true">
    <ora:dropTrigger schemaName="" triggerName="TRIGGER_01"/>
    <rollback>
        <sqlFile path="latest/trg/TRIGGER_01.sql" endDelimiter="$"/>
    </rollback>
</changeSet>

Here is a pom.xml fragment

[...]
<dependencies>
    <dependency>
        <groupId>com.oracle</groupId>
        <artifactId>ojdbc14</artifactId>
    </dependency>   
    <dependency>
        <groupId>org.liquibase.ext</groupId>
        <artifactId>liquibase-oracle</artifactId>
        <version>1.2.0</version>
    </dependency>   
</dependencies>

<build>
    <plugins>       
        <plugin>
            <groupId>org.liquibase</groupId>
            <artifactId>liquibase-maven-plugin</artifactId>
            <version>2.0.3</version>
            <executions>
                <execution>
                    <phase>process-resources</phase>
                    <goals><goal>status</goal></goals>
                </execution>
            </executions>
            <configuration>
                <changeLogFile>src/main/resources/update.xml</changeLogFile>    
                <propertyFile>${db-resources.dir}/liquibase.properties</propertyFile>
                <promptOnNonLocalDatabase>false</promptOnNonLocalDatabase>
                <verbose>true</verbose>
            </configuration>
        </plugin>
    </plugins>
</build>

I also tried to add Liquibase-oracle as plugin dependencies, but I get the same error message.

Is this the right way to use Maven's Liquibase extensions? Did I miss something?

+5
source share
2 answers

Liquibase .

+7

- - :

<pluginManagement>
  <plugin>
    <groupId>org.liquibase</groupId>
    <artifactId>liquibase-maven-plugin</artifactId>
    <version>${version.liquibase}</version>
    <configuration>
      <propertyFileWillOverride>true</propertyFileWillOverride>
      <driver>oracle.jdbc.OracleDriver</driver>
      <promptOnNonLocalDatabase>false</promptOnNonLocalDatabase>
      <changeLogFile>liquibase-master-changelog.xml</changeLogFile>
      <!-- ensure a liquibase.properties is available in each module that runs liquibase -->
      <propertyFile>liquibase.properties</propertyFile>
    </configuration>
    <dependencies>
      <dependency>
        <groupId>org.liquibase.ext</groupId>
        <artifactId>liquibase-oracle</artifactId>
        <version>${version.liquibase.ora-ext}</version>
      </dependency>
    </dependencies>
    <executions>
      <execution>
        <phase>test-compile</phase>
        <goals>
          <goal>update</goal>
        </goals>
      </execution>
    </executions>
  </plugin>
</pluginManagement>
0

More articles:


All Articles