Re: Cayenne error while committing CLOB on Oracle

From: bdflyfisher (bdflyfishe..ahoo.com)
Date: Tue Sep 14 2010 - 22:42:21 UTC

  • Next message: emanuel..engozzi.com: "Deploying multiple instances from a single war"

    In my searching, I found the following, which makes me think this was not an
    issue in cayenne 2, but is an issue in cayenne 3.0, and will be fixed in
    cayenne 3.1. Is that true? Here is the link:

    https://issues.apache.org/jira/browse/CAY-1307

    Here is the full error stack:

    INFO: --- will run 1 query.
    Sep 14, 2010 4:26:19 PM org.apache.cayenne.access.QueryLogger
    logBeginTransaction
    INFO: --- transaction started.
    Sep 14, 2010 4:26:19 PM org.apache.cayenne.access.QueryLogger logQuery
    INFO: UPDATE CSPROPERTY SET PROPERTYVALUE = EMPTY_CLOB() WHERE
    CSPROPERTYGUID = ?
    Sep 14, 2010 4:26:19 PM org.apache.cayenne.access.QueryLogger
    logQueryParameters
    INFO: [bind: 1:'8e07797b-84ac-e434-e040-007f01...']
    Sep 14, 2010 4:26:19 PM org.apache.cayenne.access.QueryLogger logUpdateCount
    INFO: === updated 1 row.
    Sep 14, 2010 4:26:19 PM org.apache.cayenne.access.QueryLogger logQuery
    INFO: SELECT PROPERTYVALUE FROM CSPROPERTY WHERE CSPROPERTYGUID = ? FOR
    UPDATE [bind: 1:'8e07797b-84ac-e434-e040-007f01...']
    Sep 14, 2010 4:26:19 PM org.apache.cayenne.access.QueryLogger
    logQueryParameters
    INFO: [write LOB: 1:'true']
    Sep 14, 2010 4:26:19 PM org.apache.cayenne.access.QueryLogger logQueryError
    INFO: *** error.
    java.sql.SQLException: Invalid argument(s) in call
            at oracle.jdbc.driver.T4CConnection.newWriter(T4CConnection.java:3516)
            at oracle.sql.CLOB.setCharacterStream(CLOB.java:1168)
            at
    org.apache.cayenne.dba.oracle.OracleLOBBatchAction.writeClob(OracleLOBBatchAction.java:296)
            at
    org.apache.cayenne.dba.oracle.OracleLOBBatchAction.processLOBRow(OracleLOBBatchAction.java:199)
            at
    org.apache.cayenne.dba.oracle.OracleLOBBatchAction.performAction(OracleLOBBatchAction.java:128)
            at
    org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:87)
            at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:269)
            at
    org.apache.cayenne.access.DataDomainFlushAction.runQueries(DataDomainFlushAction.java:226)
            at
    org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:144)
            at org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:824)
            at org.apache.cayenne.access.DataDomain$2.transform(DataDomain.java:791)
            at
    org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:850)
            at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:788)
            at
    org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:1106)
            at
    org.apache.cayenne.access.DataContext.commitChanges(DataContext.java:1045)

    desc csproperty
    Name Null Type
    ------------------------------ --------
    ----------------------------------------------------------------
    CSPROPERTYGUID NOT NULL VARCHAR2(36)
    PROPERTYVALUE NOT NULL CLOB() 

    -- 
View this message in context: http://cayenne.195.n3.nabble.com/Cayenne-error-while-committing-CLOB-on-Oracle-tp1475847p1476283.html
Sent from the Cayenne - User mailing list archive at Nabble.com.

    This archive was generated by hypermail 2.0.0 : Tue Sep 14 2010 - 22:42:51 UTC