[
https://issues.apache.org/jira/browse/OPENJPA-411?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Patrick Linskey updated OPENJPA-411:
------------------------------------
Fix Version/s: (was: 1.1.0)
1.2.0
> List.add(int,Object) is inefficient in default mappings
> -------------------------------------------------------
>
> Key: OPENJPA-411
> URL: https://issues.apache.org/jira/browse/OPENJPA-411
> Project: OpenJPA
> Issue Type: Improvement
> Affects Versions: 0.9.0, 0.9.6, 0.9.7, 1.0.0
> Reporter: Patrick Linskey
> Fix For: 1.2.0
>
> Attachments: OPENJPA-411.patch
>
>
> From [EMAIL PROTECTED]:
> When List.add(index, object) is being used
> OpenJPA sends the following sql statement, so the order of the elements can
> be built up from scratch:
> "Delete from RELATION_TABLE where ID = ?"
> In ms sql server this causes an exclusive lock on the entire table which of
> course easily introduces blocking issues (long running transactions having a
> shared lock or other client who like to insert objects in their list as
> well).
> List.add(Object) does not have this behaviour so when adding objects to the
> end of the list it is always better to use this method.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
