Hi guys!
In the near future I will try to investigate this issue. I hope tomorrow.
2010/9/15 Andrus Adamchik <andru..bjectstyle.org>:
>
>
> Begin forwarded message:
>
>> From: bdflyfisher <bdflyfishe..ahoo.com>
>> Date: September 14, 2010 6:42:21 PM EDT
>> To: use..ayenne.apache.org
>> Subject: Re: Cayenne error while committing CLOB on Oracle
>> Reply-To: use..ayenne.apache.org
>>
>>
>> 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.
>>
>
>
-- Olga Tkacheva
This archive was generated by hypermail 2.0.0 : Wed Sep 15 2010 - 14:26:52 UTC