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 <curti...@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 <wangy...@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* >