IBM Support

PK96607: WHEN USING THE WEBSPHERE CONNECT JDBC DRIVER, RESULTSET.GETXXX OPERATIONS FAISL WITH "INDEX OUT OF RANGE".

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The WebSphere Connect JDBC driver (found in WebSphere
    Application Server V6.1 and V6.0.2) has an error where "index
    out of range" exception is incorrectly reported on various
    ResultSet.getXXX methods after having previously invoked
    getMoreResults on the PreparedStatement.  Here is an example
    of the exception stack,
    
    java.sql.SQLException: [IBM][SQLServer JDBC
    Driver]Column index 1 is out of range.
    at com.ibm.websphere.jdbc.base.BaseExceptions.
    createException(Unknown Source)
    at com.ibm.websphere.jdbc.base.BaseExceptions.
    getException(Unknown Source)
    at com.ibm.websphere.jdbc.base.BaseResultSet.
    throwBadOrdinal(Unknown Source)
    at com.ibm.websphere.jdbc.base.BaseResultSet.
    getInt(Unknown Source)
    at com.ibm.websphere.jdbcx.base.BaseResultSetWrapper.
    getInt(Unknown Source)
    
    The APAR fix corrects the error such that getMoreResults
    does not lead to the "index out of range" error.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server V6.0.2 and V6.1 who use the          *
    *                  WebSphere Connect JDBC driver to connect    *
    *                  to the Microsoft SQL Server database.       *
    ****************************************************************
    * PROBLEM DESCRIPTION: The WebSphere Connect JDBC driver has   *
    *                      an error where "index out of range"     *
    *                      exception is incorrectly reported on    *
    *                      various ResultSet.getXXX methods        *
    *                      after having previously invoked         *
    *                      getMoreResults on the                   *
    *                      PreparedStatement.                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
     An exception such as the following occurs when invoking a
    ResultSet.getXXX method after getMoreResults was invoked on
    the PreparedStatement,
    java.sql.SQLException: [IBM][SQLServer JDBCDriver]Column index
    1 is out of range.
       at
    com.ibm.websphere.jdbc.base.BaseExceptions.createException(Unkno
    wn Source)
       at
    com.ibm.websphere.jdbc.base.BaseExceptions.getException(Unknown
    Source)
       at
    com.ibm.websphere.jdbc.base.BaseResultSet.throwBadOrdinal(Unknow
    n Source)
       at com.ibm.websphere.jdbc.base.BaseResultSet.getInt(Unknown
    Source)
       at
    com.ibm.websphere.jdbcx.base.BaseResultSetWrapper.getInt(Unknown
     Source)
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PK96607

  • Reported component name

    WEBS APP SERV N

  • Reported component ID

    5724H8800

  • Reported release

    61A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-09-18

  • Closed date

    2009-10-21

  • Last modified date

    2009-10-21

  • 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

    WEBS APP SERV N

  • Fixed component ID

    5724H8800

Applicable component levels

  • R60A PSY

       UP

  • R60H PSY

       UP

  • R60I PSY

       UP

  • R60S PSY

       UP

  • R60W PSY

       UP

  • R61A PSY

       UP

  • R61H PSY

       UP

  • R61I PSY

       UP

  • R61S PSY

       UP

  • R61W PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.1","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
29 December 2021