You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-dev@db.apache.org by "Bruno Cros (JIRA)" <ji...@apache.org> on 2006/12/15 09:38:21 UTC
[jira] Created: (OJB-126) Repository option :
Generate index on foreign key.
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: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org