Hi guys! In the near future I will try to investigate this issue. I hope tomorrow.
2010/9/15 Andrus Adamchik <[email protected]>: > > > Begin forwarded message: > >> From: bdflyfisher <[email protected]> >> Date: September 14, 2010 6:42:21 PM EDT >> To: [email protected] >> Subject: Re: Cayenne error while committing CLOB on Oracle >> Reply-To: [email protected] >> >> >> 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
