You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Fonomni Communications <fo...@gmail.com> on 2006/02/27 09:25:35 UTC

mysql schema not being added - using maven plugin install

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