cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Richard Frovarp <rfrov...@apache.org>
Subject Re: Writing blobs fails
Date Tue, 03 Jul 2012 13:46:22 GMT
Use the latest driver. We had trouble until we went with 11.2.0.3. It now
works just fine for us.
On Jul 2, 2012 4:21 PM, "Joseph Senecal" <senecal@apple.com> wrote:

> 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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message