[Mono-devel-list] Npgsql possible bug

[Francisco Figueiredo Jr.]

 --- yoros at wanadoo.es escreveu: > On Thu, Dec 25, 2003 at 11:37:06PM +0100,
Jaroslaw Kowalski wrote:
> > Hi all!
> > 

Hi Jaroslaw!

> > This is my first post to nant-devel-list, so please excuse any "formal"
> > mistakes. I'm in progress of porting my O/R mapping solution to
> > Mono/PostgreSQL and I've encountered the bug in Npgsql. Is this the right
> > list to report this problem to?
> > 

Yeap. This list is the right place to report it.
Also, there are the npgsql-general and npgsql-hackers list at gborg:
http://gborg.postgresql.org/mailman/listinfo/npgsql

> > The problem is related to the fact that NpgsqlCommand calls
> > connection.Dispose() in it's Dispose method. This causes problems with
> > constructs like the following, which are legal in MS.NET with MSSQL:

> 
> Yes, that code shouldn't be there but when we use NpgsqlDataAdapter with
> DataSet, DataTable, etc... the connection is not closed:
> 
> 	LOG:  pq_recvbuf: unexpected EOF on client connection
> 
> I think that when a command is disposed, it's underlying connection
> shouldn't be disposed too but the physical connection can be closed and
> the connection changes its inner state. In this way the connection can
> be reopenend...
> 
> Please take care of what I said and, if you have time...
> 

I also think the connection shouldn't be disposing the connection. As, Jaroslaw
said, you could use the connection with other commands.

Unfortunately I'm not using my development machine right now, and so, I can't
check it better, but I think we may be missing something in the
NpgsqlDataAdapter to close the connection when using commands, maybe specifing
the CloseConnection behavior as Jaroslaw said.

As soon as I get back to my development machine I will check that.
 
Regards,

Francisco Figueiredo Jr.


Yahoo! Mail - 6MB, anti-spam e antivírus gratuito. Crie sua conta agora:
http://mail.yahoo.com.br