Re: Arithmetic overflow

Hello Aaron

XPDLClassVersion is actually a long in Java, so defining it as INTEGER 
is likely to be wrong.

Apropos, how did you generated/fixed sql scripts for Sybase?

regards
-- 
Vlada

you wrote:
> 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

--
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