Liquibase maven plugin with multiple databases

Question

I tried to use multiple databases with liquibase maven plugin. I followed the link : liquibase using maven with two databases

However when I try to run it I get an error "[ERROR] Failed to execute goal org.liquibase:liquibase-maven-plugin:3.5.3:update (default-cli) on project liquibase-helloworld-demo: The database URL has not been specified either as a parameter or in a properties file."

Please find my pom below :

<build>
    <finalName>liquibase-helloworld-demo</finalName>
    <plugins>
        <plugin>
            <groupId>org.liquibase</groupId>
            <artifactId>liquibase-maven-plugin</artifactId>
            <version>3.5.3</version>
            <executions>
                <execution>
                    <id>id1</id>
                    <phase>process-resources</phase>
                    <configuration>
                        <changeLogFile>
                            ${basedir}/src/main/resources/liquibase/changelog1.xml
                        </changeLogFile>
                        <driver>com.mysql.jdbc.Driver</driver>
                        <url>jdbc:mysql://localhost:3306/liquibase-test</url>
                        <username>*****</username>
                        <password>*****</password>
                    </configuration>
                    <goals>
                        <goal>update</goal>
                    </goals>
                </execution>
                <execution>
                    <id>id2</id>
                    <phase>process-resources</phase>
                    <configuration>
                        <changeLogFile>
                            ${basedir}/src/main/resources/liquibase/changelog2.xml
                        </changeLogFile>
                        <driver>com.mysql.jdbc.Driver</driver>
                        <url>jdbc:mysql://localhost:3306/liquibase-test</url>
                        <username>*****</username>
                        <password>*****</password>
                    </configuration>
                    <goals>
                        <goal>update</goal>
                    </goals>
                </execution>
            </executions>
            <dependencies>
                <dependency>
                    <groupId>mysql</groupId>
                    <artifactId>mysql-connector-java</artifactId>
                    <version>5.1.9</version>
                </dependency>
            </dependencies>
        </plugin>
    </plugins>
</build>

Can you please help? Thanks in Advance.

Thanks Rahul Saraswat

Duminda Jayarathne Duminda Jayarathne · Accepted Answer · 2018-02-15T13:26:23

We have used postgres and mysql in our spring boot application with gradle as following. check it for helping.

spring:
    datasource:
        initialize: false
    db1Datasource:
        jdbcUrl: jdbc:postgresql://localhost:5432/db1
        driverClassName: org.postgresql.Driver
        username: postgres
        password: root
        poolName: HikariCP-db1-pool
        liquibase:
            change-log: classpath:database/db1/changelog.groovy
            contexts: dev
    db2Datasource:
        jdbcUrl: jdbc:mysql://localhost:3306/db2
        driverClassName: com.mysql.jdbc.Driver
        username: root
        password: root
        poolName: HikariCP-db2-pool
        liquibase:
            change-log: classpath:database/db2/changelog.groovy
            contexts: dev

Liquibase maven plugin with multiple databases

1 Answers