Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000

[yu wang <wa...@gmail.com>]

Hi Gurus,
I have manager.createNativeQuery() in a loop eventually lead to Oracle
error:
ORA-00604 and ORA-01000, which means cursors open in the oracle exceed the
maximum.

My question is how can I close some cursors explicitly in a loop? I try
manager.clear() but seems it does not work.

We are using OpenJPA 1.2.3.

Regards,
Yu Wang

Re: Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000

[yu wang <wa...@gmail.com>]

Rick,
I tried closeAll() but still got ora-00604 if the loop times is numberous.
I think it proves it is not an issue of openJPA and I will find the
solution from Oracle JDBC driver or datapase parameters directions.

Anyway, I appreciate your prompt help a lot.

Regards,
Yu Wang



On Tue, Mar 11, 2014 at 11:29 PM, yu wang <wa...@gmail.com> wrote:

> Rick,
> I believe openjpa does not close the statement promptly OR an oracle
> database jdbc driver issue. It seem if manager is used to create a lot of
> native queries in a loop, the cursors in Oracle database will not be
> released promptly enough. I am using ojdbc6.jar + openjpa-1.2.3.jar.
> Anyway, I will try the cast method. thanks in advance.
>
> Regards,
> Yu Wang
>
>
> On Tue, Mar 11, 2014 at 10:01 PM, Rick Curtis <cu...@gmail.com> wrote:
>
>> No, your question still isn't very clear.
>>
>> > Actually I just want to find a OpenJpa equivalence to close() method of
>> JDBC
>> Statement class
>> I believe that after OpenJPA is done processing a native query we will
>> close the statement. If that isn't happening, you could try to cast your
>> query to an OpenJPAQuery and call .closeAll() on it once you are done
>> using
>> it.
>>
>> Hope this helps.
>> Rick
>>
>>
>> On Tue, Mar 11, 2014 at 5:21 AM, yu wang <wa...@gmail.com> wrote:
>>
>> > Actually I just want to find a OpenJpa equivalence to close() method of
>> > JDBC Statement class....
>> >
>> >
>> > On Tue, Mar 11, 2014 at 5:56 PM, yu wang <wa...@gmail.com> wrote:
>> >
>> > > Hi Rick,
>> > > Is my case description clear enough? Any suggestions?
>> > >
>> > > Regards,
>> > > Yu Wang
>> > >
>> > >
>> > > On Sat, Mar 8, 2014 at 3:36 PM, yu wang <wa...@gmail.com> wrote:
>> > >
>> > >> Hi Rick,
>> > >> I have two very big master/slave tale I made them equal-partitioned
>> by
>> > >> time stamp columns. So when users query something from two tables, I
>> > >> separate the sql into a lot small sql for a lot of very small
>> interval
>> > in a
>> > >> loop to expedite the Execution of the SQL.
>> > >> Then I got "too many cursors" opened error from Oracle. What I am
>> trying
>> > >> to is getting a way to close the cursor explicitly after get its
>> result
>> > >> list.
>> > >>
>> > >> Regards,
>> > >> Yu Wang
>> > >>
>> > >>
>> > >>
>> > >>
>> > >> On Fri, Mar 7, 2014 at 10:00 PM, Rick Curtis <cu...@gmail.com>
>> > wrote:
>> > >>
>> > >>> You're going to have to give a better description of your scenario
>> for
>> > us
>> > >>> to help you.
>> > >>>
>> > >>> Thanks,
>> > >>> Rick
>> > >>>
>> > >>>
>> > >>> On Fri, Mar 7, 2014 at 3:37 AM, yu wang <wa...@gmail.com> wrote:
>> > >>>
>> > >>> > Hi Gurus,
>> > >>> > I have manager.createNativeQuery() in a loop eventually lead to
>> > Oracle
>> > >>> > error:
>> > >>> > ORA-00604 and ORA-01000, which means cursors open in the oracle
>> > exceed
>> > >>> the
>> > >>> > maximum.
>> > >>> >
>> > >>> > My question is how can I close some cursors explicitly in a loop?
>> I
>> > try
>> > >>> > manager.clear() but seems it does not work.
>> > >>> >
>> > >>> > We are using OpenJPA 1.2.3.
>> > >>> >
>> > >>> > Regards,
>> > >>> > Yu Wang
>> > >>> >
>> > >>>
>> > >>>
>> > >>>
>> > >>> --
>> > >>> *Rick Curtis*
>> > >>>
>> > >>
>> > >>
>> > >
>> >
>>
>>
>>
>> --
>> *Rick Curtis*
>>
>
>

Re: Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000

[yu wang <wa...@gmail.com>]

Rick,
I believe openjpa does not close the statement promptly OR an oracle
database jdbc driver issue. It seem if manager is used to create a lot of
native queries in a loop, the cursors in Oracle database will not be
released promptly enough. I am using ojdbc6.jar + openjpa-1.2.3.jar.
Anyway, I will try the cast method. thanks in advance.

Regards,
Yu Wang


On Tue, Mar 11, 2014 at 10:01 PM, Rick Curtis <cu...@gmail.com> wrote:

> No, your question still isn't very clear.
>
> > Actually I just want to find a OpenJpa equivalence to close() method of
> JDBC
> Statement class
> I believe that after OpenJPA is done processing a native query we will
> close the statement. If that isn't happening, you could try to cast your
> query to an OpenJPAQuery and call .closeAll() on it once you are done using
> it.
>
> Hope this helps.
> Rick
>
>
> On Tue, Mar 11, 2014 at 5:21 AM, yu wang <wa...@gmail.com> wrote:
>
> > Actually I just want to find a OpenJpa equivalence to close() method of
> > JDBC Statement class....
> >
> >
> > On Tue, Mar 11, 2014 at 5:56 PM, yu wang <wa...@gmail.com> wrote:
> >
> > > Hi Rick,
> > > Is my case description clear enough? Any suggestions?
> > >
> > > Regards,
> > > Yu Wang
> > >
> > >
> > > On Sat, Mar 8, 2014 at 3:36 PM, yu wang <wa...@gmail.com> wrote:
> > >
> > >> Hi Rick,
> > >> I have two very big master/slave tale I made them equal-partitioned by
> > >> time stamp columns. So when users query something from two tables, I
> > >> separate the sql into a lot small sql for a lot of very small interval
> > in a
> > >> loop to expedite the Execution of the SQL.
> > >> Then I got "too many cursors" opened error from Oracle. What I am
> trying
> > >> to is getting a way to close the cursor explicitly after get its
> result
> > >> list.
> > >>
> > >> Regards,
> > >> Yu Wang
> > >>
> > >>
> > >>
> > >>
> > >> On Fri, Mar 7, 2014 at 10:00 PM, Rick Curtis <cu...@gmail.com>
> > wrote:
> > >>
> > >>> You're going to have to give a better description of your scenario
> for
> > us
> > >>> to help you.
> > >>>
> > >>> Thanks,
> > >>> Rick
> > >>>
> > >>>
> > >>> On Fri, Mar 7, 2014 at 3:37 AM, yu wang <wa...@gmail.com> wrote:
> > >>>
> > >>> > Hi Gurus,
> > >>> > I have manager.createNativeQuery() in a loop eventually lead to
> > Oracle
> > >>> > error:
> > >>> > ORA-00604 and ORA-01000, which means cursors open in the oracle
> > exceed
> > >>> the
> > >>> > maximum.
> > >>> >
> > >>> > My question is how can I close some cursors explicitly in a loop? I
> > try
> > >>> > manager.clear() but seems it does not work.
> > >>> >
> > >>> > We are using OpenJPA 1.2.3.
> > >>> >
> > >>> > Regards,
> > >>> > Yu Wang
> > >>> >
> > >>>
> > >>>
> > >>>
> > >>> --
> > >>> *Rick Curtis*
> > >>>
> > >>
> > >>
> > >
> >
>
>
>
> --
> *Rick Curtis*
>

Re: Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000

[Rick Curtis <cu...@gmail.com>]

No, your question still isn't very clear.

> Actually I just want to find a OpenJpa equivalence to close() method of JDBC
Statement class
I believe that after OpenJPA is done processing a native query we will
close the statement. If that isn't happening, you could try to cast your
query to an OpenJPAQuery and call .closeAll() on it once you are done using
it.

Hope this helps.
Rick


On Tue, Mar 11, 2014 at 5:21 AM, yu wang <wa...@gmail.com> wrote:

> Actually I just want to find a OpenJpa equivalence to close() method of
> JDBC Statement class....
>
>
> On Tue, Mar 11, 2014 at 5:56 PM, yu wang <wa...@gmail.com> wrote:
>
> > Hi Rick,
> > Is my case description clear enough? Any suggestions?
> >
> > Regards,
> > Yu Wang
> >
> >
> > On Sat, Mar 8, 2014 at 3:36 PM, yu wang <wa...@gmail.com> wrote:
> >
> >> Hi Rick,
> >> I have two very big master/slave tale I made them equal-partitioned by
> >> time stamp columns. So when users query something from two tables, I
> >> separate the sql into a lot small sql for a lot of very small interval
> in a
> >> loop to expedite the Execution of the SQL.
> >> Then I got "too many cursors" opened error from Oracle. What I am trying
> >> to is getting a way to close the cursor explicitly after get its result
> >> list.
> >>
> >> Regards,
> >> Yu Wang
> >>
> >>
> >>
> >>
> >> On Fri, Mar 7, 2014 at 10:00 PM, Rick Curtis <cu...@gmail.com>
> wrote:
> >>
> >>> You're going to have to give a better description of your scenario for
> us
> >>> to help you.
> >>>
> >>> Thanks,
> >>> Rick
> >>>
> >>>
> >>> On Fri, Mar 7, 2014 at 3:37 AM, yu wang <wa...@gmail.com> wrote:
> >>>
> >>> > Hi Gurus,
> >>> > I have manager.createNativeQuery() in a loop eventually lead to
> Oracle
> >>> > error:
> >>> > ORA-00604 and ORA-01000, which means cursors open in the oracle
> exceed
> >>> the
> >>> > maximum.
> >>> >
> >>> > My question is how can I close some cursors explicitly in a loop? I
> try
> >>> > manager.clear() but seems it does not work.
> >>> >
> >>> > We are using OpenJPA 1.2.3.
> >>> >
> >>> > Regards,
> >>> > Yu Wang
> >>> >
> >>>
> >>>
> >>>
> >>> --
> >>> *Rick Curtis*
> >>>
> >>
> >>
> >
>



-- 
*Rick Curtis*

Re: Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000

[yu wang <wa...@gmail.com>]

Actually I just want to find a OpenJpa equivalence to close() method of
JDBC Statement class....


On Tue, Mar 11, 2014 at 5:56 PM, yu wang <wa...@gmail.com> wrote:

> Hi Rick,
> Is my case description clear enough? Any suggestions?
>
> Regards,
> Yu Wang
>
>
> On Sat, Mar 8, 2014 at 3:36 PM, yu wang <wa...@gmail.com> wrote:
>
>> Hi Rick,
>> I have two very big master/slave tale I made them equal-partitioned by
>> time stamp columns. So when users query something from two tables, I
>> separate the sql into a lot small sql for a lot of very small interval in a
>> loop to expedite the Execution of the SQL.
>> Then I got "too many cursors" opened error from Oracle. What I am trying
>> to is getting a way to close the cursor explicitly after get its result
>> list.
>>
>> Regards,
>> Yu Wang
>>
>>
>>
>>
>> On Fri, Mar 7, 2014 at 10:00 PM, Rick Curtis <cu...@gmail.com> wrote:
>>
>>> You're going to have to give a better description of your scenario for us
>>> to help you.
>>>
>>> Thanks,
>>> Rick
>>>
>>>
>>> On Fri, Mar 7, 2014 at 3:37 AM, yu wang <wa...@gmail.com> wrote:
>>>
>>> > Hi Gurus,
>>> > I have manager.createNativeQuery() in a loop eventually lead to Oracle
>>> > error:
>>> > ORA-00604 and ORA-01000, which means cursors open in the oracle exceed
>>> the
>>> > maximum.
>>> >
>>> > My question is how can I close some cursors explicitly in a loop? I try
>>> > manager.clear() but seems it does not work.
>>> >
>>> > We are using OpenJPA 1.2.3.
>>> >
>>> > Regards,
>>> > Yu Wang
>>> >
>>>
>>>
>>>
>>> --
>>> *Rick Curtis*
>>>
>>
>>
>

Re: Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000

[yu wang <wa...@gmail.com>]

Hi Rick,
Is my case description clear enough? Any suggestions?

Regards,
Yu Wang


On Sat, Mar 8, 2014 at 3:36 PM, yu wang <wa...@gmail.com> wrote:

> Hi Rick,
> I have two very big master/slave tale I made them equal-partitioned by
> time stamp columns. So when users query something from two tables, I
> separate the sql into a lot small sql for a lot of very small interval in a
> loop to expedite the Execution of the SQL.
> Then I got "too many cursors" opened error from Oracle. What I am trying
> to is getting a way to close the cursor explicitly after get its result
> list.
>
> Regards,
> Yu Wang
>
>
>
>
> On Fri, Mar 7, 2014 at 10:00 PM, Rick Curtis <cu...@gmail.com> wrote:
>
>> You're going to have to give a better description of your scenario for us
>> to help you.
>>
>> Thanks,
>> Rick
>>
>>
>> On Fri, Mar 7, 2014 at 3:37 AM, yu wang <wa...@gmail.com> wrote:
>>
>> > Hi Gurus,
>> > I have manager.createNativeQuery() in a loop eventually lead to Oracle
>> > error:
>> > ORA-00604 and ORA-01000, which means cursors open in the oracle exceed
>> the
>> > maximum.
>> >
>> > My question is how can I close some cursors explicitly in a loop? I try
>> > manager.clear() but seems it does not work.
>> >
>> > We are using OpenJPA 1.2.3.
>> >
>> > Regards,
>> > Yu Wang
>> >
>>
>>
>>
>> --
>> *Rick Curtis*
>>
>
>

Re: Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000

[yu wang <wa...@gmail.com>]

Hi Rick,
I have two very big master/slave tale I made them equal-partitioned by time
stamp columns. So when users query something from two tables, I separate
the sql into a lot small sql for a lot of very small interval in a loop to
expedite the Execution of the SQL.
Then I got "too many cursors" opened error from Oracle. What I am trying to
is getting a way to close the cursor explicitly after get its result list.

Regards,
Yu Wang




On Fri, Mar 7, 2014 at 10:00 PM, Rick Curtis <cu...@gmail.com> wrote:

> You're going to have to give a better description of your scenario for us
> to help you.
>
> Thanks,
> Rick
>
>
> On Fri, Mar 7, 2014 at 3:37 AM, yu wang <wa...@gmail.com> wrote:
>
> > Hi Gurus,
> > I have manager.createNativeQuery() in a loop eventually lead to Oracle
> > error:
> > ORA-00604 and ORA-01000, which means cursors open in the oracle exceed
> the
> > maximum.
> >
> > My question is how can I close some cursors explicitly in a loop? I try
> > manager.clear() but seems it does not work.
> >
> > We are using OpenJPA 1.2.3.
> >
> > Regards,
> > Yu Wang
> >
>
>
>
> --
> *Rick Curtis*
>

Re: Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000

[Rick Curtis <cu...@gmail.com>]

You're going to have to give a better description of your scenario for us
to help you.

Thanks,
Rick


On Fri, Mar 7, 2014 at 3:37 AM, yu wang <wa...@gmail.com> wrote:

> Hi Gurus,
> I have manager.createNativeQuery() in a loop eventually lead to Oracle
> error:
> ORA-00604 and ORA-01000, which means cursors open in the oracle exceed the
> maximum.
>
> My question is how can I close some cursors explicitly in a loop? I try
> manager.clear() but seems it does not work.
>
> We are using OpenJPA 1.2.3.
>
> Regards,
> Yu Wang
>



-- 
*Rick Curtis*