Joseph, thank you for your email. This was just fixed on 3.0, 3.1 and 3.2 (trunk) branches - see https://issues.apache.org/jira/browse/CAY-1721
2012/7/3 Joseph Senecal <sene...@apple.com>: > Background: > Deploying Cayenne program to some new Linux servers, we're getting exceptions > when the program tries to write a blob: > > Caused by: java.sql.SQLException: Invalid argument(s) in call > at > oracle.jdbc.driver.T4CConnection.newOutputStream(T4CConnection.java:2753) > ~[ojdbc6.jar:11.2.0.1.0] > at oracle.sql.BLOB.setBinaryStream(BLOB.java:893) > ~[ojdbc6.jar:11.2.0.1.0] > at > org.apache.cayenne.dba.oracle.OracleLOBBatchAction.writeBlob(OracleLOBBatchAction.java:255) > ~[cayenne-server-3.1M3.jar:na] > at > org.apache.cayenne.dba.oracle.OracleLOBBatchAction.processLOBRow(OracleLOBBatchAction.java:211) > ~[cayenne-server-3.1M3.jar:na] > at > org.apache.cayenne.dba.oracle.OracleLOBBatchAction.performAction(OracleLOBBatchAction.java:132) > ~[cayenne-server-3.1M3.jar:na] > at > org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:87) > ~[cayenne-server-3.1M3.jar:na] > at > org.apache.cayenne.access.DataNode.performQueries(DataNode.java:278) > ~[cayenne-server-3.1M3.jar:na] > at > org.apache.cayenne.access.DataDomainFlushAction.runQueries(DataDomainFlushAction.java:237) > ~[cayenne-server-3.1M3.jar:na] > at > org.apache.cayenne.access.DataDomainFlushAction.flush(DataDomainFlushAction.java:154) > ~[cayenne-server-3.1M3.jar:na] > at > org.apache.cayenne.access.DataDomain.onSyncFlush(DataDomain.java:803) > ~[cayenne-server-3.1M3.jar:na] > at > org.apache.cayenne.access.DataDomain$2.transform(DataDomain.java:767) > ~[cayenne-server-3.1M3.jar:na] > at > org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:828) > ~[cayenne-server-3.1M3.jar:na] > at > org.apache.cayenne.access.DataDomain.onSyncNoFilters(DataDomain.java:764) > ~[cayenne-server-3.1M3.jar:na] > at > org.apache.cayenne.access.DataDomain$DataDomainSyncFilterChain.onSync(DataDomain.java:980) > ~[cayenne-server-3.1M3.jar:na] > at org.apache.cayenne.access.DataDomain.onSync(DataDomain.java:735) > ~[cayenne-server-3.1M3.jar:na] > at > org.apache.cayenne.access.DataContext.flushToParent(DataContext.java:818) > ~[cayenne-server-3.1M3.jar:na] > ... 8 common frames omitted > > > As you can see from the trace, I'm still using M3. I found a couple of blogs > related to this issue: > > One specific to Cayenne from 2010: > http://cayenne.195.n3.nabble.com/Cayenne-error-while-committing-CLOB-on-Oracle-td1475847.html > > And one that describes what's happening (not Cayenne specific): > http://java.ittoolbox.com/groups/technical-functional/java-l/invalid-arguments-in-call-in-line-oraclesqlblobcreatetemporary-oracle-10g-1468092 > > Question: > Has this problem been fixed in 3.1B1? Or is our only option to find and use > an older Oracle JDBC adapter. Or is there more to this issue than what I've > found? > > Joe -- Olga Tkacheva
