openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "nick_j_mann@uk.ibm.com" <nick_j_m...@uk.ibm.com>
Subject Re: oracle 11g - operation not allowed: streams type cannot be used in batching
Date Wed, 14 Oct 2009 12:56:07 GMT

Thanks... the removal of batching suggestion worked as a temporary measure
and I'll check out the later jdbc version

Nick


Jeremy Bauer wrote:
> 
> Nick,
> 
> I ran into a batching related issue while doing some Oracle testing on
> trunk
> (2.0.0) a short while ago.  The issue was fixed in the 11.2.0.1 version of
> the JDBC driver.  It might be worth a shot to try the 11.2.0.1 driver
> before
> disabling statement batching.
> 
> -Jeremy
> 
> On Tue, Oct 13, 2009 at 9:39 AM, Michael Dick
> <michael.d.dick@gmail.com>wrote:
> 
>> Hi Nick,
>>
>> It sounds like turning off SQL statement batching will help here's a link
>> to
>> the section in the manual :
>>
>> http://openjpa.apache.org/builds/1.2.1/apache-openjpa-1.2.1/docs/manual/manual.html#ref_guide_dbsetup_stmtbatch
>>
>> -mike
>>
>> On Tue, Oct 13, 2009 at 8:26 AM, nick_j_mann@uk.ibm.com <
>> nick_j_mann@uk.ibm.com> wrote:
>>
>> >
>> > Just retested this in oracle 10g and appears to be the same issue
>> >
>> > Oracle 10g R2 using ojdbc14.jar - 10.1.0.2.0
>> >
>> > Nick
>> >
>> >
>> > nick_j_mann@uk.ibm.com wrote:
>> > >
>> > > Hi there
>> > > While testing my app against oracle 11 g i discover this new error.
>> I'm
>> > > using openjpa 1.2.1
>> > >
>> > > I'm using the ojdbc5.jar - 11.1.0.6.0
>> > >
>> > > org.apache.openjpa.persistence.PersistenceException: operation not
>> > > allowed: streams type cannot be used in batching
>> > >
>> > > this occuers when trying to insert to a table associated with a pojo
>> that
>> > > has a Lob annotation
>> > >
>> > > this works on sqlserver and with oracle 10g
>> > >
>> >
>> > --
>> > View this message in context:
>> >
>> http://n2.nabble.com/oracle-11g-operation-not-allowed-streams-type-cannot-be-used-in-batching-tp3816015p3816032.html
>> > Sent from the OpenJPA Users mailing list archive at Nabble.com.
>> >
>>
> 
> 

-- 
View this message in context: http://n2.nabble.com/oracle-11g-operation-not-allowed-streams-type-cannot-be-used-in-batching-tp3816015p3822543.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Mime
View raw message