hi,

we use Toplink (TopLink - 4.6.0 (Build 417) with a DB2 Database 7.2. i
know really old versions, but we could change to e newer one ;-)

Sometimes we got some problems with update or insert statements --
numeric value out of range. The SQL statements should be right. We
took the statements and we tried to execute it manually. It works...
in our programm sometimes it crashed and we get a Database Exception:
CLI0111E Numeric value out of range

i will attach the stacktrace, perhaps somebody cna help us....

EXCEPTION [TOPLINK-4002] (TopLink - 4.6.0 (Build 417)):
com.webgain.integrator.exceptions.DatabaseExceptio n
EXCEPTION DESCRIPTION: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI
Driver] CLI0111E Numeric value out of range. SQLSTATE=22003
INTERNAL EXCEPTION: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver]
CLI0111E Numeric value out of range. SQLSTATE=22003
ERROR CODE: -99999
at
com.webgain.integrator.exceptions.DatabaseExceptio n.sqlException(Unknown
Source)
at
com.webgain.integrator.internal.databaseaccess.Dat abaseAccessor.executeDirectNoSelect(Unknown
Source)
at
com.webgain.integrator.internal.databaseaccess.Dat abaseAccessor.executeNoSelect(Unknown
Source)
at
com.webgain.integrator.internal.databaseaccess.Dat abaseAccessor.executeCall(Unknown
Source)
at
com.webgain.integrator.publicinterface.UnitOfWork. executeCall(Unknown
Source)
at
com.webgain.integrator.internal.queryframework.Cal lQueryMechanism.executeCall(Unknown
Source)
at
com.webgain.integrator.internal.queryframework.Cal lQueryMechanism.executeCall(Unknown
Source)
at
com.webgain.integrator.internal.queryframework.Cal lQueryMechanism.insertObject(Unknown
Source)
at
com.webgain.integrator.internal.queryframework.Sta tementQueryMechanism.insertObject(Unknown
Source)
at
com.webgain.integrator.internal.queryframework.Dat abaseQueryMechanism.insertObjectForWrite(Unknown
Source)
at
com.webgain.integrator.queryframework.InsertObject Query.executeCommit(Unknown
Source)
at
com.webgain.integrator.internal.queryframework.Dat abaseQueryMechanism.performUserDefinedWrite(Unknow n
Source)
at
com.webgain.integrator.internal.queryframework.Dat abaseQueryMechanism.performUserDefinedInsert(Unkno wn
Source)
at
com.webgain.integrator.internal.queryframework.Dat abaseQueryMechanism.insertObjectForWrite(Unknown
Source)
at
com.webgain.integrator.queryframework.WriteObjectQ uery.executeCommit(Unknown
Source)
at
com.webgain.integrator.internal.queryframework.Dat abaseQueryMechanism.executeWrite(Unknown
Source)
at
com.webgain.integrator.queryframework.WriteObjectQ uery.execute(Unknown
Source)
at
com.webgain.integrator.queryframework.DatabaseQuer y.execute(Unknown
Source)
at
com.webgain.integrator.publicinterface.Session.int ernalExecuteQuery(Unknown
Source)
at
com.webgain.integrator.publicinterface.UnitOfWork. internalExecuteQuery(Unknown
Source)
at
com.webgain.integrator.publicinterface.Session.exe cuteQuery(Unknown
Source)
at
com.webgain.integrator.publicinterface.Session.exe cuteQuery(Unknown
Source)
at
com.webgain.integrator.internal.sessions.CommitMan ager.commitAllObjects(Unknown
Source)
at
com.webgain.integrator.publicinterface.Session.wri teAllObjects(Unknown
Source)
at
com.webgain.integrator.publicinterface.UnitOfWork. commitToDatabase(Unknown
Source)
at
com.webgain.integrator.publicinterface.UnitOfWork. commitRootUnitOfWork(Unknown
Source)
at com.webgain.integrator.publicinterface.UnitOfWork. commit(Unknown
Source)