Arithmetic overflow
Aaron Galea <[email protected]>
| Newsgroups | gmane.comp.java.enhydra.shark |
|---|---|
| Message-ID | <[email protected]> |
Hi
After managing to make Shark working with Sybase now I am facing
problems from the SharkAdmin gui. This time it seems some database
writing. Whenever I try to load a package I am getting the following error:
2005-07-15 12:49:10,104: PackageAdmin -> Trying to open Package file
Business_Example.xpdl
2005-07-15 12:49:11,353: SharkUtilities -> synchronizing XPDL cache
2005-07-15 12:49:12,451: DODSRepositoryPersistenceManager -> Storing
XPDL Business_Example, BLOB1 size=43198, BLOB2 size=117126
com.sybase.jdbc2.jdbc.SybSQLException: Arithmetic overflow during
implicit conversion of NUMERIC value '1118766356000' to a INT field .
at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2636)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:1996)
at
com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at
com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:204)
at
com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:187)
at
com.sybase.jdbc2.jdbc.SybStatement.updateLoop(SybStatement.java:1615)
at
com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1598)
at
com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:89)
at
com.lutris.appserver.server.sql.standard.StandardDBConnection.executeUpdate(StandardDBConnection.java:467)
at
com.lutris.appserver.server.sql.CoreDO.executeInsert(CoreDO.java:345)
at
com.lutris.dods.builder.generator.dataobject.GenericDO.executeInsert(GenericDO.java:352)
at
org.enhydra.shark.repositorypersistence.data.XPDLDO.executeInsert(XPDLDO.java:2269)
at
com.lutris.appserver.server.sql.standard.StandardDBTransaction.write(StandardDBTransaction.java:654)
at
org.enhydra.shark.repositorypersistence.DODSRepositoryPersistenceManager.uploadXPDL(DODSRepositoryPersistenceManager.java:93)
at
org.enhydra.shark.PackageAdmin.copyPackagesToInternalPackagesRepository(PackageAdmin.java:860)
at org.enhydra.shark.PackageAdmin.openPackage(PackageAdmin.java:746)
I have looked in the source code and the table that is causing problems
is the XPDLS. The create table statement used to create this table is
the following:
Create table XPDLS
(
XPDLId VARCHAR (90) NOT NULL ,
XPDLVersion VARCHAR (20) NOT NULL ,
XPDLClassVersion INTEGER NOT NULL ,
XPDLUploadTime DATETIME NOT NULL ,
oid DECIMAL (19,0) NOT NULL ,
version INTEGER NOT NULL
);
The only integer fields that could be causing this arithmetic overflow
are XPDLClassVersion and version but I can't see anything wrong. Did
anyone ever met this error before?
Regards
Aaron
---
[This E-mail was scanned for spam and viruses by NextGen.net.]
message-footer.txt
(text/plain, 271 B)
-- You receive this message as a subscriber of the [email protected] mailing list. To unsubscribe: mailto:[email protected] For general help: mailto:[email protected]?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws