Time for action — installing MySQL connector/J 5.1

You can download the Connector/J 5.1 JDBC driver from MySQL Developer Zone. Just follow the simple steps:

  1. Open your web browser and go to http://dev.mysql.com/downloads/ connector/j/5.1.html. Scroll down until you locate the Source and Binaries (zip) Download link:
    Time for action — installing MySQL connector/J 5.1Roller installation, on WindowsMySQL JDBC driver
  2. Click on this link to start the download. Select the Save File radio button in the Opening mysql-connector-java-5.1.7.zip dialog and click on the OK button.
  3. Once the file has been downloaded, navigate to the directory where you downloaded the file.
  4. Unzip the file and double-click on the mysql-connector-java-5.1.7 folder. Look for the mysql-connector-java-5.1.7.jar file, right-click on it and select Copy:
    Time for action — installing MySQL connector/J 5.1Roller installation, on WindowsMySQL JDBC driver
  5. Now go to Tomcat's lib folder (C:\Program Files\Apache Software Foundation\Tomcat 6.0\lib), right-click on an empty space in Windows Explorer's right panel and select Paste from the pop-up menu to paste the mysql-connector-java-5.1.7.jar file:
    Time for action — installing MySQL connector/J 5.1Roller installation, on WindowsMySQL JDBC driver
  6. You can close Windows Explorer and your web browser now.

What just happened?

In the previous exercise, you downloaded MySQL Connector/J 5.1—a JDBC driver that Apache Roller uses to communicate with the MySQL database that holds all the information related to blogs, users, comments, and configuration parameters. This file contains all the Java code needed to communicate with the MySQL database server, and Roller does it for you automatically. Now let's see how to install Roller on Tomcat.