IBM Support

IZ39268: DOCUMENTATION OF CHANGES IN IBM DATA SERVER DRIVER FOR JDBC AND SQLJ VERSION 3.8.47 FOR DB2 LUW V9 FIXPACK 7

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ============================================================
    Documentation of changes in IBM Data Server Driver for JDBC
    and SQLJ version 3.8.47 for DB2 LUW V9 Fixpack 7.
    The previous version was 3.8.35 for DB2 LUW V9 Fixpack 6.
    ____________________________________________________________
    All Connectivity Types: During dynamic execution of a SQLJ
    application the line feed, carriage return, and space
    characters were being incorrectly removed from the SQL
    statement.  This may cause problems if any embedded SQL
    string contains formatting that needs to be preserved.
    (109182)
    ____________________________________________________________
    All Connectivity Types: Previously, JRE 1.6 was not
    included in the list of compatible JREs.  Now, the JCC
    driver will report JRE 1.6 as one of the compatible JREs.
    (117664)
    ____________________________________________________________
    Type-4 Connectivity:
    When the DB2 server is LUW and the authentication type
    is set to SERVER, connecting to the server using
    securityMechanism other than ENCRYPTED_PASSWORD_SECURITY
    or ENCRYPTED_USER_AND_PASSWORD_SECURITY may hang.
    (117540)
    ____________________________________________________________
    All Connectivity Types: If QueryTimeOut is set and
    an exception with -4499 happens, Statement.cancel
    may cause a NullPointerException. (118002)
    ____________________________________________________________
    All Connectivity Types:
    When calling Java Stored procedure against zOS, an
    exception with error code -4302 is issued. (117671)
    ____________________________________________________________
    Type-4: SQLException with SQLCODE4499 (-4499) occurs when
    the DataSource property sslConnection is true, Statement
    queryTimeout is reached, and Statement cancel is
    attempted. (117910)
    ____________________________________________________________
    Type-4 XA Connectivity: In an application server
    environment, a deadlock might occur where
    multiple XAResources are accessed by many different
    threads. The problem was encountered using Weblogic 9.2 and
    the hang occurred at the time of creating a new  XA
    connection. (114772)
    ____________________________________________________________
    All Connectivity Types: JCC driver fails to cross convert
    numeric types with leading spaces for input string data.
    For example, the following statement
    pstmt.setString(4, " 00006.35");
    that contains a data string with a leading space will
    result in an error (-99999) (SQLCODE99999) "Invalid
    data conversion".
    (117915).
    ____________________________________________________________
    Type-4 XA Connectivity: A deadlock occurred when two
    different XAResources in two threads were calling XA
    start() concurrently. (114817)
    ____________________________________________________________
    Type-4 XA: A NullPointerException was thrown
    when securityMechanism property was set to a value other
    than DB2BaseDataSource.CLEAR_TEXT_PASSWORD_SECURITY (3) and
    enableSysplexWLB property was set to false on a
    DB2XADataSource. (118341)
    ____________________________________________________________
    Java stored procedure: Some describe information may be
    missing when invoking a java stored procedure from the
    command line.  The problem has been corrected.
    (104662)
    ____________________________________________________________
    All Connectivity Types: Driver code has been enhanced such
    that driver will automatically retry execution upon
    receiving SQLCODE30002 (-30002) from a
    java.sql.PreparedStatement. (116040)
    ____________________________________________________________
    Type-4 or Type-2 Connectivity: When running with
    deferPrepares=true, the following scenario will result
    in a NullPointerException:
    1) A PreparedStatement has been created, but not yet
    executed.
    2) PreparedStatement.setBinaryStream() is called against a
    BINARY, VARBINARY or VARCHAR FOR BIT DATA parameter.
    3) After step 2, PreparedStatement.setObject(int, object) or
    PreparedStatement.setObject(String, object) is called.
    (115284)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of the IBM Data Server Driver for JDBC and SQLJ        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to V9.1 Fixpack 7                                    *
    ****************************************************************
    

Problem conclusion

  • Problems fixed in DB2 LUW V9.1 Fixpack 7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ39268

  • Reported component name

    DB2 UDB ESE AIX

  • Reported component ID

    5765F4100

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-12-03

  • Closed date

    2009-04-06

  • Last modified date

    2009-04-06

  • 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

    DB2 UDB ESE AIX

  • Fixed component ID

    5765F4100

Applicable component levels

  • R910 PSN

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910"}]

Document Information

Modified date:
04 October 2021