Personal tools

WASCEWithMySQL

From OpenLaszlo

[edit]

How to add the MySQL database drivers to IBM WebSphere Community Edition (WASCE) 2.1.1.1

2009-JAN-04

These are my notes, written as I was installing the MySQL database drivers in WASCE (running on Linux), in case they're useful for other people.


1. Download the MySQL drivers to your local PC: 

 http://dev.mysql.com/downloads/connector/j/5.1.html

I grabbed the .tar.gz version. Version 5.1.7 in my case (filename: "mysql-connector-java-5.1.7.tar.gz").


2. Extract the .jar file on your local PC. 

 $ tar xvzp --strip-components 1 -f mysql-connector-java-5.1.7.tar.gz mysql-connector-java-5.1.7/mysql-connector-java-5.1.7-bin.jar

This gave me the "mysql-connector-java-5.1.7-bin.jar" file.


3. Log in to the WASCE web console from your local PC: 

 http://localhost:8080/console/


4. Add the MySQL drivers to WASCE: 

 Services -> Repository

 File: Browse to the .jar file just extracted.  When you do this, most of the info below should be automatically filled out
 Group: mysql
 Artifact: mysql-connector-java
 Version: 5.1.7-bin
 Type: jar
 

 Click Install.

After you click install, no visual feedback is given, and the fields are all reset.


5. Check that the drivers are now in WASCE 

 Services -> Repository

If you scroll down the list of repository entries on the same page, you should notice the MySQL driver is now there: 

 mysql/mysql-connector-java/5.1.7-bin/jar

Clicking on it should show you the following entry (or similar): 

Usage for mysql/mysql-connector-java/5.1.7-bin/jar

To use mysql/mysql-connector-java/5.1.7-bin/jar in an application or a module, add a dependency element under dependencies in environment element in its deployment plan as shown below:

    <environment>
        ...
        <dependencies>
            ...
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.7-bin</version>
                <type>jar</type>
            </dependency>
       </dependencies>
    </environment>

In theory, you should be ok to use this driver.

Retrieved from "http://wiki.openlaszlo.org/WASCEWithMySQL"