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
