Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

mvn sql:execute does not execute the scripts

 
noemi conde
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3275
5
Eclipse IDE Java Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Where does Maven recommend you put your SQL scripts?
 
noemi conde
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3275
5
Eclipse IDE Java Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Glad it worked out OK! it's main/src/sql if I remember correctly....
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic