Hi Rick, Is my case description clear enough? Any suggestions? Regards, Yu Wang
On Sat, Mar 8, 2014 at 3:36 PM, yu wang <wangy...@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 <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* >> > >