Re: sql-maven-plugin execution problem with Integration-test
You are missing a space in your sql query after the *.
-ketil
On Thu, Apr 23, 2009 at 10:47 AM, Karl Heinz Marbaise khmarba...@gmx.de wrote:
Hi there,
I have a large multi module project which is working well.
Now i'm trying to enhance this with a things which is in relationship with
the database...
Ok i decided to take a look at the sql-maven-plugin to execute some SQL
statements before an integration test is run (simply delete the contents of
the databases as a first step)...
But no i ran into the following problem:
I have taken the configuration of the plugin from the examples page:
http://mojo.codehaus.org/sql-maven-plugin/examples/execute.html
I'm using Maven 2.0.10 (tested the problem with 2.0.9 with the same result).
Here is the snipped from the POM.xml file:
plugin
groupIdorg.codehaus.mojo/groupId
artifactIdsql-maven-plugin/artifactId
version1.3/version
dependencies
dependency
groupId${database.pom.groupId}/groupId
artifactId${database.pom.artifactId}/artifactId
version${database.pom.version}/version
/dependency
/dependencies
configuration
driver${database.driverClassName}/driver
url${database.url}/url
username${database.username}/username
password${database.password}/password
/configuration
executions
execution
iddrop-db-before-test-if-any/id
phaseprocess-test-resources/phase
goals
goalexecute/goal
/goals
configuration
sqlCommandSELECT *FROM table/sqlCommand
/configuration
/execution
/executions
/plugin
May be i'm completely blind and oversight things...
The following is printed out:
C:\DEV\workspace\.\itmvn clean integration-test
Using User setting from T:/System/.m2/settings.xml
Using Memory settings: -Xms256m -Xmx1024m
[INFO] Scanning for projects...
[INFO]
[INFO] Building XXX X :: Integration Test
[INFO] task-segment: [clean, integration-test]
[INFO]
[INFO] [clean:clean]
[INFO] Deleting file-set: C:\DEV\workspace\ (included: [], excluded: [])
[INFO] [cobertura:clean {execution: clean}]
[INFO] [antrun:run {execution: default}]
[INFO] Executed tasks
[INFO] [sql:execute {execution: drop-db-before-test-if-any}]
[INFO]
[ERROR] BUILD ERROR
[INFO]
[INFO] Ung³ltige Argumente in Aufruf
[INFO]
[INFO] For more information, run Maven with the -e switch
[INFO]
[INFO] Total time: 5 seconds
[INFO] Finished at: Thu Apr 23 10:29:18 CEST 2009
[INFO] Final Memory: 19M/254M
[INFO]
So i have called Maven with -X
[DEBUG] Configuring mojo 'org.codehaus.mojo:sql-maven-plugin:1.3:execute'
--
[DEBUG] (f) autocommit = false
[DEBUG] (s) delimiter = ;
[DEBUG] (s) delimiterType = normal
[DEBUG] (s) driver = oracle.jdbc.driver.OracleDriver
[DEBUG] (s) keepFormat = false
[DEBUG] (s) onError = abort
[DEBUG] (s) password = X
[DEBUG] (f) settings = org.apache.maven.settings.setti...@7b1641
[DEBUG] (f) skip = false
[DEBUG] (f) skipOnConnectionError = false
[DEBUG] (s) sqlCommand = SELECT *FROM XX
[DEBUG] (s) url = jdbc:oracle:thin:@DATABASESIDX
[DEBUG] -- end configuration --
[INFO] [sql:execute {execution: drop-db-before-test-if-any}]
[DEBUG] connecting to jdbc:oracle:thin:@DATABASIDX
[INFO]
[ERROR] BUILD ERROR
[INFO]
[INFO] Ung³ltige Argumente in Aufruf
[INFO]
[DEBUG] Trace
org.apache.maven.lifecycle.LifecycleExecutionException: Ung³ltige Argumente
in Aufruf
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:584)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalWithLifecycle(DefaultLifecycleExecutor.java:500)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:479)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:331)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:292)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:142)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:336)
at
Re: sql-maven-plugin execution problem with Integration-test
And table is a reserved word in sql, so you should insert your real
table name there.
-ketil
On Thu, Apr 23, 2009 at 10:47 AM, Karl Heinz Marbaise khmarba...@gmx.de wrote:
Hi there,
I have a large multi module project which is working well.
Now i'm trying to enhance this with a things which is in relationship with
the database...
Ok i decided to take a look at the sql-maven-plugin to execute some SQL
statements before an integration test is run (simply delete the contents of
the databases as a first step)...
But no i ran into the following problem:
I have taken the configuration of the plugin from the examples page:
http://mojo.codehaus.org/sql-maven-plugin/examples/execute.html
I'm using Maven 2.0.10 (tested the problem with 2.0.9 with the same result).
Here is the snipped from the POM.xml file:
plugin
groupIdorg.codehaus.mojo/groupId
artifactIdsql-maven-plugin/artifactId
version1.3/version
dependencies
dependency
groupId${database.pom.groupId}/groupId
artifactId${database.pom.artifactId}/artifactId
version${database.pom.version}/version
/dependency
/dependencies
configuration
driver${database.driverClassName}/driver
url${database.url}/url
username${database.username}/username
password${database.password}/password
/configuration
executions
execution
iddrop-db-before-test-if-any/id
phaseprocess-test-resources/phase
goals
goalexecute/goal
/goals
configuration
sqlCommandSELECT *FROM table/sqlCommand
/configuration
/execution
/executions
/plugin
May be i'm completely blind and oversight things...
The following is printed out:
C:\DEV\workspace\.\itmvn clean integration-test
Using User setting from T:/System/.m2/settings.xml
Using Memory settings: -Xms256m -Xmx1024m
[INFO] Scanning for projects...
[INFO]
[INFO] Building XXX X :: Integration Test
[INFO] task-segment: [clean, integration-test]
[INFO]
[INFO] [clean:clean]
[INFO] Deleting file-set: C:\DEV\workspace\ (included: [], excluded: [])
[INFO] [cobertura:clean {execution: clean}]
[INFO] [antrun:run {execution: default}]
[INFO] Executed tasks
[INFO] [sql:execute {execution: drop-db-before-test-if-any}]
[INFO]
[ERROR] BUILD ERROR
[INFO]
[INFO] Ung³ltige Argumente in Aufruf
[INFO]
[INFO] For more information, run Maven with the -e switch
[INFO]
[INFO] Total time: 5 seconds
[INFO] Finished at: Thu Apr 23 10:29:18 CEST 2009
[INFO] Final Memory: 19M/254M
[INFO]
So i have called Maven with -X
[DEBUG] Configuring mojo 'org.codehaus.mojo:sql-maven-plugin:1.3:execute'
--
[DEBUG] (f) autocommit = false
[DEBUG] (s) delimiter = ;
[DEBUG] (s) delimiterType = normal
[DEBUG] (s) driver = oracle.jdbc.driver.OracleDriver
[DEBUG] (s) keepFormat = false
[DEBUG] (s) onError = abort
[DEBUG] (s) password = X
[DEBUG] (f) settings = org.apache.maven.settings.setti...@7b1641
[DEBUG] (f) skip = false
[DEBUG] (f) skipOnConnectionError = false
[DEBUG] (s) sqlCommand = SELECT *FROM XX
[DEBUG] (s) url = jdbc:oracle:thin:@DATABASESIDX
[DEBUG] -- end configuration --
[INFO] [sql:execute {execution: drop-db-before-test-if-any}]
[DEBUG] connecting to jdbc:oracle:thin:@DATABASIDX
[INFO]
[ERROR] BUILD ERROR
[INFO]
[INFO] Ung³ltige Argumente in Aufruf
[INFO]
[DEBUG] Trace
org.apache.maven.lifecycle.LifecycleExecutionException: Ung³ltige Argumente
in Aufruf
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:584)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalWithLifecycle(DefaultLifecycleExecutor.java:500)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:479)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:331)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:292)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:142)
at
Re: sql-maven-plugin execution problem with Integration-test
Hi,
You are missing a space in your sql query after the *.
I changed it...SELECT * FROM table, but the reaction was the same and
i excepted nothing else, cause the syntax does not require a space...
On the other hand the problem seemed to more located into the area of
the lifecycle cause the error message is giving me such a hint...
But thanks for you response...
Kind regards
Karl Heinz Marbaise
-ketil
On Thu, Apr 23, 2009 at 10:47 AM, Karl Heinz Marbaise khmarba...@gmx.de wrote:
Hi there,
I have a large multi module project which is working well.
Now i'm trying to enhance this with a things which is in relationship with
the database...
Ok i decided to take a look at the sql-maven-plugin to execute some SQL
statements before an integration test is run (simply delete the contents of
the databases as a first step)...
But no i ran into the following problem:
I have taken the configuration of the plugin from the examples page:
http://mojo.codehaus.org/sql-maven-plugin/examples/execute.html
I'm using Maven 2.0.10 (tested the problem with 2.0.9 with the same result).
Here is the snipped from the POM.xml file:
plugin
groupIdorg.codehaus.mojo/groupId
artifactIdsql-maven-plugin/artifactId
version1.3/version
dependencies
dependency
groupId${database.pom.groupId}/groupId
artifactId${database.pom.artifactId}/artifactId
version${database.pom.version}/version
/dependency
/dependencies
configuration
driver${database.driverClassName}/driver
url${database.url}/url
username${database.username}/username
password${database.password}/password
/configuration
executions
execution
iddrop-db-before-test-if-any/id
phaseprocess-test-resources/phase
goals
goalexecute/goal
/goals
configuration
sqlCommandSELECT *FROM table/sqlCommand
/configuration
/execution
/executions
/plugin
May be i'm completely blind and oversight things...
The following is printed out:
C:\DEV\workspace\.\itmvn clean integration-test
Using User setting from T:/System/.m2/settings.xml
Using Memory settings: -Xms256m -Xmx1024m
[INFO] Scanning for projects...
[INFO]
[INFO] Building XXX X :: Integration Test
[INFO]task-segment: [clean, integration-test]
[INFO]
[INFO] [clean:clean]
[INFO] Deleting file-set: C:\DEV\workspace\ (included: [], excluded: [])
[INFO] [cobertura:clean {execution: clean}]
[INFO] [antrun:run {execution: default}]
[INFO] Executed tasks
[INFO] [sql:execute {execution: drop-db-before-test-if-any}]
[INFO]
[ERROR] BUILD ERROR
[INFO]
[INFO] Ung³ltige Argumente in Aufruf
[INFO]
[INFO] For more information, run Maven with the -e switch
[INFO]
[INFO] Total time: 5 seconds
[INFO] Finished at: Thu Apr 23 10:29:18 CEST 2009
[INFO] Final Memory: 19M/254M
[INFO]
So i have called Maven with -X
[DEBUG] Configuring mojo 'org.codehaus.mojo:sql-maven-plugin:1.3:execute'
--
[DEBUG] (f) autocommit = false
[DEBUG] (s) delimiter = ;
[DEBUG] (s) delimiterType = normal
[DEBUG] (s) driver = oracle.jdbc.driver.OracleDriver
[DEBUG] (s) keepFormat = false
[DEBUG] (s) onError = abort
[DEBUG] (s) password = X
[DEBUG] (f) settings = org.apache.maven.settings.setti...@7b1641
[DEBUG] (f) skip = false
[DEBUG] (f) skipOnConnectionError = false
[DEBUG] (s) sqlCommand = SELECT *FROM XX
[DEBUG] (s) url = jdbc:oracle:thin:@DATABASESIDX
[DEBUG] -- end configuration --
[INFO] [sql:execute {execution: drop-db-before-test-if-any}]
[DEBUG] connecting to jdbc:oracle:thin:@DATABASIDX
[INFO]
[ERROR] BUILD ERROR
[INFO]
[INFO] Ung³ltige Argumente in Aufruf
[INFO]
[DEBUG] Trace
org.apache.maven.lifecycle.LifecycleExecutionException: Ung³ltige Argumente
in Aufruf
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:584)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalWithLifecycle(DefaultLifecycleExecutor.java:500)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:479)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:331)
at
Re: sql-maven-plugin execution problem with Integration-test
Hi,
And table is a reserved word in sql, so you should insert your real
table name there.
Yes of course i know...in the real example here i have a real table
name, but i don't want to write real names in the post into the mailing
list...
Kind regards
Karl Heinz Marbaise
-ketil
On Thu, Apr 23, 2009 at 10:47 AM, Karl Heinz Marbaise khmarba...@gmx.de wrote:
Hi there,
I have a large multi module project which is working well.
Now i'm trying to enhance this with a things which is in relationship with
the database...
Ok i decided to take a look at the sql-maven-plugin to execute some SQL
statements before an integration test is run (simply delete the contents of
the databases as a first step)...
But no i ran into the following problem:
I have taken the configuration of the plugin from the examples page:
http://mojo.codehaus.org/sql-maven-plugin/examples/execute.html
I'm using Maven 2.0.10 (tested the problem with 2.0.9 with the same result).
Here is the snipped from the POM.xml file:
plugin
groupIdorg.codehaus.mojo/groupId
artifactIdsql-maven-plugin/artifactId
version1.3/version
dependencies
dependency
groupId${database.pom.groupId}/groupId
artifactId${database.pom.artifactId}/artifactId
version${database.pom.version}/version
/dependency
/dependencies
configuration
driver${database.driverClassName}/driver
url${database.url}/url
username${database.username}/username
password${database.password}/password
/configuration
executions
execution
iddrop-db-before-test-if-any/id
phaseprocess-test-resources/phase
goals
goalexecute/goal
/goals
configuration
sqlCommandSELECT *FROM table/sqlCommand
/configuration
/execution
/executions
/plugin
May be i'm completely blind and oversight things...
The following is printed out:
C:\DEV\workspace\.\itmvn clean integration-test
Using User setting from T:/System/.m2/settings.xml
Using Memory settings: -Xms256m -Xmx1024m
[INFO] Scanning for projects...
[INFO]
[INFO] Building XXX X :: Integration Test
[INFO]task-segment: [clean, integration-test]
[INFO]
[INFO] [clean:clean]
[INFO] Deleting file-set: C:\DEV\workspace\ (included: [], excluded: [])
[INFO] [cobertura:clean {execution: clean}]
[INFO] [antrun:run {execution: default}]
[INFO] Executed tasks
[INFO] [sql:execute {execution: drop-db-before-test-if-any}]
[INFO]
[ERROR] BUILD ERROR
[INFO]
[INFO] Ung³ltige Argumente in Aufruf
[INFO]
[INFO] For more information, run Maven with the -e switch
[INFO]
[INFO] Total time: 5 seconds
[INFO] Finished at: Thu Apr 23 10:29:18 CEST 2009
[INFO] Final Memory: 19M/254M
[INFO]
So i have called Maven with -X
[DEBUG] Configuring mojo 'org.codehaus.mojo:sql-maven-plugin:1.3:execute'
--
[DEBUG] (f) autocommit = false
[DEBUG] (s) delimiter = ;
[DEBUG] (s) delimiterType = normal
[DEBUG] (s) driver = oracle.jdbc.driver.OracleDriver
[DEBUG] (s) keepFormat = false
[DEBUG] (s) onError = abort
[DEBUG] (s) password = X
[DEBUG] (f) settings = org.apache.maven.settings.setti...@7b1641
[DEBUG] (f) skip = false
[DEBUG] (f) skipOnConnectionError = false
[DEBUG] (s) sqlCommand = SELECT *FROM XX
[DEBUG] (s) url = jdbc:oracle:thin:@DATABASESIDX
[DEBUG] -- end configuration --
[INFO] [sql:execute {execution: drop-db-before-test-if-any}]
[DEBUG] connecting to jdbc:oracle:thin:@DATABASIDX
[INFO]
[ERROR] BUILD ERROR
[INFO]
[INFO] Ung³ltige Argumente in Aufruf
[INFO]
[DEBUG] Trace
org.apache.maven.lifecycle.LifecycleExecutionException: Ung³ltige Argumente
in Aufruf
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:584)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalWithLifecycle(DefaultLifecycleExecutor.java:500)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:479)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:331)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:292)
at
Re: sql-maven-plugin execution problem with Integration-test
Well, the exception raised is caused by an SQLException, and it seems
to say that you have an illegal argument in your query if my german is
not all wrong.
Caused by: java.sql.SQLException: Ungłltige Argumente in Aufruf
-ketil
On Thu, Apr 23, 2009 at 11:08 AM, Karl Heinz Marbaise khmarba...@gmx.de wrote:
Hi,
You are missing a space in your sql query after the *.
I changed it...SELECT * FROM table, but the reaction was the same and i
excepted nothing else, cause the syntax does not require a space...
On the other hand the problem seemed to more located into the area of the
lifecycle cause the error message is giving me such a hint...
But thanks for you response...
Kind regards
Karl Heinz Marbaise
-ketil
On Thu, Apr 23, 2009 at 10:47 AM, Karl Heinz Marbaise khmarba...@gmx.de
wrote:
Hi there,
I have a large multi module project which is working well.
Now i'm trying to enhance this with a things which is in relationship
with
the database...
Ok i decided to take a look at the sql-maven-plugin to execute some SQL
statements before an integration test is run (simply delete the contents
of
the databases as a first step)...
But no i ran into the following problem:
I have taken the configuration of the plugin from the examples page:
http://mojo.codehaus.org/sql-maven-plugin/examples/execute.html
I'm using Maven 2.0.10 (tested the problem with 2.0.9 with the same
result).
Here is the snipped from the POM.xml file:
plugin
groupIdorg.codehaus.mojo/groupId
artifactIdsql-maven-plugin/artifactId
version1.3/version
dependencies
dependency
groupId${database.pom.groupId}/groupId
artifactId${database.pom.artifactId}/artifactId
version${database.pom.version}/version
/dependency
/dependencies
configuration
driver${database.driverClassName}/driver
url${database.url}/url
username${database.username}/username
password${database.password}/password
/configuration
executions
execution
iddrop-db-before-test-if-any/id
phaseprocess-test-resources/phase
goals
goalexecute/goal
/goals
configuration
sqlCommandSELECT *FROM table/sqlCommand
/configuration
/execution
/executions
/plugin
May be i'm completely blind and oversight things...
The following is printed out:
C:\DEV\workspace\.\itmvn clean integration-test
Using User setting from T:/System/.m2/settings.xml
Using Memory settings: -Xms256m -Xmx1024m
[INFO] Scanning for projects...
[INFO]
[INFO] Building XXX X :: Integration Test
[INFO] task-segment: [clean, integration-test]
[INFO]
[INFO] [clean:clean]
[INFO] Deleting file-set: C:\DEV\workspace\ (included: [], excluded:
[])
[INFO] [cobertura:clean {execution: clean}]
[INFO] [antrun:run {execution: default}]
[INFO] Executed tasks
[INFO] [sql:execute {execution: drop-db-before-test-if-any}]
[INFO]
[ERROR] BUILD ERROR
[INFO]
[INFO] Ungłltige Argumente in Aufruf
[INFO]
[INFO] For more information, run Maven with the -e switch
[INFO]
[INFO] Total time: 5 seconds
[INFO] Finished at: Thu Apr 23 10:29:18 CEST 2009
[INFO] Final Memory: 19M/254M
[INFO]
So i have called Maven with -X
[DEBUG] Configuring mojo 'org.codehaus.mojo:sql-maven-plugin:1.3:execute'
--
[DEBUG] (f) autocommit = false
[DEBUG] (s) delimiter = ;
[DEBUG] (s) delimiterType = normal
[DEBUG] (s) driver = oracle.jdbc.driver.OracleDriver
[DEBUG] (s) keepFormat = false
[DEBUG] (s) onError = abort
[DEBUG] (s) password = X
[DEBUG] (f) settings = org.apache.maven.settings.setti...@7b1641
[DEBUG] (f) skip = false
[DEBUG] (f) skipOnConnectionError = false
[DEBUG] (s) sqlCommand = SELECT *FROM XX
[DEBUG] (s) url = jdbc:oracle:thin:@DATABASESIDX
[DEBUG] -- end configuration --
[INFO] [sql:execute {execution: drop-db-before-test-if-any}]
[DEBUG] connecting to jdbc:oracle:thin:@DATABASIDX
[INFO]
[ERROR] BUILD ERROR
[INFO]
[INFO] Ungłltige Argumente in Aufruf
[INFO]
[DEBUG] Trace
org.apache.maven.lifecycle.LifecycleExecutionException: Ungłltige
Argumente
in Aufruf
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:584)
at
Re: sql-maven-plugin execution problem with Integration-test
Hi, Well, the exception raised is caused by an SQLException, and it seems to say that you have an illegal argument in your query if my german is not all wrong. Caused by: java.sql.SQLException: Ungłltige Argumente in Aufruf Correct...(Your knowledge of german is not wrong ;-))... But now i simplified the thing more and using the following: sqlCommandSELECT sysdate from dual;/sqlCommand and got the same result... Kind regards Karl Heinz Marbaise -- SoftwareEntwicklung Beratung SchulungTel.: +49 (0) 2405 / 415 893 Dipl.Ing.(FH) Karl Heinz MarbaiseICQ#: 135949029 Hauptstrasse 177 USt.IdNr: DE191347579 52146 Würselen http://www.soebes.de - To unsubscribe, e-mail: users-unsubscr...@maven.apache.org For additional commands, e-mail: users-h...@maven.apache.org
Re: sql-maven-plugin execution problem with Integration-test
Hi there,
after a longer break i found the issue based on the suggestions of You...
username${database.username}/username
it simply has to be changed into ${database.user} so it was simply not
using the correct propertyfor the username...
I was a little bit confused based on the stack trace...;-(
Many thanks for the help...
Kind regards
Karl Heinz Marbaise
--
SoftwareEntwicklung Beratung SchulungTel.: +49 (0) 2405 / 415 893
Dipl.Ing.(FH) Karl Heinz MarbaiseICQ#: 135949029
Hauptstrasse 177 USt.IdNr: DE191347579
52146 Würselen http://www.soebes.de
-
To unsubscribe, e-mail: users-unsubscr...@maven.apache.org
For additional commands, e-mail: users-h...@maven.apache.org
