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

6.1.0.29: Java SDK 1.5 SR11 Cumulative Fix for WebSphere Application Server
6.1.0.31: Java SDK 1.5 SR11 FP1 Cumulative Fix for WebSphere Application Server
6.1.0.33: Java SDK 1.5 SR12 FP1 Cumulative Fix for WebSphere
6.1.0.35: Java SDK 1.5 SR12 FP2 Cumulative Fix for WebSphere
6.1.0.37: Java SDK 1.5 SR12 FP3 Cumulative Fix for WebSphere
6.1.0.47: WebSphere Application Server V6.1 Fix Pack 47
6.1.0.39: Java SDK 1.5 SR12 FP4 Cumulative Fix for WebSphere Application Server
6.1.0.41: Java SDK 1.5 SR12 FP5 Cumulative Fix for WebSphere Application Server
6.1.0.43: Java SDK 1.5 SR13 Cumulative Fix for WebSphere Application Server
6.1.0.45: Java SDK 1.5 SR14 Cumulative Fix for WebSphere Application Server
6.1.0.47: Java SDK 1.5 SR16 Cumulative Fix for WebSphere Application Server

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

• Version 3.7 build 65 of the WebSphere Connect JDBC driver
  fixes the problem.
  
  The fix for this APAR is currently targeted for inclusion in
  fix packs 6.1.0.29 and 6.0.2.39  Please refer to the
  Recommended Updates page for delivery information:
  http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
  

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

  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