Thanks Zach. Try adding an execution of "default"
<execution>
<id>create</id>
<goals><goal>execute</goal></goals>
</execution>
and see if that fires what you need.
zach legein wrote:
> 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
>
>
>
>
--
David J. Graff
djgraff AT alltel DOT net
GPG Fingerprint: E407 6A73 0725 B2E0 995D AC21 705E 4D51 67C4 7499
signature.asc
Description: OpenPGP digital signature
