Hi All, The scenerio here is JSP - Session Bean - Entity Bean - Oracle database Application Server - Websphere I am getting CORBA.TRANSACTION_ROLLEDBACK exception when the CMP entity bean is interacting with database. This exception is being thrown whenever there is an error in database side while inserting or updating the data through Entity Beans. My question is how to trap the specific database error in EJB client wherein I am always getting TRANSACTION_ROLLEDBACK exception which doesn't specify the exact error. Thanks in advance for reply. Kamal
My suggestion would be in your server-side code, catch SQLException and throw an application exception with the original exception details and probably theh SQL statement as well. That will at least give you a clue where to start and what might go wrong.
TRANSACTION_ROLLBACK is the most general WebSphere EJB exception. The other exception is actually wrapped within it. You can look in the stdout log file and it will include all of the SQL exception information you need. Kyle Brown ------------------ Kyle Brown, Editor of Enterprise Java (tm) Programming with IBM Websphere