ORA-08177: can't serialize access for this transaction

[Ranganath Bandari]

Hi,
I am running an application on WebSphere 4.0 with database Oracle 8.1 using
thin driver (non XA).
For some transaction it is giving the following error
from the session bean with default isolation level .

Received Exception Error: java.sql.SQLException: ORA-08177: can't serialize
access for this transaction

We also tried to change the isolation level to serializable but in that case
as well it throws a different exception:

ExceptionUtil X CNTR0019E: Non-application exception occurred while
processing method createTxn:
com.ibm.ejs.container.IsolationLevelChangeException
at
com.ibm.ejs.container.ContainerTx.setIsolationLevel(ContainerTx.java:545)
at com.ibm.ejs.container.EJSContainer.preInvoke(EJSContainer.java:2148)

can anyone help me out of this.

Thanks in advance.
Regards,
Ranganath

[Randy Schnier]

Ranganath,
Open a PMR with IBM Support. We recently fixed some problems in this
area where the EJB container was being overly aggressive (more than was
required) in the checking it does on isolation levels. The fixes will
appear in the 4.0.2 PTF to be released in the near future, and can be
made available via an e-fix if you require a fix for 4.0.1. (If you are
on 4.0.0, you will need to move up to at least 4.0.1.)

Thanks,
Randy Schnier
WebSphere EJB container development

Ranganath Bandari wrote:

--
Randy Schnier