In this post, you’ll learn about the DB2 error -40-General error: S1000 General error java.lang.NumberFormatException: %d in statement %s and the reason why you are receiving the error message and how to fix it
How does this Error Message Looks like
-40 – General error: S1000 General error java.lang.NumberFormatException: %d in statement %s
Reason for the Error & Solution
A numeric range error occured. Ensure that the capacity of the numeric column is sufficient to store the specified value the persistent object is attempting to store. Note that some versions of HSQL have a bug that prevents Long.MIN_VALUE from being stored.