Hi all,
Here is the problem I have: I'd like to execute some sql scripts to create
tables by using de sql plugin. But even though the conexion with the
database is correct the scripts are no executed, so, here are the most
relevating parts of the pom.xml
(I know it can be done, cause I used to do it with a postgresql database)
<properties>
<jdbcDriver.className>oracle.jdbc.OracleDriver</jdbcDriver.className>
[....]
</properties>
1 - This is only the profile i'm trying :
<profiles>
<profile>
<id>profile1</id>
<activation>
<activeByDefault>false</activeByDefault>
</activation>
<properties>
<!-- 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>PROFILE1_CREATE_TABLES.sql</dataSource.createTablesScript>
</properties>
</profile>
[...]
</profiles>
2 - sql- plug-in:
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>sql-maven-plugin</artifactId>
<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>scripts/${dataSource.createTablesScript}</include>
</includes>
</fileset>
</configuration>
</plugin>
Now, I was trying without any executions, 'cause as I know they are no
neccesaries unless you need to execute some test (or doing sth in the test
db) , am I correct ? (I mean, I only need to execute the scripts to drop and
create tables in my databases)
this is the console output after execute the command: mvn -Pprofile1
sql:execute
for plugin:
/plugins/org.codehaus.mojo:sql-maven-plugin:1...@2073705224/thread:main
[DEBUG] Looking up mojo org.codehaus.mojo:sql-maven-plugin:1.4:execute in
realm /plugins/org.codehaus.mojo:sql-maven-plugin:1...@2073705224/thread:main
-
descRealmId=/plugins/org.codehaus.mojo:sql-maven-plugin:1...@2073705224/thread:main
[DEBUG] Looked up - org.codehaus.mojo.sql.sqlexecm...@16ea269 -
ClassRealm[/plugins/org.codehaus.mojo:sql-maven-plugin:1...@2073705224/thread:main,
parent: ClassRealm[plexus.core, parent: null]]
[DEBUG] Configuring mojo 'org.codehaus.mojo:sql-maven-plugin:1.4:execute'
with basic configurator -->
[DEBUG] (f) autocommit = false
[DEBUG] (s) delimiter = ;
[DEBUG] (s) delimiterType = normal
[DEBUG] (s) driver = oracle.jdbc.OracleDriver
[DEBUG] (f) enableAnonymousPassword = false
[DEBUG] (s) escapeProcessing = true
[DEBUG] (s) basedir = C:\Entorno\workspace\comun
[DEBUG] (s) includes = [Ljava.lang.String;@1e12f6d
[DEBUG] (f) fileset = org.codehaus.mojo.sql.file...@f0b4a3
[DEBUG] (f) forceMojoExecution = false
[DEBUG] (s) keepFormat = false
[DEBUG] (f) mavenSession = org.apache.maven.execution.mavensess...@e753
[DEBUG] (s) onError = abort
[DEBUG] (f) outputDelimiter = ,
[DEBUG] (s) password = profile1
[DEBUG] (f) project = MavenProject: es.everis:comun:0.0.1-SNAPSHOT @
C:\Entorno\workspace\comun\pom.xml
[DEBUG] (f) settings = org.apache.maven.settings.setti...@46d228
[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...@2073705224/thread:main
(instance is:
ClassRealm[/plugins/org.codehaus.mojo:sql-maven-plugin:1...@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...@2073705224/thread:main
[DEBUG] dissociating all components from managed ClassRealm with id:
/plugins/org.codehaus.mojo:sql-maven-plugin:1...@2073705224/thread:main
[INFO]
------------------------------------------------------------------------
[INFO] BUILD SUCCESSFUL
[INFO]
------------------------------------------------------------------------
[INFO] Total time: 8 seconds
[INFO] Finished at: Wed Sep 22 10:58:07 CEST 2010
[INFO] Final Memory: 2M/8M
[INFO]
------------------------------------------------------------------------
As you can see there are no SQL statements executed, so I don't know if
something needed is missing, in that case, what is that ??? or in the other
hand maven can't find the script, in case, what I have to do ??
I'm even wondering if it can be because of using oracle, cause as I said up
there, I used something like this with postgres.
I tried an unexisted sql, and also write some uncorrect characters in the
sql script and the result in both cases are the same put up there.
Any idea is really welcome !!!
--
View this message in context:
http://old.nabble.com/I-cannot-execute-some-sql-scripts-%21%21-tp29779816p29779816.html
Sent from the mojo - user mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
