IBM Support

PM08945: IF PREPARED STATEMENT IS CREATED BUT NO QUERIES ARE RUN, CLEANUP OF IT MAY RESULT IN SQLEXCEPTION: NO ACTIVE RESULT AFTER PK85473

Fixes are available

6.1.0.33: Java SDK 1.5 SR12 FP1 Cumulative Fix for WebSphere
7.0.0.13: WebSphere Application Server V7.0 Fix Pack 13 for AIX
7.0.0.13: WebSphere Application Server V7.0 Fix Pack 13 for HP-UX
7.0.0.13: WebSphere Application Server V7.0 Fix Pack 13 for IBM i
7.0.0.13: WebSphere Application Server V7.0 Fix Pack 13 for Linux
7.0.0.13: WebSphere Application Server V7.0 Fix Pack 13 for Solaris
7.0.0.13: WebSphere Application Server V7.0 Fix Pack 13 for Windows
7.0.0.13: Java SDK 1.6 SR8FP1 Cumulative Fix for WebSphere Application Server
6.1.0.35: Java SDK 1.5 SR12 FP2 Cumulative Fix for WebSphere
7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for AIX
7.0.0.15: Java SDK 1.6 SR9 Cumulative Fix for WebSphere Application Server
7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for HP-UX
7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for IBM i
7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for Linux
7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for Solaris
7.0.0.15: WebSphere Application Server V7.0 Fix Pack 15 for Windows
6.1.0.37: Java SDK 1.5 SR12 FP3 Cumulative Fix for WebSphere
7.0.0.17: WebSphere Application Server V7.0 Fix Pack 17
7.0.0.17: Java SDK 1.6 SR9 FP1 Cumulative Fix for WebSphere Application Server
7.0.0.19: WebSphere Application Server V7.0 Fix Pack 19
7.0.0.21: WebSphere Application Server V7.0 Fix Pack 21
7.0.0.23: WebSphere Application Server V7.0 Fix Pack 23
7.0.0.25: WebSphere Application Server V7.0 Fix Pack 25
7.0.0.27: WebSphere Application Server V7.0 Fix Pack 27
7.0.0.29: WebSphere Application Server V7.0 Fix Pack 29
6.1.0.47: WebSphere Application Server V6.1 Fix Pack 47
7.0.0.31: WebSphere Application Server V7.0 Fix Pack 31
7.0.0.27: Java SDK 1.6 SR13 FP2 Cumulative Fix for WebSphere Application Server
7.0.0.33: WebSphere Application Server V7.0 Fix Pack 33
7.0.0.35: WebSphere Application Server V7.0 Fix Pack 35
7.0.0.37: WebSphere Application Server V7.0 Fix Pack 37
7.0.0.39: WebSphere Application Server V7.0 Fix Pack 39
7.0.0.41: WebSphere Application Server V7.0 Fix Pack 41
7.0.0.43: WebSphere Application Server V7.0 Fix Pack 43
7.0.0.45: WebSphere Application Server V7.0 Fix Pack 45
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
7.0.0.19: Java SDK 1.6 SR9 FP2 Cumulative Fix for WebSphere Application Server
7.0.0.21: Java SDK 1.6 SR9 FP2 Cumulative Fix for WebSphere
7.0.0.23: Java SDK 1.6 SR10 FP1 Cumulative Fix for WebSphere
7.0.0.25: Java SDK 1.6 SR11 Cumulative Fix for WebSphere Application Server
7.0.0.27: Java SDK 1.6 SR12 Cumulative Fix for WebSphere Application Server
7.0.0.29: Java SDK 1.6 SR13 FP2 Cumulative Fix for WebSphere Application Server
7.0.0.45: Java SDK 1.6 SR16 FP60 Cumulative Fix for WebSphere Application Server
7.0.0.31: Java SDK 1.6 SR15 Cumulative Fix for WebSphere Application Server
7.0.0.35: Java SDK 1.6 SR16 FP1 Cumulative Fix for WebSphere Application Server
7.0.0.37: Java SDK 1.6 SR16 FP3 Cumulative Fix for WebSphere Application Server
7.0.0.39: Java SDK 1.6 SR16 FP7 Cumulative Fix for WebSphere Application Server
7.0.0.41: Java SDK 1.6 SR16 FP20 Cumulative Fix for WebSphere Application Server
7.0.0.43: Java SDK 1.6 SR16 FP41 Cumulative Fix for WebSphere Application Server

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • This problem is observed only with specific database drivers;
    this problem can be produced using Informix or Sybase drivers
    with WebSphere Application Server.  The problem happens when
    cleaning up a prepared statement for which no queries were
    executed.  The SQLException that is thrown is this:
    .
    [1/29/10 15:49:33:050 MST] 00000013 WSJdbcUtil    3
    mapException
    
    SQL STATE:  IX000
    ERROR CODE: -79733
    java.sql.SQLException: No active result
     at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.
    java:373)
     at com.informix.jdbc.IfxStatement.getUpdateCount(IfxStatement.
    java:1050)
     at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.
    closeWrapper(WSJdbcPreparedStatement.java:445)
     at com.ibm.ws.rsadapter.jdbc.WSJdbcObject.close(WSJdbcObject.
    java:185)
     at com.ibm.ws.rsadapter.jdbc.WSJdbcObject.close(WSJdbcObject.
    java:144)
    .
       This problem may be observed using Sybase or Informix for the
    SIB persistence database.  In that case, the following error
    messages would be logged.
    .
    [1/28/10 16:52:25:456 MST] 00000013 SibMessage    E
    [verifybus:eWebtestNode01.server1-verifybus] CWSIS0002E: The
    messaging engine encountered an exception while starting.
    Exception:
    com.ibm.ws.sib.msgstore.PersistenceException: CWSIS1501E: The
    data source has produced an unexpected exception:
    java.sql.SQLException: No active result
    .
    [1/28/10 16:52:25:459 MST] 00000013 MessageStoreI 1
    [verifybus:eWebtestNode01.server1-verifybus/7bc87bc8] Exception:
    com.ibm.ws.sib.msgstore.PersistenceException: CWSIS1501E: The
    data source has produced an unexpected exception:
    java.sql.SQLException: No active result
     at com.ibm.ws.sib.msgstore.persistence.impl.
    PersistentMessageStoreI mpl.star t(PersistentMessageStoreImpl.
    java:201)
    
    .
    WebSphere AppServer added cleanup code in the APARs PK70930
    (6.0.2.35, 6.1.0.23, and 7.0.0.5) and PK85473 (6.1.0.29; it is
    not yet available in 6.0 or 7.0 fix pack).
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application Server
    ****************************************************************
    * PROBLEM DESCRIPTION: If a prepared statement is created but  *
    *                      no queries are run, the cleanup of it   *
    *                      may result in SQLException: No active   *
    *                      result                                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    WebSphere Application Server customers using an Informix/Sybase
    database would notice SQLException in their application when
    they attempt to close a prepared statement for which no
    queries were run.
    
    Informix -- java.sql.SQLException: No active result
    Sybase -- java.sql.SQLException: JZ0PA: The query has been
    canceled and the response discarded.  The cancel was probably
    issued by another statement on the connection.
    
    Informix & Sybase interpreted the requirements of the JavaDoc
    for Statement.getUpdateCount differently than we did in
    WebSphere Application Server. Instead of returning -1, they
    throw SQLException when no queries are run before we invoke
    getUpdateCount().
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM08945

  • Reported component name

    WEBSPHERE APP S

  • Reported component ID

    5724J0800

  • Reported release

    61A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-03-03

  • Closed date

    2010-05-04

  • Last modified date

    2010-05-04

  • 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

    WEBSPHERE APP S

  • Fixed component ID

    5724J0800

Applicable component levels

  • R61A PSY

       UP

  • R61H PSY

       UP

  • R61I PSY

       UP

  • R61P PSY

       UP

  • R61S PSY

       UP

  • R61W PSY

       UP

  • R61Z PSY

       UP

  • R700 PSY

       UP



Document information

More support for: WebSphere Application Server
General

Software version: 6.1

Reference #: PM08945

Modified date: 04 May 2010