Get your CodeRanch badge!*
The moose likes Ant, Maven and Other Build Tools and the fly likes mvn sql:execute does not execute the scripts Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Engineering » Ant, Maven and Other Build Tools
Bookmark "mvn sql:execute does not execute the scripts" Watch "mvn sql:execute does not execute the scripts" New topic
Author

mvn sql:execute does not execute the scripts

noemi conde
Greenhorn

Joined: May 05, 2010
Posts: 14
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




and the result is:



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
author
Bartender

Joined: Jun 24, 2003
Posts: 3274
    
    5

Where does Maven recommend you put your SQL scripts?


Cheers, Martijn - Blog,
Twitter, PCGen, Ikasan, My The Well-Grounded Java Developer book!,
My start-up.
noemi conde
Greenhorn

Joined: May 05, 2010
Posts: 14
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
author
Bartender

Joined: Jun 24, 2003
Posts: 3274
    
    5

Glad it worked out OK! it's main/src/sql if I remember correctly....
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: mvn sql:execute does not execute the scripts
 
Similar Threads
Trouble with running Maven Tomcat plugin through Eclipse
Richfaces + Spring + Maven Setup help
how do i send a email test report from maven
Filtering problem using maven-read-properties plugin in pom.xml file
Could not resolve dependencies for maven project