10-18-07, 09:06 #1Registered User
- Join Date
- Oct 2007
Unanswered: CLI0111E Numeric value out of range - JAVA Prepared Statement problem
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
Database: DB2 7.0
10-18-07, 10:44 #2:-)
Provided Answers: 1Originally Posted by andrea.capellacci
- Join Date
- Jun 2003
- Toronto, Canada
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.