Coldfusion MX 7.x and MYSQL - again

[morse101]

Hi,

would welcome help in connecting Coldfusion MX 7.1 to MYSQL on a
system running:


XP Service Pack 2

Coldfusion MX 7.1 using the inbuilt server for development


I am following the instructions in Coldfusion TechNote 6ef0253 but
without success. I suspect it is me being very stupid but at present
I cannot see the error of my ways.Thus using Data Sources via
Administrator my 'set up' for connection is :

Screen 1

Data Source name javamysql

Drive 'selected' other


[color=blue:fbe8f6c0ed]Screen 2[/color:fbe8f6c0ed]

C.F Data Source name : javamysql

JDBC URL : jdbc:mysql://127.0.0.1:3306/mysql

Driver Class : com.mysql.jdbc.Driver

Driver Name :
mysql-connector-java-3.2.0-alpha-bin.jar

or

mysql-connector-java-3.1.1.0-bin.jar


User Name : set to MYSQL user name

Password : set to MYSQL user password


Both mysql-connector-java ..... files are in
C:\ColdfusionMX7\wwwroot\lib

and

Java Run Time Environment = JRE 1.5.0_04



Every attempt to make the connection gives the following error
message


[color=red:fbe8f6c0ed]Connection verification failed for data source:
javamysql
java.sql.SQLException: No suitable driver available for javamysql,
please check the driver setting in resources file, error: null
The root cause was that: java.sql.SQLException: No suitable driver
available for javamysql, please check the driver setting in resources
file, error: null[/color:fbe8f6c0ed]

Any and all help much appreciated


M

[mxstu]

>Both mysql-connector-java ..... files are in C:\ColdfusionMX7\wwwroot\lib
I'm not running MX7, but I think you should only have one version of the MySQL
Connector/J jar in the directory or MX may get confused about which one to use.

[morse101]

mxstu - many thanks for the suggestion. I will follow it up and let
you know the outcome!!


M

[morse101]

mxstu - It worked !!

many thanks

M :D :D

[Unregistered]

We are having this same issue and we have tried everything suggested above. We have even tried copying the entire contents of the folder that contained mysql-connector-java-3.2.0-alpha-bin.jar into the C:\ColdfusionMX7\wwwroot\lib folder and am still getting the

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

are there any other suggestions for this issue?

We have already reinstalled coldfusion and mysql 5.0 in order to fix a different issue, and now we are finally able to administer the MX7 server, but cannot add the datasource due to the above error. Any help would be greatly appreciated. Thanks.