cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Gentry <mgen...@masslight.net>
Subject Re: Cayenne error while committing CLOB on Oracle
Date Wed, 15 Sep 2010 13:09:23 GMT
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 <bdflyfisher@yahoo.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.
>

Mime
View raw message