Transaction timed out. (JBoss 321, INET-OPTA SQLServer JDBC

[snanduri]

Hi folks,

Environment :
JBoss 3.2.1 running on JDK 1.4.1_02, with INET OPTA JDBC drivers for SQLServer 2000.

I have a stateless session bean deployed with some remote methods that does call helper DAO classes to do persistence to the database. I had the transaction attribute for the methods set to "Required".

I don't see any transactions going thru in the database.

I am getting this warning.
11:09:54,991 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=servermachinepcf01//23, BranchQual=] timed out. status=STATUS_ACTIVE

11:21:28,188 ERROR [LogInterceptor] RuntimeException:

Can any one help me get over this problem

Thx in advance
Sri

[juhalindfors]

Your transaction is timing out, could be a some kind of deadlock scenario unless you're running very very long queries.