How to install the new MySQL JDBC driver on Coldfusion MX7
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