PK85312: Warning WLTC0032W when using EGL/JSF: resources were rolled back during the cleanup of a LocalTransactionContainment.

Rational Business Developer Fix Pack 4 (7.1.0.4) for 7.1

APAR status

• Closed as program error.

Error description

• Environment:
  
   - Product name (Build ID or version/patch level): IBM Rational
  Business Developer v7.1.0.3
  Reproducible Y/N: Y
  
  Description of problem:
  
  When an EGL JSF page is accessing a JDBC datasource during its c
  onstruction, rollback appears on the Websphere log:
  
  [4/7/09 16:37:53:512 CEST] 00000034 LocalTranCoor W   WLTC0033W:
   Resource jdbc/AMTEAM rolled back in cleanup of LocalTransaction
  Containment.
  [4/7/09 16:37:53:575 CEST] 00000034 LocalTranCoor W   WLTC0032W:
   One or more local transaction resources were rolled back during
   the cleanup of a LocalTransactionContainment.
  

Local fix

Problem summary

• when sqlCommitControl is set to default or NOAUTOCOMMIT, it
  will set $con.isAutoCommit to false, in this case, you need
  to write "$con.commit()" after the sql executed.
  

Problem conclusion

• when sqlCommitControl is set to default or NOAUTOCOMMIT, it
  will set $con.isAutoCommit to false, in this case, you need
  to write "$con.commit()" after the sql executed.
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  RATL BUS DEV

• Fixed component ID

  5724S5000

Applicable component levels

• R700 PSN

     UP