You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openjpa.apache.org by Michael Dick <mi...@gmail.com> on 2009/10/13 16:39:01 UTC
Re: oracle 11g - operation not allowed: streams type cannot be used
in batching
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.
>
Re: oracle 11g - operation not allowed: streams type cannot be used
in batching
Posted by pgarg2000 <pg...@njit.edu>.
I am using driver oracle-driver-11.2.0.1.0.jar but still fascing the issue
"streams type cannot be used in batching" when using Lob/Clob with batching
in orcale. We are using "Oracle Database 10g Enterprise Edition Release
10.2.0.4.0 - 64bi"
--
View this message in context: http://openjpa.208410.n2.nabble.com/oracle-11g-operation-not-allowed-streams-type-cannot-be-used-in-batching-tp3816015p5460001.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
Re: oracle 11g - operation not allowed: streams type cannot be used
in batching
Posted by "nick_j_mann@uk.ibm.com" <ni...@uk.ibm.com>.
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
> <mi...@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.
Re: oracle 11g - operation not allowed: streams type cannot be used
in batching
Posted by Jeremy Bauer <te...@gmail.com>.
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 <mi...@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.
> >
>