Getting ColdFusion MX 7 to work with MySql 4.1

[chrenzel]

Hello out there. I'm having some problems with configuring ColdFusion
MX 7 with MySql 4.1.


Right now I downloaded the Connector J v. 3.0.17 files from MySql and
tried to get them to work, but that didn't work. This is the error
message that I get from the ColdFusion Administrator. I extracted the
files to this directory


C:\CFusionMX7\wwwroot\WEB-INF\lib


This is a copy of the configuration of the Data Source:


CF Data Source Name: curves


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


Driver Class: com.mysql.jdbc.Driver


Driver Name: mysql-connector-java-3.0.17-ga-bin.jar


And this is the error that I get when the datasource is verified.


Connection verification failed for data source: curves
java.sql.SQLException: No suitable driver available for curves, please
check the driver setting in resources file, error: null
The root cause was that: java.sql.SQLException: No suitable driver
available for curves, please check the driver setting in resources
file, error: null


If anyone has any help it would be very much appreciated.

[mxstu]

1. Did you restart the ColdFusion server after placing the jar file in the
C:\CFusionMX7\wwwroot\WEB-INF\lib directory?
2. Did you extract only the "mysql-connector-java-3.0.17-ga-bin.jar" file and
place it in the C:\CFusionMX7\wwwroot\WEB-INF\lib directory?
3. Do you have more than one version of the mySQL connector jar in the
C:\CFusionMX7\wwwroot\WEB-INF\lib directory?

[BKBK]

1. The current MySQL Connector/J driver is mysql-connector-java-3.1.11-bin.jar

[url]http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-3.1.11.zip/f[/url]
rom/pick.

2. As Mxstu suggested, delete any old mysql-connector-java-*-bin.jar
files from C:\CFusionMX7\wwwroot\WEB-INF\lib. Extract the zip file you
downloaded and copy mysql-connector-java-3.1.11-bin.jar into this directory.

3. Restart the Coldfusion MX server service.

4. Add a new datasource in the Coldfusion as you did before.

[mxstu]

> 1. The current MySQL Connector/J driver is mysql-connector-java-3.1.11-bin.jar

Yes, the 3.0.17 jar is a bit older, but there are issues with version 3.1.11
+ the Log4JLogger class and MX6 / MX7, so I wouldn't use version 3.1.11. I've
had success with both 3.0.17 and 3.1.9, so I would recommend trying one of
those first, just to get started. You can always find a newer version once
things are up and running.