This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
we are using a 3rd party EJB product in our application and it sometimes throws
2007-07-05 16:08:24,709 [WebContainer : 3] ERROR Sonora.Fields.FmsTableSessionBean - wasdev2 update >>> Unexpected exception: javax.ejb.TransactionRolledbackLocalException: ; nested exception is: javax.ejb.EJBException: [SQL0913] Row or object SONOR00039 in SONORACA type *FILE in use.S_EXCP(9)
as per our DBA,the application is trying to do an update or delete transaction and it is no being committed so when another process is trying to get this resource the database will response that the table is in use or lock.
if i call ejb.remove(), will it relase the lock on table and ends transaction ? is there any alternate solution for this issue ? we are using DB2 over iSeries v5.3