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.
