cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bdflyfisher <bdflyfis...@yahoo.com>
Subject Re: Cayenne error while committing CLOB on Oracle
Date Tue, 14 Sep 2010 22:42:21 GMT

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