[CAY-1721] Writing blobs fails (Oracle)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0, 3.1B1, 3.2.M1
• Fix Version/s: 3.1B2, 3.2.M1, 3.0.3
• Assignee: Olga Tkacheva
• Reporter: Olga Tkacheva
• Created: 05/Jul/12 15:03
• Updated: 05/Jul/12 18:55
• Resolved: 05/Jul/12 16:01

Description

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

SEE MORE IN DISCUSSION

http://cayenne.195.n3.nabble.com/Writing-blobs-fails-td4024346.html