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