Atomikos Forum |
|
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) { ... } |