Hi,

I'd like to ask a help for the hibernate's community.
I have a application (Hibernate 3.2, SQL Server 2000). This application is a EJB, critical, used parallel way.

Sometimes happens a error of deadlock (SQL Error: 1205) and my application is stoped. This errors is between 2 methods, where, each method have a session and each session is closed - this methods is 2 diferentes selects (just selects), but in the same record in DB.

I already try to use dirty transaction, isolation level, lockmode...
The only solution I found its was to write sql and to instantiate all objects envolved, without to use hibernate. Its work, but is very, very hard.

Anyone can help me?

Att.
Anderson

We had this problem a while ago. At the time HB was not putting with (nolock) statements in generated selects and one of the guys in our team modified the HB code so that it includes with (nolock) statements when LockMode.NONE is used. I am not aware if hibernate has fixed this problem or has any intention to do so but you can always modify hibernate's code.



Farzad-

I am also using mssql database in my application, im getting errors while connecting to mssql using hibernate. Can you please tell me how to connect to mssql with hibernate?

What errors?


Farzad-