Rick, I believe openjpa does not close the statement promptly OR an oracle database jdbc driver issue. It seem if manager is used to create a lot of native queries in a loop, the cursors in Oracle database will not be released promptly enough. I am using ojdbc6.jar + openjpa-1.2.3.jar. Anyway, I will try the cast method. thanks in advance.
Regards, Yu Wang On Tue, Mar 11, 2014 at 10:01 PM, Rick Curtis <curti...@gmail.com> wrote: > 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* >