portals-jetspeed-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Liao <jian.l...@gmail.com>
Subject Re: Build fail again
Date Thu, 10 Nov 2005 01:40:29 GMT
Hi randy and david,
Thanks for your respond. I tested it again, but the problem still exist.
1. Recreat the oracle database user.
2. Update the j2 src.
3. Rebuild it and deploy to oracle database.
The following is the detail error message:
[sql] [ERROR] Failed to execute: ALTER TABLE PAGE_SECURITY_CONSTRAINTS_REF
ADD CONSTRAINT PAGE_S
ECURITY_CONSTRAINTS_FK_1 FOREIGN KEY (PAGE_SECURITY_ID) REFERENCES
PAGE_SECURITY (PAGE_SECURITY_ID)
ON DELETE CASCADE

BUILD FAILED
File...... C:\Documents and Settings\jliao\.maven\cache\maven-
jetspeed2-plugin-2.0-M4-SNAPSHOT\plugi
n.jelly
Element... sql
Line...... 866
Column.... 44
java.sql.SQLException: *ORA**-**02264*: name already used by an existing
constraint <http://ora-02264.ora-code.com/>

- Jian Liao

On 11/9/05, Randy Watler <watler@wispertel.net> wrote:
>
> James,
>
> Did you test this on a clean DB? We have been changing table names so
> often, (my fault), that we might have accidental overlap between
> versions. If you can, please try to remove all tables and constraints
> starting with PAGE, FOLDER, and FRAGMENT.
>
> Sorry for the confusion.
>
> Randy
>
> David Sean Taylor wrote:
>
> > James Liao wrote:
> >
> >> Hi,
> >> This line execute fail for Oracle 10gr2:
> >> ALTER TABLE PAGE_SECURITY_CONSTRAINTS_REF ADD CONSTRAINT PAGE_S
> >> ECURITY_CONSTRAINTS_FK_1 FOREIGN KEY (PAGE_SECURITY_ID) REFERENCES
> >> PAGE_SECURITY (PAGE_SECURITY_ID)
> >> ON DELETE CASCADE
> >>
> >> It seems that PAGE_SECURITY_CONSTRAINTS_FK_1 had been used by table
> >> PAGE_SECURITY_CONSTRAINTS_DEF alert.
> >>
> >> - Jian Liao
> >>
> > seems to work fine here on MySQL
> > I'll test against Oracle tomorrow
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-dev-help@portals.apache.org
>
>

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