PQ60430: CMP ENTITY BEANS ACCESSED VIA STATELESS SESSION BEAN BLOCKED

APAR status
Closed as program error.

Error description
CMP entity beans accessed via stateless session bean get blocked
when the container detects transaction time out, namely they get
severe blocking (a new transaction waits until "Connection time
out"). Transactions are container managed. After the timeout the
transaction is rolled back but the row for the first entity bean
remain locked in DB.
Local fix Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Server users of        *
*                 PreparedStatements inside Connection         *
*                 Management.                                  *
****************************************************************
* PROBLEM DESCRIPTION: Locks not freeing after Transaction     *
*                      Timeout occurs and problems using       *
*                      prepared statements.                    *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
1. Locks not freeing after Transaction Timeout occurs.
2. When using prepared statements, an error can occur and
work involving the prepared statement is not completed and
the connection is not rolled back nor returned to the
connection pool.
Problem conclusion
1) Rollbacks are delayed when the transaction timeout occurs
   and there is still work in progress for the transaction.
   Normally what should happen is that the rollback will be
   performed when the work in progress completes.  However,
   there are times when the rollback will not occur due to the
   connection having been marked closed before the work has
   completed.  This fix ensures that the rollback will be
   performed and so the locks will be freed.
2) Closes on prepared statements were not being properly
   synchronized, this has been fixed.
Temporary fix
The customer has the final E-Fix for the ASV35 release.
Comments
APAR information
APAR number PQ60430
Reported component name WEBSPHERE AE AI
Reported component ID 5630A2200
Reported release 400
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Submitted date 2002-04-23
Closed date 2002-04-23
Last modified date 2002-04-23

APAR is sysrouted FROM one or more of the following:
PQ52986

APAR is sysrouted TO one or more of the following:

Modules/Macros
JDBC          

Fix information
Fixed component name WEBSPHERE AE AI
Fixed component ID 5630A2200

Applicable component levels
R400 PSY    UP


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > General
Operating system(s):
Software version: 400
Software edition:
Reference #: PQ60430
IBM Group: Software Group
Modified date: Apr 23, 2002