Application Server Solutions for Microsoft IIS and ASP.NET
       solutions   products   partners   company   support   downloads         store
BlueDragon Self-Help: FAQ
Back to Search >  Back to Search Results

Faq ID 216
Product BlueDragon
Category Admin Console, Administration, DataSource
Question How can I define a MySQL datasource?
Answer MySQL is supported in all BlueDragon editions, either via JDBC or ODBC.

In the Server JX, J2EE, and .NET editions, an option is offered in the datasource configuration page of the administration console. In all editions, a MySQL datasource can be defined using ODBC.

In all cases, we do not provide the MySQL database drivers with BlueDragon. MySQL AB restricts redistribution of the MySQL drivers with other products, though the database itself is open source. For more information, see the MySQL Licensing Policy for more information.

But installing it is simple enough, whether to use ODBC or JDBC. The following steps describe first using the ODBC and then the JDBC driver.

Steps to using the MySQL ODBC Driver for all BlueDragon editions

  • Download the latest MySQL Connector/ODBC driver from the MySQL web site:
    http://www.mysql.com/products/connector/odbc/
    1. After reviewing information on the page, choose the link for the latest stable release.
    2. On the page that follows, scroll down to the download links.
    3. Choose the download appropriate to your platform (choose "pick a mirror", then any listed site, and download using either http or ftp as you prefer).
    4. For Windows users, run the installer and proceed to define an ODBC datasource using the Windows ODBC control panel. For other users, consider using the JDBC driver discussed below, or follow the instructions offered on the MySQL site for installing and using the ODBC driver.
    5. Once an ODBC datasource has been defined, view the "data sources" page in the BlueDragon Admin console and choose the "ODBC Refresh" button below the list of any current datasources. BlueDragon will refresh the list with any ODBC datasources you have defined.

Steps to using the MySQL Driver for Server JX and J2EE editions

  • Download the latest MySQL Connector/J driver from the MySQL web site:
    http://www.mysql.com/products/connector-j/index.html
    1. After reviewing information on the page, choose the link for the latest stable release.
    2. On the page that follows, scroll down to "Sources and Binaries".
    3. Choose the "download" link. Windows users will likely prefer to choose the zip file format, while Linux, Solaris, Mac and other users may prefer the tar.gz format.
    4. The next steps (to extract the driver from the compressed file) will vary depending on the file type chosen, your operating system, your browser, and your installed support for unzip-type programs. The files within the compressed file (zip or tar.gz file) are stored within it in a directory such as mysql-connector-java-3.0.10-stable (your version of the driver may be slightly different).
    5. You can choose to extract the files from the compressed file to a directory of that same name (mysql-connector-java-3.0.10-stable) on your system. But of all the files within the compressed file, the only one that really matters for use with BlueDragon is the actual driver jar file, which for the 3.0.10 version would be named mysql-connector-java-3.0.10-stable-bin.jar. You may choose to extract just that file, and place it on your file system within the BlueDragon directory as discussed in the following sections.

  • Configure BlueDragon to recognize the driver
  • The steps to configure BlueDragon to recognize the MySQL driver will vary from product to product (Server, Server JX, .NET, and J2EE):

    • In the Server (non-Windows) or Server JX editions, simply save the jar file (from above) as mysql.jar in the lib directory under BlueDragon, such as:
      C:\BlueDragon_Server_JX_61\lib\mysql.jar
      Then restart BlueDragon.
    • In the J2EE edition, you can leave the file named as it was on download, but simply place it in the WEB-INF/lib directory of the web application.
    • It's also possible in the Server JX edition to place the jar file anywhere in the file system and use its original name. Simply go to the "BlueDragon Server>vm classpath" page of the administration console and add the path to the JDBC driver JAR file. Then restart BlueDragon.
    After making these changes and restarting BlueDragon, you can then define MySQL datasources using the provided "MySQL" option on the drop-down for driver types in the BlueDragon administration console.
For the .NET edition, follow the steps outlined in the admin console page for adding a MySQL datasource.

We encourage you to review the MySQL licensing policy before using their JDBC driver (or the MySQL database) with BlueDragon, as there are circumstances where they require you to purchase a commercial license or risk having your software "infected" by the GPL:

http://www.mysql.com/products/licensing
If you're looking for a database that--unlike MySQL--can be used for free in all circumstances, we recommend that you consider PostgreSQL:
http://www.postgresql.org/
The PostgreSQL JDBC driver is bundled with all BlueDragon editions.



   
company media information terms of use privacy policy contact us