IC61014: "TOO MANY OR TOO FEW HOST VARIABLES GIVEN" EXCEPTION THROWN WHENDOING A BATCH UPDATE

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • When performing a batch update using a prepared statement within
    a JDBC application, the following exception is thrown:
    
    java.sql.BatchUpdateException: Too many or too few host
    variables given.
            at
    com.informix.jdbc.IfxPreparedStatement.executeBatch(IfxPreparedS
    tatement.java:3625)
    
    In an onstat -g sql, the session would show an error -254:
    
    -254    Too many or too few host variables given.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All JDBC users                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When you have a prepare statement with no place holder, JDBC *
    * throws an error.                                             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to JDBC 3.50.JC5 and above.                          *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in JDBC 3.50.JC5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC61014

  • Reported component name

    IBM IDS ENTRP E

  • Reported component ID

    5724L2304

  • Reported release

    B15

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-05-04

  • Closed date

    2010-01-11

  • Last modified date

    2010-01-11

  • 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

    IBM IDS ENTRP E

  • Fixed component ID

    5724L2304

Applicable component levels

  • RB15 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Servers

Software version:

B15

Reference #:

IC61014

Modified date:

2010-01-11

Translate my page

Machine Translation

Content navigation