Run a single Maven plugin execution?

database maven testing maven-3 maven-plugin
HDave picture HDave · Sep 23, 2010 · Viewed 61.8k times · Source

I thought I was an experienced Maven user, but I am having a mental block on how to do this!

I've been able to use the Maven sql plugin to drop, create, and install a schema in a database via plugin executions I've defined and bound to the pre-integration-test phase.

However, now I'd like to use that same sql plugin to insert some sample data whenever I want from the command line -- that is, not bound to any lifecycle goal. There are a few different sets of sample data, so I'd like to define a few different executions.

But is there a way to run one of these executions from the command line by using the execution ID perhaps?

Answer

Joe picture Joe · Feb 28, 2015

As noted in How to execute maven plugin execution directly from command line?, this functionality has been implemented as MNG-5768, and is available in Maven 3.3.1.

The change will:

extend direct plugin invocation syntax to allow optional @execution-id parameter, e.g., org.apache.maven.plugins:maven-remote-resources-plugin:1.0:process@executionId.

So, as long as you give your execution an id:

mvn sql:execute@specific-execution-id

uses the execution configured in your pom.

Related questions

FlywayException: Unable to scan for SQL migrations in location: classpath:db/migration

I'm trying to start using flyway with maven integration but can't make it work. I'm following the documentation seems to be very simple so no strange things seem to be done. My pom.xml is the following: <project xmlns="…

Read More
How to use Flyway configuration to handle multiple databases

we have a java application configured with maven that uses multiple databases. It is one app - many schemas. I've configured flyway, tested and it works well but my config is only for one database. Here is my pom.xml …

Read More
Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More