Atomikos Forum

A note for SQL Server XA  'No Transaction Cookie was returned'

This is my first post, and I'd like to add some notes for this problem. Please read here.  default82df.html?community.6.3045.1

In my production server, this problem occurred infrequently which makes it very hard to reproduce. I tried the solution provided in the post by specifying hibernate.connection.release_mode to after_transaction, but it doesn't help. Finally, I figured it out that it was due to insufficient transaction timeout which caused this exception. If you have long transaction, please make sure it has enough time to complete it. Here is what I did in my DAO bean. The timeout was 20s, but it's not sufficient. Increase to 120s and problem solved.

@Transactional(propagation=Propagation.REQUIRED, readOnly=false, isolation=Isolation.DEFAULT, timeout=120)
    public boolean updateModel(Model model, String[] guiPartSelect, List<Schedule> sList, String userUuid)
    {
...
}
Po-Ting Huang Send private email
Friday, October 17, 2014
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics