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

[Biswapesh Chattopadhyay <biswapesh_chatterjee tcscal co in>]

Seems to be fixed. However, I'm now getting this on one table:

--------------------------------------
ADDED TABLE _default_auditing_options_, rdata=0x94d5170
Position 2: Expected 8, got 14
 
(mergeant:29858): mergeant-WARNING **: The provider has returned the
wrong
number and/or types of data
for the FIELDS schema description.
Please contact the provider's maintainer and report the problem.
--------------------------------------

At the same time, I'm getting an ORA-911 error.

Any clues ?

On Tue, 2003-06-03 at 04:54, gnome-db-list-admin gnome org wrote:
> On Mon, 2 Jun 2003 22:09:59 +0100 I <lists pelvoux nildram co uk> wrote:
> 
> > 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 believe I have now fixed this in CVS.  I have tested the code on a
> database schema with 125 tables and 48 views which used to fail with the
> ORA-01000 error and it now works correctly.
> 
> Normally I would suggest trying the CVS snapshot from the Gnome-DB home
> page but that seems rather out of date at the moment so instead you
> could anonymous CVS access as explaining in:
> 
>     http://developer.gnome.org/tools/cvs.html
> 
> The module to check out is libgda.
> 
> > So, this is a bug - could you raise a bug report in bugzilla?
> 
> If you haven't already done this then there is no need, unless you find
> the problem isn't fixed.
> 
> Steve.
> _______________________________________________
> gnome-db-list mailing list
> gnome-db-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnome-db-list
> 
>