CAY-1307 describes a problem that existed with Oracle 8, so I'm not
sure it applies to Oracle 11. Also, it was fixed before 3.0 final was
released, so you are running with that patch.
mrg
On Tue, Sep 14, 2010 at 6:42 PM, bdflyfisher <bdflyfishe..ahoo.com> wrote:
>
> 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 : Wed Sep 15 2010 - 13:10:19 UTC