Re: [Firebird-net-provider] R: Invalid attempt of read when the reader is closed.

[Jiri C. <di...@ci...>]

On 8/30/07, Alberto Picca <alb...@ti...> wrote:
> Ok.
> I remove my Dispose method at the end of the function.
> Then, why after 200 command execution a process memory it increase from
> 30 mb to 400 mb,
> in few minuts?

First. GC works as generational. So when it's not required the memory
isn't freeed (in simply way, it's more complicated in real). If you're
looking for memory, use assembler ... .NET is about efectivity of
development.

> It seems that the GC does not understand that comes however executed the
> auto Dispose() command.
> How never?
> It's necessary to set up some flag?
> Using others driver net it is for Oracle that for Sql Serveur this does
> not happen.

Your function has wrong design. Why are you returning datareader? It's
not well designed. You should return some data, that datareader got.
I.e. array of something. Or IList of something. This is more clean
way.

> Thanks
>
> -----Messaggio originale-----
> Da: Jiri Cincura [mailto:di...@ci...]
> Inviato: mercoled=EC 29 agosto 2007 18.31
> A: alb...@ti...; For users and developers of the Firebird .NET
> providers
> Oggetto: Re: [Firebird-net-provider] Invalid attempt of read when the
> reader is closed.
>
>
> On 8/29/07, alb...@ti... <alb...@ti...> wrote:
> > Hi,
> >   using a version 2.1.0 RC-1 i have
> >   some problem with a Dispose
> > method.
> >
> >   Why throw this exception ?
> >    "Invalid attempt of read when
> > the reader is closed."
> >
> >   I create a FbCommand in this mode:
> >
> >   private
> > static object executeQuery(DbConnection p_conn, string p_sql,
> > hashtable
> > p_params)
> >  {
> >     DbCommand oc =3D null;
> >     object res =3D DBNull.Value;
> >
> >     if (p_conn.getType().Equals(typeOf(FbConnection)) ){
> >        oc =3D
> > new FbCommand(p_sql, (FbConnection)p_conn);
> >        ... assign params
> >        res =3D oc.ExecuteReader();
> >
> >     }
> >     ...other
> > database connection type, such as Oracle, Sql Server...
> >
> >     oc.
> > Dispose();
> >
> >     return res;
> >   }
> >
> >   I use the Dispose() method
> > because I see the memory of the
> >   main process increase in exponential
> > mode.
> >
> > Sorry for my bad english.
> >
> > Thanks.
> >
> > Alberto
> >
>
> When you dispose connection, the connection is also closed. So then,
> you're not able to read domething from datareader.
>
> --
> Jiri {x2} Cincura (Microsoft Student Partner)
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.484 / Virus Database: 269.12.10/976 - Release Date:
> 27/08/2007 18.20
>
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>


--=20
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com