Thursday, January 4, 2007

MySQL Connector/Net 5.0.3 GA has been released

MySQL Connector/Net 5.0.3 GA has been released. MySQL Connector/Net is an all-managed ADO.Net provider for MySQL. This release is suitable for production use with MySQL versions 4 and higher.

It is now available in source and binary form from the Connector/Net download pages at [dev.mysql.com] and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose another download site.)

Changes since 5.0.2

Bugs fixed
Bug #23687 Deleting a connection to a disconnected server causes a failed assertion
Bug #24565 Inferring DbType fails when reusing commands and the first time the value is null
Bug #24661 mysql-connector-net-5.0.2-beta Driver.IsTooOld() Error....
Bug #23905 Stored procedure usages is not thread safe
Bug #25033 Exception raised/ HANG if no SELECT privileges granted for stored procedure call
[this is a correction; a previous change log entry indicated that Connector/Net
no longer required select privs on mysql database. This is not true and select privs
are required. This will be fixed when the server exposes procedure parameters via
information schema.]
Bug #25013 Return Value parameter not found
Bug #25151 Reading from the stream has failed Exception in MySQL Connector 5.0.2
Bug #22400 Nested transactions

Other changes
SSL now working. [Thanks Alessandro Muzzetta]
Fixed ViewColumns GetSchema collection
Improved CommandBuilder.DeriveParameters to use the procedure cache if possible

* NEW CONNECTION STRING OPTION *
We have added a new connection string option named 'Ignore Prepare'. It is
a boolean option and its default value is true. This option, when true,
instructs the provider to ignore any calls to MySqlCommand.Prepare(). We
decided to do this because we have discovered some inconsistencies with
server side prepared statements which can lead to incorrect or damaging
results. If you are sure you want to use server-side prepared statements,
then you can add 'ignore prepare=false' to your connection string and it
will behave as before.

Highlights of the 5.0.x Connector/Net releases: 

  • Support for ADO.Net 2.0 interfaces and subclasses
  • Re-architected to improve speed and flexibility
    The internals of the provider have been improved to allow column values to
    be retrieved without boxing in many cases. Also, the internal changes have
    enabled the future inclusion of embedded and client library support. 
  • Implemented Usage Advisor
    The Usage Advisor first appeared in Connector/J. We have now implemented
    that feature in Connector/Net. Enabling it causes the provider to check
    both your queries and how you read the results and report to you if it
    thinks you are using the provider in an inefficient manner. It checks such
    things as using a query without an index, not reading all the columns or
    rows from a resultset, etc. 
  • Implemented asynchronous query methods
    The MySqlCommand object now supports asynchronous queries. This is
    implemented using the BeginExecuteNonQuery and EndExecuteNonQuery methods.
    BeginExecuteReader and EndExecuteReader are now included. 
  • Implemented stored procedure metadata caching
    We now cache the metadata that is retrieved during stored procedure and
    stored function execution. This cache data is used for subsequent
    executions of that stored routine. 
  • Added PerfMon hooks
    This release includes PerfMon hooks to monitor stored procedure cache hits
    and misses. We are looking at adding additional hooks in the first beta
    release. 
  • Removed use of SharpZipLib library
    We have replaced use of the SharpZipLib library with the deflate support
    available with .NET 2.0.


Support for embedded server and client library has been removed
For those of you that have seen my presentations on 5.0, we decided to
remove these features to help get 5.0 out the door more quickly. These
features will reappear in a later version of the product.

33 comments:

  1. Japanese Nude

    Free Sample

    ReplyDelete
  2. nice mysql connector

    ReplyDelete
  3. MySQL Connector/J is the official JDBC driver for MySQL. It converts between JDBC and the network protocol that MySQL understands

    ReplyDelete
  4. MySQL Connector/Net 5.0.3 GA has been released. MySQL Connector/Net is an
    all-managed ADO.Net provider for MySQL. This release is suitable for
    production use with MySQL versions 4 and higher.

    ReplyDelete
  5. Hi, I'm trying to find out why does this error come up. I'm trying to execute a query from a Java web application using a Tomcat server. If I execute the quer
    SELECT * FROM ebz_survey WHERE lu_user='1'
    I have no problem. However, if I execute the query:
    SELECT * FROM ebz_survey_question WHERE lu_user='@U'
    it tells me
    Select Statement execution failed: SELECT * FROM ebz_survey_question WHERE lu_user='1'
    but if I execute the query directly into the MySQL console, it doesn't show that error and executes the query without a problem. Can anyone help me?

    ReplyDelete
  6. Custom Research PaperMarch 21, 2009 at 12:38 PM

    Easy installation through the OpenOffice.org Extension Manager.
    Seamless integration into OpenOffice.org.
    No need to go through an additional Connector installation routine (ODBC/JDBC)
    No need to configure or register an additional Connector (ODBC)
    No need to install or configure a driver manager (ODBC)

    ReplyDelete
  7. Healthy Weight Loss TipsApril 2, 2009 at 11:51 AM

    MySQL Connector/Net enables developers to easily create .NET applications that require secure, high-performance data connectivity with MySQL. It implements the required ADO.NET interfaces and integrates into ADO.NET aware tools. Developers can build applications using their choice of .NET languages. MySQL Connector/Net is a fully-managed ADO.NET driver written in 100% pure C#.

    ReplyDelete
  8. Online Casino GuideApril 2, 2009 at 6:03 PM

    Hi,

    MySQL Connector/Net 5.0.3 GA has been released. MySQL Connector/Net is an
    all-managed ADO.Net provider for MySQL. This release is suitable for
    production use with MySQL versions 4 and higher.

    ReplyDelete
  9. Louisville Electric Pet FencingApril 3, 2009 at 3:10 PM

    dotConnect for MySQL, formerly known as MyDirect .NET, is an enhanced data provider for MySQL that builds on ADO.NET technology to present a complete solution for developing MySQL-based database applications. As part of the Devart database application development framework, dotConnect for MySQL offers both high performance native connectivity to the MySQL database and a number of innovative development tools and technologies.

    ReplyDelete
  10. Bellissima Sim Diet PillsApril 5, 2009 at 8:36 PM

    UniDirect .NET offers universal access to data of different databases for the Microsoft .NET Framework. It supports most of major database servers, including Microsoft SQL Server, Microsoft Access, Oracle, DB2, MySQL, PostgreSQL, InterBase, and Firebird. Other servers can be accessed through their ADO.NET, OLE DB and ODBC providers.

    ReplyDelete
  11. Mercedes Repair ServicesApril 13, 2009 at 12:02 AM

    Every time I install 5.03 connector and visual studio plugin I get
    Connector/Net is not properly installed and configured. MySQL Tools for Visual Studio will not function correctly.

    Before I did this reinstalling everytime I connected to my hosts mySQL from within my VS 2005 I got this error...
    Packets larger than max_allowed_packet are not allowed.

    I dont get the above when using mysql locally.

    ReplyDelete
  12. lovelythinking
    lovely making
    lovely arguing

    ReplyDelete
  13. great thinking
    love u all

    ReplyDelete
  14. I am puzzled why my ASP.NET code works with MS SQL Server but not
    MySQL.

    ReplyDelete
  15. Pacquiao Hatton LiveMay 1, 2009 at 10:21 AM

    Really? I just want you to know that you have done a very clear and well written tutorial, I found it relatively easy to follow compared to similar style walkthroughs other bloggers have done! Keep it up webmaster!

    ReplyDelete
  16. conservatory furnitureMay 19, 2009 at 8:11 PM

    Defining and storing the MySQL Connection String properly is an important ... be provided for data loading using MySQL Connector/NET 5.0.3 database driver. ...

    ReplyDelete
  17. designer handbag replicasMay 20, 2009 at 1:24 PM

    MySQL Connector/Net 5.0.3 GA has been released. MySQL Connector/Net is an
    all-managed ADO.Net provider for MySQL. This release is suitable for
    production use with MySQL versions 4 and higher.

    ReplyDelete
  18. MySQL Connector/Net 5.1.4 a new version of the all-managed . ... Added the Default Command Timeout connection string option to allow DDEX users to set ...

    ReplyDelete
  19. copywriting servicesMay 23, 2009 at 8:57 PM

    Usage Advisor has been implemented. The Usage Advisor checks your queries and will report if you are using the connection inefficiently.

    ReplyDelete
  20. quality inn sweepstakesMay 24, 2009 at 4:00 PM

    When using execute non query the exception regarding a null key or parameter may be avoided by directly accessing the value property of the return value parameter set earlier rather than going through the command's Parameters property to get the desired return value parameter IF parameters.Add adds the parameter by reference. if it only copies the parameter then the original return value parameter variable will not have been affected during the execute non query.

    ReplyDelete
  21. MySQL Connector/Net is an
    all-managed ADO.Net provider for MySQL. This release is suitable for
    production use with MySQL versions 4 and higher.

    ReplyDelete
  22. # Support for ADO.Net 2.0 interfaces and subclasses
    # Re-architected to improve speed and flexibility

    ReplyDelete
  23. best weight loss pillsJune 30, 2009 at 11:34 AM

    The information will really going to be useful for people who uses MySQL. It is nice to read something like this because learned something new.

    ReplyDelete
  24. MySQL ConnectorNet 503 clean all the trashes! Since I use MySQL versions 4, i can this released MySQL. Thanks for sharing. It will be very help for having improvement on CommandBuilder.
    <a href="http://www.inanch.com/">hair extensions</a>

    ReplyDelete
  25. Mercedes Benz SLS RoadsterJuly 12, 2009 at 4:16 PM

    Great post - Just subscriped to your blog's RSS feed.. Thanks The Car Lover

    ReplyDelete
  26. Good release. Thanks.

    ReplyDelete
  27. acai berry colon cleanseJuly 20, 2009 at 9:23 PM

    Great writeup.. I guess you summed it all up.. Cheers

    ReplyDelete
  28. Great writeup.. I guess you summed it all up.. Cheers

    ReplyDelete
  29. medical billing practice management softwareSeptember 9, 2009 at 6:20 PM

    I posted your article to my myspace profile.


    Regards

    Mili

    ReplyDelete
  30. Super Website...

    [...] that is the end of this article. Here you’ll find some sites that we think you’ll appreciate, just click the links over[...]...

    ReplyDelete
  31. Websites You Should Visit...

    [...]very few websites that happen to be detailed below, from our point of view are undoubtedly well worth checking out[...]...

    ReplyDelete