Hello,
I'm trying to use the sql-maven-plugin with maven2 and I'm having
trouble getting it to execute the configuration. I'm using the command
'mvn sql:execute' with the following pom. The output is "0 of 0 SQL
Statements executed successfully". It does the same thing with
<sqlCommand> instead of <srcFiles>. What am I missing?
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>sql-maven-plugin</artifactId>
<dependencies>
<dependency>
<groupId>jdbc</groupId>
<artifactId>oracle</artifactId>
<version>1.4</version>
</dependency>
</dependencies>
<configuration>
<username>smcs</username>
<password>bogus</password>
<driver>oracle.jdbc.driver.OracleDriver</driver>
<url>jdbc:oracle:thin:@localhost:1521:XE</url>
</configuration>
<executions>
<execution>
<id>drop-db</id>
<goals>
<goal>execute</goal>
</goals>
<configuration>
<sqlCommand>drop table status</sqlCommand>
<srcFiles>
<srcFile>src/main/resource/sql/oracle/drop.sql</srcFile>
</srcFiles>
<onError>continue</onError>
</configuration>
</execution>
<execution>
<id>create-db</id>
<goals>
<goal>execute</goal>
</goals>
<configuration>
<srcFiles>
<srcFile>src/main/resource/sql/oracle/create.sql</srcFile>
</srcFiles>
</configuration>
</execution>
</executions>
</plugin>
---------------------------------------------------------------------
To unsubscribe from this list please visit:
http://xircles.codehaus.org/manage_email
