Re: Too many open cursors

On Thu, 2006-11-09 at 06:07, Sandeep Kumar Jakkaraju wrote:
>
> Hi All ..
>
> I have used Oracle 9i in the past ...currently working on postgres ...
>
> Oracle throws this SQLException ... Too many open cursors
> when there are too many connections to the database.....

That may be the exception you've seen, but I'm pretty sure Oracle also
has an exception for too many connections that says something about
there being too many connections.

> I have found that ..but postgres ..locks ..the DB ..and doesnt throw
> this exception

Ummm. what do you mean by "locks"??? The db stops working completely,
even for the clients you already have connected? Won't accept new
connections but keeps processing the old ones?

> I am true or ...mine can be a special case !!???

We need more quoting of the error messages you're getting. What we've
got now doesn't help a lot.

You should get an error message saying something about too many
connections open