RE: [OS-JIRA] Closed: (CAY-234) Oracle BLOB error

From: Cris Daniluk (cris.danilu..laraview.com)
Date: Tue Nov 23 2004 - 09:42:16 EST

  • Next message: Marek Wawrzyczny: "Evaluating Cayenne for Java Client application"

    Just wanted to thank you for putting the incremental release out. Beats
    convincing everyone its okay to use latest CVS :)

    I tested out the BLOB fix with some sizable CLOBs and BLOBs and everything
    worked fantastic.

    Thanks,

    Cris

    > -----Original Message-----
    > From: jir..bjectstyle.org [mailto:jira@objectstyle.org]
    > Sent: Saturday, November 20, 2004 2:04 PM
    > To: cris.danilu..laraview.com
    > Subject: [OS-JIRA] Closed: (CAY-234) Oracle BLOB error
    >
    > Message:
    >
    > The following issue has been closed.
    >
    > ---------------------------------------------------------------------
    > View the issue:
    >
    > http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-234
    >
    >
    > Here is an overview of the issue:
    > ---------------------------------------------------------------------
    > Key: CAY-234
    > Summary: Oracle BLOB error
    > Type: Bug
    >
    > Status: Closed
    > Priority: Major
    > Resolution: FIXED
    >
    > Project: Cayenne
    > Components:
    > Cayenne Core Library
    > Fix Fors:
    > 1.1
    > Versions:
    > 1.1
    >
    > Assignee: Andrus Adamchik
    > Reporter: Cris Daniluk
    >
    > Created: Wed, 10 Nov 2004 10:05 PM
    > Updated: Sat, 20 Nov 2004 2:02 PM
    > Environment: Windows 2000 w/Tomcat 5.0.28 RedHat Linux AS
    > w/Tomcat 5.0.27 Cayenne 1.1RC2
    >
    > Description:
    > When committing a new ObjEntity containing a blob in excess
    > of 4000 bytes, the following exception is thrown:
    >
    > org.objectstyle.cayenne.CayenneRuntimeException: [v.1.1RC1
    > October 3 2004] Commit Exception
    > at
    > org.objectstyle.cayenne.access.DataContext.commitChanges(DataC
    > ontext.java:12
    > 40)
    > at
    > org.objectstyle.cayenne.access.DataContext.commitChanges(DataC
    > ontext.java:12
    > 01)
    > [snip]
    > Caused by: java.sql.SQLException: Data size bigger than max
    > size for this
    > type: 165888
    > at
    > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    > at
    > oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
    > at oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:95)
    > at
    > oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetI
    > mpl.java:2414)
    > at
    > oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePrepa
    > redStatement.j
    > ava:1134)
    > at
    > oracle.jdbc.driver.OraclePreparedStatement.setBytes(OraclePrep
    > aredStatement.
    > java:2170)
    > at
    > org.objectstyle.cayenne.access.types.ByteArrayType.setJdbcObje
    > ct(ByteArrayTy
    > pe.java:212)
    > at
    > org.objectstyle.cayenne.dba.JdbcAdapter.bindParameter(JdbcAdap
    > ter.java:544)
    > at
    > org.objectstyle.cayenne.access.trans.BatchQueryBuilder.bindPar
    > ameters(BatchQ
    > ueryBuilder.java:143)
    > at
    > org.objectstyle.cayenne.access.DataNode.runBatchUpdateAsBatch(
    > DataNode.java:
    > 534)
    > at
    > org.objectstyle.cayenne.dba.oracle.OracleDataNode.runBatchUpda
    > teAsBatch(Orac
    > leDataNode.java:355)
    > at
    > org.objectstyle.cayenne.access.DataNode.runBatchUpdate(DataNod
    > e.java:498)
    > at
    > org.objectstyle.cayenne.access.DataNode.performQueries(DataNod
    > e.java:353)
    > at
    > org.objectstyle.cayenne.access.ContextCommit.commit(ContextCom
    > mit.java:192)
    > at
    > org.objectstyle.cayenne.access.DataContext.commitChanges(DataC
    > ontext.java:12
    > 31)
    > ... 40 more
    >
    >
    >
    > ---------------------------------------------------------------------
    > JIRA INFORMATION:
    > This message is automatically generated by JIRA.
    >
    > If you think it was sent incorrectly contact one of the
    > administrators:
    > http://objectstyle.org/jira/secure/Administrators.jspa
    >
    > If you want more information on JIRA, or have a bug to report see:
    > http://www.atlassian.com/software/jira
    >
    >



    This archive was generated by hypermail 2.0.0 : Tue Nov 23 2004 - 09:42:16 EST