PQ52986: CMP ENTITY BEANS ACCESSED VIA STATELESS SESSION BEAN BLOCKED

A fix is available
3.5.4-3.5.7, 4.0.2-4.0.7: Component cumulative Connection Manager fix

APAR

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 numberPQ52986
Reported component nameWAS ADVANCED AI
Reported component ID5648C8400
Reported release350
StatusCLOSED PER
PENoPE
HIPERNoHIPER
Submitted date2001-10-02
Closed date2002-04-23
Last modified date2002-04-23

APAR is sysrouted FROM one or more of the following:

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


Modules/Macros
JDBC
APAR is sysrouted TO one or more of the following:Modules/Macros

Fix information
Fixed component nameWAS ADVANCED AI
Fixed component ID5648C8400

Applicable component levels
R350 PSYUP











Document Information

Product categories: Software, Application Servers, Distributed Application & Web Servers, WebSphere Application Server, General
Software version: 350
Reference #: PQ52986
IBM Group: Software Group
Modified date: 2002-04-23