openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yu wang <wangy...@gmail.com>
Subject Re: Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000
Date Tue, 11 Mar 2014 10:21:08 GMT
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 <wangyumi@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 <wangyumi@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 <curtisr7@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 <wangyumi@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*
>>>
>>
>>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message