cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Kienenberger <mkien...@gmail.com>
Subject java.sql.SQLException: Numeric Overflow on relationship fetch
Date Mon, 09 May 2011 22:49:53 GMT
I've got a Cayenne 1.1 application that has been running fine for years.
Today we hit a strange error, a Numeric Overflow on a relationship list
fetch.

I've looked through the tables involved (account, user_account_relationship)
and didn't find any large values.
I am still looking through other table values.  I guess maybe it's hitting
the problem on prefetching something else?

Anyone have any other ideas?



Caused by: org.objectstyle.cayenne.CayenneRuntimeException: [v.1.1-dev March
27 2008] Query exception.
    at
org.objectstyle.cayenne.access.util.SelectObserver.nextQueryException(SelectObserver.java:213)
    at
org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:364)
    at
org.objectstyle.cayenne.access.DataDomain.performQueries(DataDomain.java:654)
    at
org.objectstyle.cayenne.access.DataContext.performQueries(DataContext.java:1408)
    at
org.objectstyle.cayenne.access.Transaction.performQueries(Transaction.java:179)
    at
org.objectstyle.cayenne.access.DataContext.performQueries(DataContext.java:1366)
    at
org.objectstyle.cayenne.access.DataRowStore.getSnapshot(DataRowStore.java:310)
    at
org.objectstyle.cayenne.access.ObjectStore.getSnapshot(ObjectStore.java:737)
    at
org.objectstyle.cayenne.access.ObjectStore.resolveHollow(ObjectStore.java:977)
    at
org.objectstyle.cayenne.CayenneDataObject.resolveFault(CayenneDataObject.java:217)
    at
org.objectstyle.cayenne.CayenneDataObject.readProperty(CayenneDataObject.java:227)
    at
com.xyz.cayenne.ebpp.entity.generated._Account.getUserAccountRelationshipList(_Account.java:1782)
    at
com.xyz.struts.ebpp.business.batch.BillingTasks.checkForNewBills(BillingTasks.java:120)
    at
com.xyz.struts.ebpp.business.batch.BillingTasks.recoverCheckForNewBills(BillingTasks.java:104)
    at
com.xyz.struts.ebpp.business.batch.TaskProcessor.processBatchJob(TaskProcessor.java:99)
    at
com.xyz.struts.ebpp.business.batch.CronBasedTaskScheduler.checkScheduledEvents(CronBasedTaskScheduler.java:449)
    ... 2 more
Caused by: java.sql.SQLException: Numeric Overflow
    at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
    at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
    at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
    at
oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:6797)
    at
oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:106)
    at
oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:482)
    at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:585)
    at
org.objectstyle.cayenne.access.types.DefaultType.materializeObject(DefaultType.java:243)
    at
org.objectstyle.cayenne.access.DefaultResultIterator.readDataRow(DefaultResultIterator.java:250)
    at
org.objectstyle.cayenne.access.DefaultResultIterator.nextDataRow(DefaultResultIterator.java:194)
    at
org.objectstyle.cayenne.access.DefaultResultIterator.dataRows(DefaultResultIterator.java:224)
    at org.objectstyle.cayenne.access.DataNode.runSelect(DataNode.java:413)
    at
org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:350)
    ... 16 more

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message