Hi Guys,
I hope someone can help
I have two or more threads which are inserting into the same target database table, each having their own connection. The connection has autoCommit set to false and I am performing batch inserts (batch size 10) and am only commiting once all inserts have been performed per
thread.
My problem is that I am getting a deadlock, which I can't understand because I am only inserting into the one table.
I am using sybase 12.5.1
some output from sp_lock is below
Any help would be appreciated,
thanks.