mvn sql:execute does not execute the scripts

[noemi conde]

Hi all !

I'd like to drop and create tables, and also insert data into them by using the command mvn sql:execute, I did this before with a postgresql DBMS.

Nom I'm using a ORACLE DBMS, I have 3 diferent databases, and I want to execute the scripts of dropping and creating tables, so I have 3 different profiles in the pom.xml (each one for eache different dababase) when I run that command associate to each profile, the conexion runs ok, but it does not execute any SQL statement,

here the interesting parts of the pom.xml

<profiles>
 
 <profile>
  <id>profile1</id> 
   <activation>
  <activeByDefault>false</activeByDefault> 
  </activation>
 <properties>
 <!--  JDBC driver properties 
   --> 
  <jdbcDriver.groupId>oracle</jdbcDriver.groupId> 
  <jdbcDriver.artifactId>ojdbc14</jdbcDriver.artifactId> 
  <jdbcDriver.version>10.2.0.4</jdbcDriver.version>
  <jdbcDriver.className>oracle.jdbc.OracleDriver</jdbcDriver.className> 
 <!--   Data source properties 
  --> 
  <dataSource.user>profile1</dataSource.user> 
  <dataSource.password>profile1</dataSource.password> 
  <dataSource.url>jdbc:oracle:thin:@localhost:1521:xe</dataSource.url> 
  <dataSource.createTablesScript>scripts/PROFILE1_CREATE_TABLES.sql</dataSource.createTablesScript> 
  </properties>
  </profile>
[...]
</profiles>

[...]

<plugin>
        <groupId>org.codehaus.mojo</groupId>
        <artifactId>sql-maven-plugin</artifactId>
        <version>1.3</version>

        <dependencies>
          <!-- specify the dependent jdbc driver here -->
          <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc14</artifactId>
            <version>10.2.0.4</version>
          </dependency>
        </dependencies>

        <!-- common configuration shared by all executions -->
        <configuration>
          <driver>${jdbcDriver.className}</driver>
          <url>${dataSource.url}</url>
          <username>${dataSource.user}</username>
          <password>${dataSource.password}</password>
          <!-- You can comment out username/password configurations and
               have maven to look them up in your settings.xml using ${settingsKey}
          -->
          <settingsKey>sensibleKey</settingsKey>
          <!--all executions are ignored if -Dmaven.test.skip=true-->
          <skip>${maven.test.skip}</skip>
          <fileset>
  	<basedir>${basedir}</basedir> 
			<includes>
  				<include>${dataSource.createTablesScript}</include> 
  			</includes>
  			</fileset>

        </configuration>
		<executions>
		       <execution>
            <id>create-schema</id>
            <phase>process-test-resources</phase>
            <goals>
              <goal>execute</goal>
            </goals>
            <configuration>
              <autocommit>true</autocommit>
              <srcFiles>
                <srcFile>${dataSource.url}</srcFile>
              </srcFiles>
            </configuration>
          </execution>
          
		</executions>
      </plugin>

and the result is:

[com.oracle:ojdbc14:jar:10.2.0.4:compile, org.apache.maven:maven-plugin-api:jar:2.0:runtime, org.apache.maven:maven-settings:jar:2.0:runtime, org.apache.maven:maven-model:jar:2.0:runtime, org.codehaus.plexus:plexus-utils:jar:1.0.4:runtime, org.codehaus.plexus:plexus-container-default:jar:1.0-alpha-8:runtime, classworlds:classworlds:jar:1.1-alpha-2:runtime]

for plugin: /plugins/org.codehaus.mojo:sql-maven-plugin:1.3@2073705224/thread:main
[DEBUG] Looking up mojo org.codehaus.mojo:sql-maven-plugin:1.3:execute in realm /plugins/org.codehaus.mojo:sql-maven-plugin:1.3@2073705224/thread:main - descRealmId=/plugins/org.codehaus.mojo:sql-maven-plugin:1.3@2073705224/thread:main
[DEBUG] Looked up - org.codehaus.mojo.sql.SqlExecMojo@1bc16f0 - ClassRealm[/plugins/org.codehaus.mojo:sql-maven-plugin:1.3@2073705224/thread:main, parent: ClassRealm[plexus.core, parent: null]]
[DEBUG] Configuring mojo 'org.codehaus.mojo:sql-maven-plugin:1.3:execute' with basic configurator -->
[DEBUG]   (f) autocommit = false
[DEBUG]   (s) delimiter = ;
[DEBUG]   (s) delimiterType = normal
[DEBUG]   (s) driver = oracle.jdbc.OracleDriver
[DEBUG]   (s) basedir = C:\Entorno\workspace\comun
[DEBUG]   (s) includes = [Ljava.lang.String;@1a9d1b
[DEBUG]   (f) fileset = org.codehaus.mojo.sql.Fileset@140984b
[DEBUG]   (s) keepFormat = false
[DEBUG]   (s) onError = abort
[DEBUG]   (s) password = profile1
[DEBUG]   (f) settings = org.apache.maven.settings.Settings@1a8773c
[DEBUG]   (f) settingsKey = sensibleKey
[DEBUG]   (f) skip = false
[DEBUG]   (f) skipOnConnectionError = false
[DEBUG]   (s) url = jdbc:oracle:thin:@localhost:1521:xe
[DEBUG]   (s) username = profile1
[DEBUG] -- end configuration --
[INFO] [sql:execute]
[DEBUG] Setting context classloader for plugin to: /plugins/org.codehaus.mojo:sql-maven-plugin:1.3@2073705224/thread:main (instance is: ClassRealm[/plugins/org.codehaus.mojo:sql-maven-plugin:1.3@2073705224/thread:main, parent: ClassRealm[plexus.core, parent: null]])
[DEBUG] connecting to jdbc:oracle:thin:@localhost:1521:xe
[DEBUG] Committing transaction
[INFO] 0 of 0 SQL statements executed successfully
[DEBUG] disposing managed ClassRealm with id: /plugins/org.codehaus.mojo:sql-maven-plugin:1.3@2073705224/thread:main
[DEBUG] dissociating all components from managed ClassRealm with id: /plugins/org.codehaus.mojo:sql-maven-plugin:1.3@2073705224/thread:main
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESSFUL

does anybody know why the hell the scripts are not executed !!! this is driving me crazyyy !!!

any ideas ?? I got no ideas left to try !

Thanks so much !

[Martijn Verburg]

Where does Maven recommend you put your SQL scripts?

[noemi conde]

Hi,
It's already worked out, it was a mistake in the path ...
I didn't know maven recommend some kind of path to put the SQL scripts.

[Martijn Verburg]

Glad it worked out OK! it's main/src/sql if I remember correctly....