Using scope_identity() on M$SQL should prevent this isssue.

The biggest source of this is triggers, from what i understand of it.

Larry


On 10/25/05, Pablo López <[EMAIL PROTECTED]> wrote:
Thanks Oleska for your interesing info.

I thought that as the selectKey is "inside" the insertion tag in IBatis,
Ibatis would take care for the whole operation to be atomic, so Oleska's
example could never happen, but I'm not sure about it.

Can anyone clarify this?

Anyway, having a look at the MSDN and at

http://www.databasejournal.com/features/mssql/article.php/10894_3307541_2

may help.

Thanks a lot :)

Pablo.


Reply via email to