Re: ORA-01000: maximum open cursors exceeded

Your problem has nothing to do with your pl/sql code. You mention "bean".

>> After 3 texts has bean fetched

RETURN get_all;

Is returning a cursor to your caller. As your callable statement fetches, when completed it not properly closing your cursor.

There is an interesting article in this month's java developers journal regarding this and other common jdbc problems.

This is a very common problem, but in a nutshell, you need to put appropriate code in a finally block to close your statements, resultsets and anything else you have opened.

But you can stop suspecting your oracle configuration, it is your client/middle tier. Your settings are probably fine, or at least they will not start crashing this quickly.

"Christian Antognini" <christian.antognini_at_trivadis.com> wrote in message news:<41752916_at_post.usenet.com>...
> **** Post for FREE via your newsreader at post.usenet.com ****
>
>
> "vinnie washington" <vwas_at_hotmail.com> wrote in message
> news:fb9e060a.0410181541.2390054_at_posting.google.com...
> > I'm wondering if anyone can help me figure out why I'm receiving this
> > problem. I am running Oracle 8.1.7 on Win2K server and have been
> > receiving this message in my application. When I query 'select
> > sql_text from v$open_cursor; ' to see what is holding things up, I
> > see:
> >
> > SELECT NULL AS table_cat, t.owner AS table_schem,
> >
> > with 300 entries in the table. Any thoughts?
>
> Have a look to the whole sql statement. v$open_cursor only contains the
> first 60 characters... v$sqlarea the first 1000.
> Use a query like the following one:
>
> select count(*), sum(s.executions) executions, s.sql_text
> from v$open_cursor o, v$sqlarea s
> where o.address = s.address
> and o.hash_value = s.hash_value
> group by s.sql_text
> order by 1 desc;
>
>
> Chris
>
>
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
> http://www.usenet.com
> Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Received on Thu Oct 21 2004 - 07:25:48 CDT