What database are you running?
With MySQL I run into similar issues and the only resolution was to drop/create the databases (test/production) before I started a build/deploy
Roger
Gary Shea wrote:
I read a thread on the mailing list that seemed to refer to this problem, but nothing that seemed like a resolution.
I'm running the latest cvs (as of a couple hours ago anyway), java 1.5.0.
The error occurs in the "Build and deploy the Jetspeed 2 Maven plugin Jetspeed 2 Maven Plugin" phase of the build. Here's where it blows:
db.execute: [sql] Executing file: /home/shea/work/dev/itr-portal/jetspeed-2/maven-plugin/target/classes/plugin-resources/hsql/phase2-schema.sql [sql] [ERROR] Failed to execute: drop table PROFILING_RULE if exists
BUILD FAILED File...... /home/shea/work/dev/itr-portal/jetspeed-2/maven.xml Element... maven:reactor Line...... 168 Column.... 40 Unable to obtain goal [deploy-plugin] -- /home/shea/work/dev/itr-portal/jetspeed-2/maven-plugin/maven.xml:110:39: <sql> java.sql.SQLException: Integrity constraint violation: SYS_REF_RULE_CRITERION_FK_1_4 table: RULE_CRITERION in statement [drop table PROFILING_RULE if exists] Total time: 7 minutes 7 seconds Finished at: Mon Dec 06 14:03:43 MST 2004
The sql in question seems inocuous enough; although I've never seen the 'if exists' before, it seemed to work in the previous 10 instances in that same file.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
