incubator-graffito-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Salvio <sal...@geneticmail.com>
Subject MySQL Build issues
Date Mon, 30 Jan 2006 18:51:51 GMT
  Hi All,

I'm having the same problem seen in this thread: 
http://www.mail-archive.com/graffito-dev@incubator.apache.org/msg00279.html

What I have done is:

1. upgraded mysql to 4.1.16
2. downloaded and installed jetspeed2 multi db using
3. checked out the trunk of graffito
4. run a maven allClean allBuild using the attached build properties

I get this error message:
db.create:
db.execute:
    [echo] Execute SQL script : 
./target/src/sql/mysql/security-schema.sql -- ON ERROR = abort
    [sql] Executing file: 
C:\graffito\x\target\checkout\components\target\src\sql\mysql\security-schema.sql
    [sql] [ERROR] Failed to execute: # 
-----------------------------------------------------------------------
 # SECURITY_PRINCIPAL # 
-----------------------------------------------------------------------
 drop table if exists SECURITY_PRINCIPAL

BUILD FAILED
File...... C:\graffito\x\target\checkout\maven.xml
Element... maven:reactor
Line...... 88
Column.... 40
Unable to obtain goal [test:test] -- 
C:\graffito\x\target\checkout\components\maven.xml:286:38: <sql> 
java.sql.SQLException: Cannot delete or update a parent row: a foreign 
key constraint fails

I have also tried using BDB instead of the default INNODB and in this 
case the build and deploy complete successfully.
To complete the installation though I need to re-populate the following 
tables with the original data (before deploying graffito) and then run 
insert-j2-security.sql again. The tables are: principal_permission, 
security_credential, security_permission, security_principal, 
security_user_group, security_user_role.

- Salvio


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message