cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joseph Senecal <sene...@apple.com>
Subject Writing blobs fails
Date Mon, 02 Jul 2012 21:19:46 GMT
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

Mime
View raw message