Coldfusion Connector/J Setup (Recommended for All)

1. Remove mysql-connector*.jar from C:\ColdFusion8\lib\.
2. Download the java based MySQL Connector/J driver as ZIP format. Make sure you use the JAR file from the root of the ZIP file.
3. Extract the ZIP file to it’s own folder. The root folder will contain the JAR file needed for the next step.
4. Copy new mysql-connector-java-*-bin.jar to C:\ColdFusion8\lib\.
5. Restart the Coldfusion Application service.

Zip file and highlighted file needed:

Datasource Setup:

JDBC URL: jdbc:mysql://localhost:3306/integrator

Driver Class: com.mysql.jdbc.Driver

References

http://dev.mysql.com/downloads/connector/

http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19170&sliceId=2