[Mono-list] MySQL Connector/NET vs Mono

Bernhard Herzog schwimmlehrer at gmail.com
Wed Sep 14 18:36:31 EDT 2005


About the problem with Sockets you describe in your Weblog (http://www.bytefx.com/blog/CommentView,guid,a0723c16-2a4c-4b64-b48a-3053da0f9e9c.aspx):
The problem in 1.0.4 was that WaitOne was called, which basically blocked the ThreadPool for 15 seconds if there were more than 25 concurrent requests, right?

Is this timeout really that important? What if I could set the timeout to infinite (0?) in the connection string and then instead of using BeginConnect the mySQL connector would use synchrounous connect. Wouldn't then everybody be happy in Mono land?

Best Regards
Bernhard

  ----- Original Message ----- 
  From: Reggie Burnett 
  To: 'Bernhard Herzog' ; 'Daniel Morgan' ; Mono-list at lists.ximian.com 
  Sent: Thursday, September 08, 2005 8:08 PM
  Subject: RE: [Mono-list] MySQL Connector/NET vs Mono


  That is the define however, as you have discovered, Unix sockets have not been tested recently.



----------------------------------------------------------------------------
    From: mono-list-bounces at lists.ximian.com [mailto:mono-list-bounces at lists.ximian.com] On Behalf Of Bernhard Herzog
    Sent: Thursday, September 08, 2005 12:52 PM
    To: Reggie Burnett; 'Daniel Morgan'; Mono-list at lists.ximian.com
    Subject: Re: [Mono-list] MySQL Connector/NET vs Mono


    Aha, that's good news. I just downloaded the source and have seen that there is support for Unix Sockets, right?

    What do I need to compile? Define __MonoCS__? I get this error:

    mysqlclient\SharedMemoryStream.cs(94) error CS0030: Cannot convert type 'int' to 'System.UIntPtr'
    mysqlclient\SharedMemoryStream.cs(154) error CS0030: Cannot convert type 'int' to 'System.UIntPtr'

    Best Regards
    Bernhard
      ----- Original Message ----- 
      From: Reggie Burnett 
      To: 'Daniel Morgan' ; Mono-list at lists.ximian.com 
      Sent: Thursday, September 08, 2005 7:32 PM
      Subject: RE: [Mono-list] MySQL Connector/NET vs Mono


      Win32 specific code was added to the connector to work around limitations in the Socket class.  I am not yet shipping Mono tested binaries (though I am working on including this) and so it was an oversight that 1.0.5 shipped broken on Mono.  I will correct it in the next release.

      MySQL *is not* abandoning Mono.  In fact, I have talked with Miguel about getting Connector/Net shipping with Mono.

      -Reggie



------------------------------------------------------------------------
        From: mono-list-bounces at lists.ximian.com [mailto:mono-list-bounces at lists.ximian.com] On Behalf Of Daniel Morgan
        Sent: Thursday, September 08, 2005 12:08 PM
        To: Mono-list at lists.ximian.com
        Subject: Re: [Mono-list] MySQL Connector/NET vs Mono


        If people are having problems running the MySQL Connector/NET on Mono, people could report these bugs to MySQL's bug database or wherever it is or a message to their public forum or mailing list to let them know.

        However, I do believe "we" should continue to maintain ByteFX.Data since it works with Mono and it is distributed with Mono.  Nobody has stepped up to maintain it.  Any takers?

        When having problems, it is usually good to include version info too:
        What version of Mono?  Version of the MySQL database?  Version of MySQL Connector/Net?  Operating System/Processor?

        I have read that ByteFX.Data fails to run on newer 4.x and 5.0 databases.



        Martin Hinks <mhinks at gmail.com> wrote:
          Hi,

          I had lots of problems using the MySQL Connector under Mono and
          eventually reverted to using ByteFX - supported or not!

          However, If Joe's way works, then that is cool.

          On 9/8/05, Joe Audette wrote:
          > I have been using the MySQL Connector in mono for
          > quite a while with no trouble at all in my project at
          > http://www.mojoportal.com
          > 
          > I compile it on Windows and deploy it to the bin
          > folder of my web on linux and it works fine for me. I
          > don't think I am using the very latest version of the
          > Connector though, I think I am only 1 version behind
          > the current Connector release.
          > 
          > Hope it helps,
          > 
          > Joe
          > 
          > --- Brion Vibber wrote:
          > 
          > > The documentation at
          > > http://www.mono-project.com/M ySQL strongly suggests
          > > that MySQL's Connector/NET should be used in
          > > preference to the ByteFX
          > > driver that ships with Mono.
          > >
          > > However the current release of MySQL Connector/NET
          > > (1.0.5) appears to be
          > > Windows-specific; it attempts to make native calls
          > > into some ws2_32.dll
          > > and fails to work on Mono on eg Linux or Mac OS X.
          > >
          > > Do we know if this is just a packaging bug (MySQL
          > > forgot to build a
          > > portable-friendly binary?) or if MySQL is
          > > specifically abandoning Mono
          > > and cross-platform compatibility?
          > >
          > > Should Mono's online documentation be updated to
          > > reflect this?
          > >
          > > -- brion vibber (brion @ pobox.com)
          > > > _______________________________________________
          > > Mono-list maillist - Mono-list at lists.ximian.com
          > > http://lists.ximian.com/mailman/listinfo/mono-list
          > >
          > 
          > 
          > joe_audette [at] yahoo dotcom
          > http://www.joeaudette.com
          > http://www.mojoportal.com
          > _______________________________________________
          > Mono-list maillist - Mono-list at lists.ximian.com
          > http://lists.ximian.com/mailman/listinfo/mono-list
          > 


          -- 
          Martin Hinks
          http://www.m-s-d.net
          _______________________________________________
          Mono-list maillist - Mono-list at lists.ximian.com
          http://lists.ximian.com/mailman/listinfo/mono-list

        __________________________________________________
        Do You Yahoo!?
        Tired of spam? Yahoo! Mail has the best spam protection around 
        http://mail.yahoo.com 



--------------------------------------------------------------------------


      _______________________________________________
      Mono-list maillist  -  Mono-list at lists.ximian.com
      http://lists.ximian.com/mailman/listinfo/mono-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-list/attachments/20050915/5fcc0824/attachment.html


More information about the Mono-list mailing list