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