PM77185: JCC4.14: IBM DATA SERVER DRIVER FOR JDBC AND SQLJ RELEASE 4.14 GENERAL SERVICE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• JCC4.14: IBM DATA SERVER DRIVER FOR JDBC AND SQLJ RELEASE 4.14
  GENERAL SERVICE
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Users of the IBM Data                    *
  *                 Server Driver for JDBC and SQLJ              *
  ****************************************************************
  * PROBLEM DESCRIPTION: IBM Data Sever Driver for JDBC and      *
  *                      SQLJ version 4.14.126 is provided by    *
  *                      this APAR ( JCCV414126 )                *
  *                                                              *
  *                      This APAR is applicable to IBM Data     *
  *                      Sever Driver for JDBC and SQLJ          *
  *                      for both DB2 z/OS V10 and DB2 z/OS V9   *
  *                      ( JCCZOSDB2V10, JCCZOSDB2V9 )           *
  *                                                              *
  *                      This APAR delivers a new release (4.14) *
  *                      of the IBM Data Server Driver for JDBC  *
  *                      and SQLJ providing an accumulation of   *
  *                      defect fixes and enhancements.          *
  *                                                              *
  *                      Individual items are documented in the  *
  *                      APAR summary section that follows.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  JCC sub-category keywords:
      JCCCOMMON, JCCT2ZOS, JCCT4, JCCT4XA, JCCSQLJ
  
  The following changes are delivered in this APAR:
  _______________________________________________________________
  All Connectivities: Driver returns an SQLCODE401 (-401) While
  updating a column defined in DB2 as SMALLINT using the
  setBoolean() API of the java.sql.PreparedStatement interface.
  This issue is fixed.(wsdbu01060873)
  _______________________________________________________________
  Type-4 XA Connectivity: In a workload balancing and XA
  transaction environment, an SQLCODE4228 (-4228) error might
  return to the application if auto failover has occurred during
  a local transaction. (wsdbu01060779)
  _______________________________________________________________
  Type-4 connectivity:A java.lang.ArrayIndexOutOfBoundsException:
  Array index out of range: 255, may be thrown by the driver
  when invoking a stored procedure that has array types as
  parameters and number of parameters are more than 83.
  The problem has been fixed. (wsdbu01061046)
  _______________________________________________________________
  Type-2 z/OS Connectivity: For an IMS MPP/BMP/IFP application
  executing in a Persistent JVM environment and calling a Java
  application which makes DB2 calls through the driver, this
  driver provides a new partial Reset interface to allow reuse of
  the JDBC Connection object which can boost performance. For
  more detailed information, please refer to IMS APAR PM80880.
  (wsdbu01061827)
  

Problem conclusion

• The items described in the APAR Problem
  Summary have been resolved as noted in
  the summary and included in this APAR.
  

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:

  PM84350 UK92325 UK92326

Modules/Macros

•    DSNAJJC1 DSNAJJC2 DSNAJ3CC DSNAJ3CE DSNAJ3CF
  DSNAJ3CM DSNAJ3C0 DSNAJ3C1 DSNAJ3C2 DSNAJ3C3 DSNAJ3C4 DSNAJ3C5
  DSNAJ3C6 DSNAJ3C7 DSNAJ3C9 DSNAJ6CC DSNAJ6CE DSNAJ6CF DSNAJ6CM
  DSNAJ6C0 DSNAJ6C1 DSNAJ6C2 DSNAJ6C3 DSNAJ6C4 DSNAJ6C5 DSNAJ6C6
  DSNAJ6C7 DSNAJ6C9
  

Fix information

• Fixed component name

  DB2 ODBC/JDBC/S

• Fixed component ID

  5740XYR02

Applicable component levels

• RA12 PSY UK92325

     UP13/03/09 P F303

• R912 PSY UK92326

     UP13/03/09 P F303

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.