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

From: jir..bjectstyle.org
Date: Wed Nov 10 2004 - 22:05:49 EST

  • Next message: jir..bjectstyle.org: "[OS-JIRA] Created: (CAY-235) support for Ingres database"

    Message:

      A new issue has been created in JIRA.

    ---------------------------------------------------------------------
    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: Assigned
       Priority: Major

        Project: Cayenne
     Components:
                 Cayenne Core Library
       Versions:
                 1.1

       Assignee: Andrus Adamchik
       Reporter: Cris Daniluk

        Created: Wed, 10 Nov 2004 10:05 PM
        Updated: Wed, 10 Nov 2004 10:05 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(DataContext.java:12
    40)
            at
    org.objectstyle.cayenne.access.DataContext.commitChanges(DataContext.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(DBDataSetImpl.java:2414)
            at
    oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.j
    ava:1134)
            at
    oracle.jdbc.driver.OraclePreparedStatement.setBytes(OraclePreparedStatement.
    java:2170)
            at
    org.objectstyle.cayenne.access.types.ByteArrayType.setJdbcObject(ByteArrayTy
    pe.java:212)
            at
    org.objectstyle.cayenne.dba.JdbcAdapter.bindParameter(JdbcAdapter.java:544)
            at
    org.objectstyle.cayenne.access.trans.BatchQueryBuilder.bindParameters(BatchQ
    ueryBuilder.java:143)
            at
    org.objectstyle.cayenne.access.DataNode.runBatchUpdateAsBatch(DataNode.java:
    534)
            at
    org.objectstyle.cayenne.dba.oracle.OracleDataNode.runBatchUpdateAsBatch(Orac
    leDataNode.java:355)
            at
    org.objectstyle.cayenne.access.DataNode.runBatchUpdate(DataNode.java:498)
            at
    org.objectstyle.cayenne.access.DataNode.performQueries(DataNode.java:353)
            at
    org.objectstyle.cayenne.access.ContextCommit.commit(ContextCommit.java:192)
            at
    org.objectstyle.cayenne.access.DataContext.commitChanges(DataContext.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 : Wed Nov 10 2004 - 22:05:53 EST