Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Eclipselink 2.3 deadlock issues (Deadlock issues - EJB 3.0 with Eclipselink on WL12c)
Eclipselink 2.3 deadlock issues [message #1377333] Fri, 23 May 2014 20:53
Venkatesh Loganathan is currently offline Venkatesh LoganathanFriend
Messages: 1
Registered: May 2014
Junior Member
All,

The application is using Eclipse link 2.2.3 as its JPA provider on weblogic 12c . Until then Kodo was used as the JPA provider.

The database is SQL server 2008

With Eclipse link we started facing deadlock issues.



when the app is trying to update/merge a entity we are starting to get deadlock issues. The transaction is managed by the application . The transaction is committed as soon as its completed but still facing issues with deadlock.

what could be the reason for deadlock? No two transactions initiated by the application can update the same row. While doing a transaction , is the row locked or the table locked. IT should be the row right?Not sure who is holding the lock on the record and not releasing it. Should I manually call flush() after committing.

I believe as soon as the application starts the transaction , the autocommit is set to false

userTransaction.begin();
		//find entity, update and merge it 
userTransaction.commit();


Exception stack: 
Local Exception Stack: 
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLTransactionRollbackException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 178) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Error Code: 1205
Previous Topic:wrong xsd is generated for subclass
Next Topic:EclipseLink-MONGODB search not working
Goto Forum:
  


Current Time: Sat Feb 28 14:06:38 GMT 2015

Powered by FUDForum. Page generated in 0.02907 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software