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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.