IBM Support

JR56769: DOC - INFORMATION MISSING ABOUT DOCUMENT DATA TYPE LIMITATIONS WITH THE SQL CONNECTOR

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In IBM Process Designer, the SQL Connector panel displays the
    following information:
    
    Standard JDBC Types: ARRAY, BIGINT, BINARY, BIT, BLOB, BOOLEAN,
    CHAR, CLOB, DATALINK, DATE, DECIMAL, DISTINCT, DOUBLE, FLOAT,
    INTEGER, AVA_OBJECT,         LONGVARBINARY....
    
    However, even though all these types are technically available,
    IBM Business Process Manager (BPM) does not transform complex
    IBM BPM types (such as TWObjects) to standard JDBC types that
    the database can process. Therefore, the SQL Connector code can
    handle only simple types.
    
    The limitation information is missing from the documentation.
    

Local fix

  • Use the Java integration feature to invoke custom Java code
    using JDBC java interfaces to call stored procedures.
    

Problem summary

  • No additional information is available.
    
    PRODUCTS AFFECTED
    IBM Business Process Manager (BPM) Advanced
    IBM BPM Standard
    IBM BPM Express
    

Problem conclusion

  • Information about this limitation will be added to the
    SQLParameter variable types description in an upcoming IBM BPM
    V8.5.7 cumulative fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR56769

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    856

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-10-04

  • Closed date

    2016-10-19

  • Last modified date

    2016-10-19

  • 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

    BPM STANDARD

  • Fixed component ID

    5725C9500

Applicable component levels

  • R857 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"856","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
19 October 2016