Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000

2014-03-07 Thread yu wang
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

Please update the website with 2.3.0 release

2014-03-07 Thread RadeMartinovic
I have not realized that 2.3.0 has been released for a while now. This is due to the website not being updated. Surely I am not the only one that checks the website for news and releases. The most important items to be updated are index.html, downloads.html and documentation.html. Please treat

Re: Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000

2014-03-07 Thread Rick Curtis
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

Re: Please update the website with 2.3.0 release

2014-03-07 Thread Kevin Sutter
Good catch, Rade. This was missed with our release process for 2.3.0. We will get this cleaned up shortly (along with openjpa-2481). Thanks, Kevin On Fri, Mar 7, 2014 at 6:21 AM, RadeMartinovic r...@rcub.bg.ac.rs wrote: I have not realized that 2.3.0 has been released for a while now. This

Re: Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000

2014-03-07 Thread yu wang
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