db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bruno Cros (JIRA)" <j...@apache.org>
Subject [jira] Created: (OJB-126) Repository <foreignkey ..> option : Generate index on foreign key.
Date Fri, 15 Dec 2006 08:38:21 GMT
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

View raw message