How to install the new MySQL JDBC driver on Coldfusion MX7


How to install the new MySQL JDBC driver on Coldfusion MX7

Posted by Luis Majano
Nov 29, 2005 00:00:00 UTC
I needed to upgrade my coldfusion JDBC drivers for MySQL since I upgraded my release to 5.0 and here is the little how to.

1) Donwload the JDBC drivers from here:

http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-3.1.11.zip/from/pick

2) Extract the archive and copy the following file:

mysql-connector-java-3.1.11-bin.jar

to the following destination:

J2EE

{j2ee path}/servers/lib

If you want it available to all servers or just for the Coldfusion app then:

{cfmx instance path}/cfusion-ear/cfusion-war/WEB-INF/lib

Standalone

{cfmx path}/wwwroot/WEB-INF/lib

3) Restart your CFMX instance or server.

4) Go to your Datasources in your coldfusion administrator to register a new datasource:

Name: {Your datasource name}

JDBC URL: jdbc:mysql://{your host}:3306/{your database}

Driver Class: com.mysql.jdbc.Driver

Driver Name: MySQL 5.0

User Name: {Username}

Password: {Your Password}

And that is it.

 


Luis Majano

Please also note that if you wich BLOB or CLOB support you will need to go to the More Options and check the checkboxes.

Tony

What about Apache 2

Luis Majano

I don't understand your question Tony. The driver installs on the CFMX server. You can then register the datsources needed, regardless of whether CFMX is running on Apache or IIS or any other web server

Site Updates

Entry Comments

Archives

Entries Search