We are developing our application using Websphere3.5 with Oracle 8.X database.
We are experiencing problems (ORA-08177 can not serialize exception during long transaction) during concurrent access from multiple transaction. We have all our Session and Entity Beans with
TX_ATTRIBUTE : TX_REQUIRED
ISOLATION LEVEL : TX_SERIALIZABLE
Persistance : BMP
Transaction : CMT
I understand that this is a known bug (Oracle bug #440317 ) and Oracle also agrees to it. Any patch . .any solution.
