Repository <foreignkey ..> option : Generate index on foreign key. -------------------------------------------------------------------
Key: OJB-126 URL: http://issues.apache.org/jira/browse/OJB-126 Project: OJB Issue Type: New Feature Components: RDBMS platform-specific support, XDoclet module Affects Versions: 1.0.4 Environment: Oracle databases, and database supporting foreign key constraints Reporter: Bruno Cros Priority: Minor Regarding to Oracle recommendations, when using foreign key constraints, large tables referencing any tables to be updated or deleted, works better when table have a database index based on the foreign key codes. This is necessary to avoid dead lock errors (ORA-00060). The suggested option "generate_index=yes" could be put in <foreignkey > declaration and means that project schema script process generates index creation script (regarding to <foreign key> fields) in project schema sql script. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]