Bug: Identifiers can be max 30 on ORA - we're generating with length 32 if the table name(s) are long

Bug 163 : Identifiers can be max 30 on ORA - we're generating with length 32 if the table name(s) are long
Priority	High	Reported Version		Logged By	Rob
Status	Fixed	Fixed Version	2.2.0	Assigned To
Product	Ebean - core	Duplicate Of		Created	06/10/2009
Updated	06/10/2009	Type	Bug
Attachments	No attachments
The following statment is not accepted by ORA alter table P_EMAIL_NOTMAIL_KUNDENDATEN add constraint fk_P_EMAIL_NOTMAIL_KD_02 foreign key (CV_NOTMAIL_KUNDENDATEN_stammnr) references CV_NOTMAIL_KUNDENDATEN (stammnr) on delete restrict on update restrict;

Rob 06 Oct 10:19

java.sql.SQLException: ORA-00972: identifier is too long

This is the oracle error thrown.

Rob 06 Oct 10:21

Fixed in HEAD

Adding to Oracle10Platform and Oracle9Platform.

dbDdlSyntax.setMaxConstraintNameLength(30);

Rob 17 Oct 04:25

Some more fixes

There where some more fixes required for this around unique constraint names and foreign key names.

Rob 05 Nov 11:26

Note: ...

Note this also included removing the "on delete restrict on update restrict;" from fk contraints.