Deadlock Issues with MSSQL when Multithreading, Hibernate3.0

roshank · **Joined:** Mon Apr 11, 2005 8:23 am **Posts:** 4

Hi

I am facing an issue when I run my application in a multithreaded environment. Specifically I am facing deadlock problems even with as few as 5 threads. The same application when run seems to run fine on a MySQL with as many as 60 threads. Any pointers on how to resolve this in MSSQL?

The scenario is something like this:
I am trying to add an object called 'subscriber' with all the relevant details. The relationships are as follows.

There is a subscriber object(table) with many properties, subID being the primary key.
This object has a one-to-one mapping with another object 'individual', foreign key relationships with two other tables 'AdBook' and 'SubRole' with 'subID' property being the binding property.

The 'individual' object has an 'indID' to be the primary key. This object has a many-to-one relationship with the 'subscriber' object (subID). Also has a many-to-one relationship with a 'contact' object with 'contactID' property being the binding one.

The 'SubRole' has a composite key.... key-many-to-one with 'subscriber' object (subID) and key-many-to-one with yet another object called 'role'

The 'AdBook' object has a many-to-one relationship with 'subscriber' object (subID) and a foreign key with respect to the object 'contact' with 'adID' as binding property.

The 'contact' object has a many-to-one with 'AdBook' with 'adID' property, a 'contactID' as primary key, and a one-to-one relation with the 'individual' object

When I try to add a subscriber with multiple threads, I'm facing deadlock issues.

I'm using HibernateTemplate (Hibernate 3.0final version and Spring 1.2RC1)

Thanks

mate · **Posted:** Mon Apr 11, 2005 3:47 pm

Are you using the same isolation level on both RDBMSs?
(Are you at all using InnoDB with MySQL?)

roshank · **Joined:** Mon Apr 11, 2005 8:23 am **Posts:** 4

Yes. Am using the InnoDB with MySQL.

mate · **Posted:** Tue Apr 12, 2005 2:34 am

Was the "Yes" = "Yes, I am using the same isolation level on both MySQL and MS SQL"?

roshank · **Joined:** Mon Apr 11, 2005 8:23 am **Posts:** 4

Yes mate. I'm using the same Isolation level :)

baliukas · **Posted:** Thu Apr 14, 2005 8:21 am

Doe's it deadlock on "insert" ?

roshank · **Joined:** Mon Apr 11, 2005 8:23 am **Posts:** 4

It locks on insert, delete, update...
well...just about :)

baliukas · **Posted:** Fri Apr 15, 2005 4:16 pm

See system tables to find it, it looks like "syslockinfo" is used on MSSQL