Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000
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
Please update the website with 2.3.0 release
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 this with highest importance. I have made OPENJPA-2480 for tracking this request. Thank you, -- Rade -- View this message in context: http://openjpa.208410.n2.nabble.com/Please-update-the-website-with-2-3-0-release-tp7586050.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
Re: Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000
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*
Re: Please update the website with 2.3.0 release
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 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 this with highest importance. I have made OPENJPA-2480 for tracking this request. Thank you, -- Rade -- View this message in context: http://openjpa.208410.n2.nabble.com/Please-update-the-website-with-2-3-0-release-tp7586050.html Sent from the OpenJPA Users mailing list archive at Nabble.com.
Re: Oracle error ORA-00604: ?? SQL ?? 1 ???? ORA-01000
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*