[jira] Created: (OJB-126) Repository <foreignkey ..> 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