From: Reggie Burnett
Date: October 28 2004 8:39pm
Subject: RE: Connection Pooling
List-Archive: http://lists.mysql.com/dotnet/104
Message-Id: <200410282039.i9SKd9O9015445@mail.mysql.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Ok.  Just file a bug report if you think something is weird or a problem.

> -----Original Message-----
> From: Darren Hill [mailto:darren@stripped]
> Sent: Thursday, October 28, 2004 3:38 PM
> To: 'Reggie Burnett'; dotnet@stripped
> Subject: RE: Connection Pooling
> 
> Unfortunately Reggie, I haven't delved into it too much.  I'd like to
> get to the core of the problem before actually 'claiming' it's a bug.
> 
> Essentially, I was able to call GetParameter("@username" username)
> before (using ByteFX), and never needed to specify its type.  But using
> the MySql.Data it claims the input parameter is of wrong type, and I
> noticed it was trying to cast it to a Decimal.  So, I simply overloaded
> the GetParameter method to allow me to specify the type and all is well.
> 
> Darren Hill
> darren@stripped
> Tel: 416-410-1154 ext. 2
> Toll Free: 866-410-1154 ext. 2
> Fax: 905-873-6685
> 
> 
> -----Original Message-----
> From: Reggie Burnett [mailto:reggie@stripped]
> Sent: October 28, 2004 4:27 PM
> To: darren@stripped; dotnet@stripped
> Subject: RE: Connection Pooling
> 
> Can you further explain the GetParameter issue?
> 
> > -----Original Message-----
> > From: Darren Hill [mailto:darren@stripped]
> > Sent: Thursday, October 28, 2004 2:46 PM
> > To: dotnet@stripped
> > Subject: RE: Connection Pooling
> >
> > Thanks,
> >
> > I've uploaded the changes necessary to use AppBlocks 3.0 with
> > MySql.Data.  Enjoy!
> >
> > Note.  When using GetParameter, ensure you specific the DbType  [ie.
> > GetParameter("?username", username, DbType.String) ] you are using.  I
> > never had to do this for the ByteFX version, but for some reason, if
> you
> > leave out the specification, it defaults to Int32.
> >
> > Darren Hill
> > darren@stripped
> > Tel: 416-410-1154 ext. 2
> > Toll Free: 866-410-1154 ext. 2
> > Fax: 905-873-6685
> >
> >
> > -----Original Message-----
> > From: Reggie Burnett [mailto:reggie@stripped]
> > Sent: October 28, 2004 3:32 PM
> > To: darren@stripped; 'Guy Platt'
> > Cc: dotnet@stripped
> > Subject: RE: Connection Pooling
> >
> > Good work Darren
> >
> > > -----Original Message-----
> > > From: Darren Hill [mailto:darren@stripped]
> > > Sent: Thursday, October 28, 2004 9:26 AM
> > > To: 'Guy Platt'
> > > Cc: dotnet@stripped
> > > Subject: RE: Connection Pooling
> > >
> > > Guy,
> > >
> > > There's a workspace at godotnet.com.  Its tremendous, and I've
> > extended
> > > it to use Reggie's connector.  Let me know if you interested and
> I'll
> > > send you the source.  I'm going to contribute it to the workspace
> > soon.
> > >
> > > Darren Hill
> > > darren@stripped
> > > Tel: 416-410-1154 ext. 2
> > > Toll Free: 866-410-1154 ext. 2
> > > Fax: 905-873-6685
> > >
> > >
> > > -----Original Message-----
> > > From: Guy Platt [mailto:guy.platt@stripped]
> > > Sent: October 28, 2004 2:37 AM
> > > To: darren@stripped
> > > Cc: dotnet@stripped
> > > Subject: Re: Connection Pooling
> > >
> > > This sounds interesting using the ApplicationBlocks with MySql.  Did
> > you
> > >
> > > convert the MSSQL ApplicationBlocks to use with MySQL, and if so, is
> > it
> > > something you can share with the list?
> > >
> > > regards
> > >   Guy
> > >
> > >
> > > Darren Hill said the following wise words on 2004-10-28 1:25 AM:
> > >
> > > >Reggie,
> > > >
> > > >I'm using ApplicationBlocks combined with your ByteFX (version
> > > >0.7.6.15073).  This ensure I'm opening and closing connection
> > > >efficiently and effectively.  However, the pool doesn't reuse,
> > release
> > > >connections and gets exhausted at 1000 open connections.  So it
> must
> > be
> > > >a bug in the Connector.
> > > >
> > > >Darren Hill
> > > >darren@stripped
> > > >Tel: 416-410-1154 ext. 2
> > > >Toll Free: 866-410-1154 ext. 2
> > > >Fax: 905-873-6685
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > --
> > > MySQL on .NET Mailing List
> > > For list archives: http://lists.mysql.com/dotnet
> > > To unsubscribe:
> > http://lists.mysql.com/dotnet?unsub=reggie@stripped
> >
> >
> > --
> > MySQL on .NET Mailing List
> > For list archives: http://lists.mysql.com/dotnet
> > To unsubscribe:
> http://lists.mysql.com/dotnet?unsub=darren@stripped
> >
> >
> >
> >
> > --
> > MySQL on .NET Mailing List
> > For list archives: http://lists.mysql.com/dotnet
> > To unsubscribe:
> http://lists.mysql.com/dotnet?unsub=reggie@stripped
> 
> 
> 
> 
> --
> MySQL on .NET Mailing List
> For list archives: http://lists.mysql.com/dotnet
> To unsubscribe:    http://lists.mysql.com/dotnet?unsub=reggie@stripped