SQL scripts in webapp

[Vinita Joshi]

I want to use sql scripts in my webapp which I am building using maven 2.
However, the scripts are executed when I run mvn package command. I want
these scripts to be executed when I deploy the app on geronimo.

 

Any help is appreciated.

 

Regards,

 

Vinita

 

 

I have added the following in my pom.xml

 

<plugins>

            <plugin>

 

        <groupId>org.codehaus.mojo</groupId>

        <artifactId>sql-maven-plugin</artifactId>

 

        <dependencies>

          <!-- specify the dependent jdbc driver here -->

          <dependency>

            <groupId>ojdbc14</groupId>

            <artifactId>ojdbc14</artifactId>

            <version>10.1.0.4.0</version>

          </dependency>

        </dependencies>

 

        <!-- common configuration shared by all executions -->

        <configuration>

           <username>sf</username>

           <password>sf</password>

           <!-- You can comment out username/password configurations and 

                have maven to look them up in your settings.xml using
${settingsKey}

           -->

           <settingsKeys>sensibleKey</settingsKeys>

           <driver>oracle.jdbc.driver.OracleDriver</driver>

           <url>jdbc:oracle:thin:@localhost:1521:orcl</url>

        </configuration>

 

        <executions>

 

          

          <execution>

            <id>create-data</id>

            <phase>process-test-resources</phase>

            <goals>

              <goal>execute</goal>

            </goals>

            <configuration>

              <fileset>

                <basedir>src</basedir>

                <includes>

                  <!-- These 2 files may not get executed in sequence, use
srcFiles instead, if needed -->

                  <include>test/sql/test-data.sql</include>

                  <!--<include>test/sql/test-data2.sql</include>-->

                </includes>

              </fileset>

            </configuration>

          </execution>

 

          

        </executions>

            </plugin>

            </plugins>