Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    2

    Unanswered: CLI0111E Numeric value out of range - JAVA Prepared Statement problem

    Hi all,

    the following error occurs when I try to execute an update using Prepared Statement with more then 142 parameters.

    [IBM][CLI Driver] CLI0111E Numeric value out of range. SQLSTATE=22003

    The same update worked fine with 141 parameters but when I modified it inserting a new colunm it didn't work anymore.
    It seems the number of parameters is limited to 142.

    Is there anyone who can confirm it or who knows possible causes and solutions?

    Thanks in advance

    Here are some details of the environment in use

    Dev. environment: Visual Age 4.0
    Application Server: IBM WebSphere Test Environment 3.5.3
    JDK: 1.2.2
    Database: DB2 7.0

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by andrea.capellacci
    Dev. environment: Visual Age 4.0
    Application Server: IBM WebSphere Test Environment 3.5.3
    JDK: 1.2.2
    Database: DB2 7.0
    What year are you living in, 1999?

    Seriously though, if you are interested in meaningful answers you may want to begin with posting the exact SQL statement you are trying to execute and the definition of the table you are updating.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •