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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
