List:MySQL and .NET« Previous MessageNext Message »
From:Darren Hill Date:October 28 2004 8:37pm
Subject:RE: Connection Pooling
View as plain text  
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=1
> 
> 
> --
> MySQL on .NET Mailing List
> For list archives: http://lists.mysql.com/dotnet
> To unsubscribe:
http://lists.mysql.com/dotnet?unsub=1
> 
> 
> 
> 
> --
> MySQL on .NET Mailing List
> For list archives: http://lists.mysql.com/dotnet
> To unsubscribe:
http://lists.mysql.com/dotnet?unsub=1



Thread
Connection PoolingDarren Hill26 Oct
  • RE: Connection PoolingDarren Hill27 Oct
    • Re: Connection PoolingReggie Burnett27 Oct
      • RE: Connection PoolingDarren Hill28 Oct
        • Re: Connection PoolingReggie Burnett28 Oct
          • RE: Connection PoolingDarren Hill28 Oct
            • Stable snapshot... where is it?Joshua Mouch28 Oct
              • Re: Stable snapshot... where is it?Reggie Burnett28 Oct
            • RE: Connection PoolingDarren Hill28 Oct
              • RE: Connection PoolingDarren Hill28 Oct
                • RE: Connection PoolingJordan Sparks28 Oct
                • Re: Connection PoolingReggie Burnett28 Oct
            • Re: Connection PoolingReggie Burnett28 Oct
              • RE: Connection PoolingDarren Hill28 Oct
        • Re: Connection PoolingGuy Platt28 Oct
          • RE: Connection PoolingDarren Hill28 Oct
            • RE: Connection PoolingReggie Burnett28 Oct
              • RE: Connection PoolingDarren Hill28 Oct
                • RE: Connection PoolingReggie Burnett28 Oct
                  • RE: Connection PoolingDarren Hill28 Oct
                    • RE: Connection PoolingReggie Burnett28 Oct