[Mono-dev] Clear Connection Pool (SybaseConnection)

[Nagappan A]

Hi Thomas,

I fixed related to this issue with Mono 1.2.5, but for SqlClient.

I could not get the relevant URL, but similar bug
https://bugzilla.novell.com/show_bug.cgi?id=MONO81933

Not sure about WebApp, probably grendel can help me in this...

Thanks
Nagappan

On 9/27/07, thomas.x.juul at us.hsbc.com <thomas.x.juul at us.hsbc.com> wrote:
>
>
> 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.
> ******************************************************************
>
>


-- 
Linux Desktop Testing Project - http://ldtp.freedesktop.org
http://nagappanal.blogspot.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-devel-list/attachments/20070927/79930b2d/attachment.html