MySQL datasource connection trouble

[pieround]

I am really new to ColdFusion and I may be missing something pretty simple.
However, I looked through the online macromedia documentation and found others
who were recieving the same error when attempting to connect a MySQL data
source, however as of yet they had not been replied to on the forums.

The error is:
Connection verification failed for data source: test
[]java.sql.SQLException: Communication failure during handshake. Is there a
server running on 127.0.0.1:3306?
The root cause was that: java.sql.SQLException: Communication failure during
handshake. Is there a server running on 127.0.0.1:3306?

After posting the problem on the Dev Shack forums I got the following response:
-------------------------------------------------------------
To get CF to talk to MySQL 4.1, you need to download the latest JDBC drivers
from mysql.com (in the Developer Zone tab, listed as Connector/J). 3.1.9 is the
latest (as of this post). From there, unzip the package and drop everything
into the c:\CFusionMX\wwwroot\WEB-INF\lib folder. You might want to backup that
folder to be on the safe side, I did...

Anyways, after that, restart CF. In the CF admin, go to Data Sources and add a
new datasource using 'other' as the driver type. Your JDBC url will be
'jdbc:mysql://[hostname][:port]/[schema]'. (i.e.
jdbc:mysql://localhost:3306/mainDB) Your driver class will be
'com.mysql.jdbc.Driver'. You can name the driver whatever you want, I use MySQL
4.1. If you have a username/password, enter it, and you should be good to go.
---------------------------------------------------------------------
However, after attempting to do this I get the following error when trying to
create the datasource as 'other':

Connection verification failed for data source: testMysql
[]java.sql.SQLException: No suitable driver available for testMysql, please
check the driver setting in resources file, error: com.mysql.jdbc.Driver
The root cause was that: java.sql.SQLException: No suitable driver available
for testMysql, please check the driver setting in resources file, error:
com.mysql.jdbc.Drive

I am running the latest version of My SQL, a windows version of Apache HTTP
Server 2.0.54 as my testing server, and CF 6.1 Developer edition. I've also
updated my ODBC driver as well. Any suggestions as to what I'm doing wrong?

[mpwoodward *TMM*]

On 2005-06-22 11:26:40 -0500, "pieround" <webforumsuser@macromedia.com> said:

> Connection verification failed for data source: testMysql
> []java.sql.SQLException: No suitable driver available for testMysql,
> please check the driver setting in resources file, error:
> com.mysql.jdbc.Driver
> The root cause was that: java.sql.SQLException: No suitable driver
> available for testMysql, please check the driver setting in resources
> file, error: com.mysql.jdbc.Drive

This means it isn't seeing your driver. Check the "MySQL and CF"
thread in this forum for some additional suggestions.

Matt

--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion