Re: [gnome-db] Oracle provider not closing connections ?

[Steve Fosdick <lists pelvoux nildram co uk>]

On 30 May 2003 14:05:12 +0530
Biswapesh Chattopadhyay <biswapesh_chatterjee tcscal co in> wrote:

> I have a fairly large Oracle DB with lots of entities. When I connect
> to the DB from Mergeant (latest CVS), the DB synchronization popup
> opens up, and after a while I start getting this error repetitively:
> 
> ---------------------------------
> ORA-01000: maximum open cursors exceeded
> --------------------------------
> 
> in a dialog box

The problem is that the Oracle provider uses an internal query to find
the indexes and constraints associated with a given table, but forgets
to free that query afterwards so if there are many tables Oracle runs
out of cursors.

I have had a brief go at fixing this, but when I free the query
correctly the application locks up instead so there is more work to find
what is happenning there.

So, this is a bug - could you raise a bug report in bugzilla?

Steve.