Sun Connector for MySQL (Beta)

A new version of the MySQL SDBC driver, code-named Sun Connector for MySQL, formerly known as MySQL Native Driver, is available for download. This Beta release supersedes the previous Alpha version.

The driver can be used in OpenOffice.org 3.1 to connect to a MySQL server, versions 5.1 and later. When using the Sun Connector for MySQL, you have the following advantages over using the MySQL Connector/ODBC or MySQL Connector/J:

Easy installation through the OpenOffice.org Extension Manager
Seamless integration into OpenOffice.org
You can work on multiple MySQL schemata (databases) simultaneously
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)
No need for a Java Runtime Environment (JDBC)

The driver is made available as an OpenOffice.org extension, to be found in the OpenOffice.org Extension Repository at the following location:

http://extensions.services.openoffice.org/project/mysql_connector

It comes in versions for Windows, Linux Intel 32 and 64 bit, Solaris Sparc, Solaris Intel, and Mac OS X Intel.

There currently is 1 known issue in Sun Connector MySQL (Beta), which will be fixed until the final release:

On windows, the extension might crash on systems which have an incompatible version of libmysql installed, and made available in the PATH

Please note that the Beta version is not recommended to be used in a production environment, or on systems with critical data. The final version, having production quality, is planned for September 2009.

The source code of the extension is currently hosted in the child workspace mysqlnative, in the new module mysqlc. You can build the CWS in a usual OpenOffice.org build environment, but need to have MySQL installed on your system (using the new configure switch --with-system-mysql), or a Connector/C installation (using the new configure switch --with-libmysql-path).

An overview about the Beta release, as well as a quick start, can be found in our wiki at

http://wiki.services.openoffice.org/wiki/Database/Drivers/MySQL_Native/Beta

Please give the extension a try, and report your findings, good or bad, to our project's mailing list, users@dba.openoffice.org.

Enjoy!

tags:

Comments