IBM Support

PM60942: SQLSYNTAXERROREXCEPTION IS THROWN WHEN ENABLESEAMLESSFAILOVER PR OPERTY SET TO 1 FOR THE DATASOURCE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When enableSeamlessFailover property is set to 1,
    "SqlSyntaxErrorException : The InputStream object does not
    contain 12434 characters. ERRORCODE=-4461, SQLSTATE=42815" is
    thrown by the setBinaryStream method during the insert
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:  All users of IBM WebSphere Application      *
    *                  Server V8.0 and V8.5                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: When enableSeamlessFailover property    *
    *                      is set to 1, SqlSyntaxErrorException    *
    *                      is thrown by the setBinaryStream        *
    *                      method                                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When the enableSeamlessfailover option is set, the DB2 jdbc
    driver calls the DataSliceInputStream.read() without any
    parameters. This reads byte by byte and we just cast
    the byte to int. When the byte value becomes greater than 127,
    it starts returning negative values and for 255 it returns
    -1. Seeing -1  the DB2 jdbc driver assumes that is the end of
    the stream and so the setBinaryStream fails with a mismatch in
    data and length.
    

Problem conclusion

  • The problem is fixed by treating the value as unsigned by
    masking the sign bit using 0xff.
    The fix for this APAR is currently targeted for inclusion in
    fix packs 8.0.0.4 and 8.5.0.1.  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 number

    PM60942

  • Reported component name

    WEBS APP SERV N

  • Reported component ID

    5724H8800

  • Reported release

    800

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-03-22

  • Closed date

    2012-07-13

  • Last modified date

    2012-07-13

  • 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

  • R800 PSY

       UP

  • R850 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":"8.0","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
28 October 2021