Hi I've got a problem,
where jd:_db.create is not exectuting the schema SQL scripts. They ARE
definetely being created.
but for somereason not getting called.
Any ideas why this is occuring? Obviously I can write another script to
accomplish this. But.. It would be nice to do it through maven.
thanks,
Andy
......
C:\myportal>maven j2:quickStart
__ __
| \/ |__ _Apache__ ___
| |\/| / _` \ V / -_) ' \ ~ intelligent projects ~
|_| |_\__,_|\_/\___|_||_| v. 1.0.2
.......
.......<!-- this part is commented out as all is working fine -->
.......
j2:_db.create:
j2:_process.all.scripts.in.path:
[echo] Checking for SQL scripts at path
c:myportal/target/portal-sql/mysql/s
chema...
j2:_db.execute:
[sql] Executing file: C:\myportal\target\portal-sql\populate-
db-default.sql
[sql] [ERROR] Failed to execute: INSERT INTO CAPABILITY (CAPABILITY_ID,
CAPA
BILITY) VALUES(1,'HTML_3_2')
BUILD FAILED
File...... C:\Documents and
Settings\demo\.maven\cache\maven-jetspeed2-plugin-2.
0\plugin.jelly
Element... sql
Line...... 839
Column.... 44
java.sql.SQLException: Table 'jetspeed.CAPABILITY' doesn't exist
Total time: 12 seconds
Finished at: Mon Feb 27 00:18:52 PST 2006
