IT43607: A JDBC CONNECTION TO DATABASE WILL FAIL TO RECONNECT WHEN POOLING IS SET AND THE CONNECTION IS LOST WITHIN A FLOW.

APAR status

• Closed as program error.

Error description

• When pooling is activated in a flow where multiple connections
  are required, if the connection is lost it fails to reconnect
  causing an abend. BIP4362E: Java node error:  . :
  JDBCType4SinglePhaseTrxnHandlerErrors.java
  
  This can occur when a commit is used in a Java compute node
  losing the connection.  A commit in the flow in not recommended
  and should be avoided if possible.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users of  App Connect Enterprise version 11 or version 12 using
  JDBC.
  
  
  Platforms affected:
  MultiPlatform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  When JDBC connection pooling is activated in a flow where
  multiple connections are required, if the connection is lost it
  fails to reconnect causing an error. BIP4362E: Java node error:
   . : JDBCType4SinglePhaseTrxnHandlerErrors.java
  
  This can occur when a commit is used in a Java compute node
  losing the connection.  A commit in the flow in not recommended
  and should be avoided if possible.
  

Problem conclusion

• The product now restores the connection allowing the flow to
  complete when pooling is set with a JDBC connection.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v11.0      11.0.0.22
  v12.0      12.0.10.0
  
  The latest available maintenance can be obtained from:
  http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
  
  If the maintenance level is not yet available,information on
  its planned availability can be found on:
  http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
  ---------------------------------------------------------------
  

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

  APP CONNECT ENT

• Fixed component ID

  5724J0550

Applicable component levels