Here is the declaration of the plugin.
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>sql-maven-plugin</artifactId>
<dependencies>
<dependency>
<groupId>oracle</groupId>
<artifactId>ojdbc14</artifactId>
<version>10.2.0.3</version>
</dependency>
</dependencies>
<configuration>
<driver>oracle.jdbc.driver.OracleDriver</driver>
<url>${lmb-biz.url}</url>
<username>${lmb-biz.username}</username>
<password>${lmb-biz.password}</password>
<skip>${load.db.skip}</skip>
</configuration>
<executions>
<execution>
<id>create</id>
<phase>process-test-resources</phase>
<goals><goal>execute</goal></goals>
<configuration>
<onError>continue</onError>
<srcFiles>
<srcFile>src/main/db/create/schema.ddl</srcFile>
<srcFile>src/main/db/create/cr_synonyms.sql</srcFile>
<srcFile>src/main/db/create/alt_lmb.sql</srcFile>
<srcFile>src/main/db/create/alt_columns.sql</srcFile>
</srcFiles>
</configuration>
</execution>
<execution>
<id>create-triggers</id>
<phase>process-test-resources</phase>
<goals><goal>execute</goal></goals>
<configuration>
<onError>continue</onError>
<delimiter>/</delimiter>
<delimiterType>row</delimiterType>
<keepformat>true</keepformat>
<srcFiles>
<srcFile>src/main/db/create/cr_triggers.sql</srcFile>
<srcFile>src/main/db/create/cr_insert_lookup.sql</srcFile>
<srcFile>src/main/db/create/cr_functions.sql</srcFile>
</srcFiles>
</configuration>
</execution>
<execution>
<id>create-view</id>
<phase>process-test-resources</phase>
<goals><goal>execute</goal></goals>
<configuration>
<onError>continue</onError>
<srcFiles>
<srcFile>src/main/db/create/cr_views.sql</srcFile>
</srcFiles>
</configuration>
</execution>
<execution>
<id>create-view-triggers</id>
<phase>process-test-resources</phase>
<goals><goal>execute</goal></goals>
<configuration>
<onError>continue</onError>
<delimiter>/</delimiter>
<delimiterType>row</delimiterType>
<keepformat>true</keepformat>
<srcFiles>
<srcFile>src/main/db/create/cr_view_triggers.sql</srcFile>
</srcFiles>
</configuration>
</execution>
<execution>
<id>create-schema</id>
<phase>process-test-resources</phase>
<goals><goal>execute</goal></goals>
<configuration>
<onError>continue</onError>
<keepformat>true</keepformat>
<srcFiles>
<srcFile>src/main/db/schema.sql</srcFile>
</srcFiles>
</configuration>
</execution>
<execution>
<id>create-block-statements</id>
<phase>process-test-resources</phase>
<goals><goal>execute</goal></goals>
<configuration>
<onError>continue</onError>
<delimiter>/</delimiter>
<delimiterType>row</delimiterType>
<keepformat>true</keepformat>
<srcFiles>
<srcFile>src/main/db/block-statements.sql</srcFile>
</srcFiles>
</configuration>
</execution>
<execution>
<id>load</id>
<phase>process-test-resources</phase>
<goals><goal>execute</goal></goals>
<configuration>
<onError>continue</onError>
<autocommit>true</autocommit>
<srcFiles>
<srcFile>src/main/db/create/load_base.sql</srcFile>
<srcFile>src/main/db/create/load_provider.sql</srcFile>
<srcFile>src/main/db/create/load_fraud.sql</srcFile>
</srcFiles>
</configuration>
</execution>
<execution>
<id>load-lookups</id>
<phase>process-test-resources</phase>
<goals><goal>execute</goal></goals>
<configuration>
<onError>continue</onError>
<autocommit>true</autocommit>
<delimiter>/</delimiter>
<delimiterType>row</delimiterType>
<keepformat>true</keepformat>
<srcFiles>
<srcFile>src/main/db/create/load_lookups.sql</srcFile>
</srcFiles>
</configuration>
</execution>
<execution>
<id>load-data</id>
<phase>process-test-resources</phase>
<goals><goal>execute</goal></goals>
<configuration>
<onError>continue</onError>
<autocommit>true</autocommit>
<keepformat>true</keepformat>
<srcFiles>
<srcFile>src/main/db/data.sql</srcFile>
</srcFiles>
</configuration>
</execution>
</executions>
</plugin>
Thanks
-zach
David J. Graff wrote:
Zach,
Can you post the declaration of the plugin?
zach legein wrote:
Hi All,
How can I run sql:execute without binding it to a phase. I have
everything configured and I just want to run 'mvn sql:execute'
It seems like i should be able to do this but when I run
standalone(not bound to any phase) it doesn't find any of my
configured scripts to run.
[INFO] [sql:execute]
[INFO] 0 of 0 SQL statements executed successfully
[INFO]
------------------------------------------------------------------------
[INFO] BUILD SUCCESSFUL
[INFO]
------------------------------------------------------------------------
[INFO] Total time: 2 seconds
[INFO] Finished at: Thu Dec 06 17:40:50 PST 2007
[INFO] Final Memory: 2M/5M
[INFO]
------------------------------------------------------------------------
However, when I bind it to a phase:
<phase>process-test-resources</phase>
<goals><goal>execute</goal></goals>
It runs fine.
Can I run this standalone?
-zach
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
---------------------------------------------------------------------
To unsubscribe from this list please visit:
http://xircles.codehaus.org/manage_email
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
---------------------------------------------------------------------
To unsubscribe from this list please visit:
http://xircles.codehaus.org/manage_email
