Whenever I try to build Jetspeed2, I get a constraint error when
creating the Database:
build:start:
allBuild:
check.required.properties:
torque:init:
db.scripts.gen:
[echo] Generating SQL schema creation scripts for HSQLDB
[torque-sql] Using classpath
[torque-sql] Generating to file
E:\java\eclipse\jakarta\jakarta-jetspeed-2\target\src\sql\hsql\report.portal.sql.generation
[echo] Generating SQL schema creation scripts for MySQL
[torque-sql] Using classpath
[torque-sql] Generating to file
E:\java\eclipse\jakarta\jakarta-jetspeed-2\target\src\sql\mysql\report.portal.sql.generation
[echo] Generating SQL schema creation scripts for Oracle
[torque-sql] Using classpath
[torque-sql] Generating to file
E:\java\eclipse\jakarta\jakarta-jetspeed-2\target\src\sql\oracle\report.portal.sql.generation
[echo] Generating SQL schema creation scripts for MS SQL
[torque-sql] Using classpath
[torque-sql] Generating to file
E:\java\eclipse\jakarta\jakarta-jetspeed-2\target\src\sql\mssql\report.portal.sql.generation
[echo] Generating SQL schema creation scripts for Postgres
[torque-sql] Using classpath
[torque-sql] Generating to file
E:\java\eclipse\jakarta\jakarta-jetspeed-2\target\src\sql\postgres\report.portal.sql.generation
db.create.test:
db.test.properties:
db.create:
db.execute:
[sql] Executing file:
E:\java\eclipse\jakarta\jakarta-jetspeed-2\target\src\sql\hsql\phase3ojb-schema.sql
[sql] 16 of 16 SQL statements executed successfully
db.execute:
[sql] Executing file:
E:\java\eclipse\jakarta\jakarta-jetspeed-2\target\src\sql\hsql\phase1-schema.sql
[sql] 16 of 16 SQL statements executed successfully
db.execute:
[sql] Executing file:
E:\java\eclipse\jakarta\jakarta-jetspeed-2\target\src\sql\hsql\phase2-schema.sql
[sql] 29 of 29 SQL statements executed successfully
db.execute:
[sql] Executing file:
E:\java\eclipse\jakarta\jakarta-jetspeed-2\target\src\sql\hsql\registry-schema.sql
[sql] 40 of 40 SQL statements executed successfully
db.execute:
[sql] Executing file:
E:\java\eclipse\jakarta\jakarta-jetspeed-2\target\src\sql\hsql\prefs-schema.sql
[sql] 9 of 9 SQL statements executed successfully
db.execute:
[sql] Executing file:
E:\java\eclipse\jakarta\jakarta-jetspeed-2\target\src\sql\hsql\security-schema.sql
[sql] [ERROR] Failed to execute: drop table SSO_SITE if exists
BUILD FAILED
File...... E:\java\eclipse\jakarta\jakarta-jetspeed-2\maven.xml
Element... sql
Line...... 355
Column.... 39
java.sql.SQLException: Integrity constraint violation:
SYS_REF_SSO_SITE_TO_CREDENTIALS_FK_1_749 table:
SSO_SITE_TO_CREDENTIALS in statement [drop table SSO_SITE if exists]
Total time: 16 seconds
Finished at: Fri Dec 03 09:46:07 GMT-03:00 2004
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
