[Mono-dev] Clear Connection Pool (SybaseConnection)

[thomas.x.juul at us.hsbc.com]

Nagappan,

When are the (sybase) connection pool cleared in a WebApp using ModMono?
When the AppDomain is unloaded?


My scenario:

1: Connection Pool enabled
2: Create a connection to the database and select some data
3: Force a network error (unplug the network to the database server)
4: Create a connection to the database and select some data. This fails.
5: Enable the network connection again.
6: Create a connection to the database and select some data. This fails 
because its using the "bad" connection from the connection pool.

I guess the only solution is to disable connection pooling in my case?

Thomas






"Nagappan A" <nagappan at gmail.com> 
09/27/2007 09:57 AM

To
thomas.x.juul at us.hsbc.com
cc
mono-devel-list at lists.ximian.com
Subject
Re: [Mono-dev] Clear Connection Pool (SybaseConnection)






Hi,

As of now no. I have implemented it in TDS and its currently being
used by SqlClient only. This has to be extended to SybaseClient.

Thanks
Nagappan

On 9/27/07, thomas.x.juul at us.hsbc.com <thomas.x.juul at us.hsbc.com> wrote:
>
> Hi,
>
> Is it possible to explicit clear the connection pool on the
> SybaseConnection?
>
> Regards
> Thomas
>
>
> ________________________________
>
>
>
>
> ******************************************************************
>  This E-mail is confidential. It may also be legally privileged. If
>  you are not the addressee you may not copy, forward, disclose or
>  use any part of it. If you have received this message in error,
>  please delete it and all copies from your system and notify the
>  sender immediately by return E-mail.
>
>  Internet communications cannot be guaranteed to be timely, secure,
>  error or virus-free. The sender does not accept liability for any
>  errors or omissions.
> ******************************************************************
>  SAVE PAPER - THINK BEFORE YOU PRINT!
> _______________________________________________
> Mono-devel-list mailing list
> Mono-devel-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-devel-list
>
>


-- 
Linux Desktop Testing Project - http://ldtp.freedesktop.org
http://nagappanal.blogspot.com
-----------------------------------------
******************************************************************
This message originated from the Internet.  Its originator may or
may not be who they claim to be and the information contained in
the message and any attachments may or may not be accurate.
******************************************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-devel-list/attachments/20070927/f5f9ec8c/attachment.html