MySQL 5 Released

I downloaded a previous jdbc driver from the site and it was working with the mySQL 5 beta. I have not tried the final release yet.

Will this work with CF7? I'm sure there is an updated JDBC driver to be found at the MySQL site.

actually... the connector link on the tech note is bad. The link to the connector is now: http://dev.mysql.com/downloads/connector/j/

For those of you who don't know what we're talking about and just want to run mySQL 5 with ColdFusion, read up on this tech note as it still applies: http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253 :)

All is working well for me. :) I really hope Macrobe adds support for mySQL 4.x and 5.x in the next CF7 updater.

Thanks for posting that, Rick.

lol my bad... had port in [] - just delete this and last post, thanks

Hi I have tried to get this working but I get the following error: Connection verification failed for data source: abachi java.sql.SQLException: Illegal connection port value '[3307]' The root cause was that: java.sql.SQLException: Illegal connection port value '[3307]' I am running on port 3307, as mysql4 is on 3306

I am trying to use ColdFusion 7.0 with MySQL 5.1 with a Windows XP OS. Has anyone been successful with this combination? If so, what was involved with respect to MySQL drivers and CF data source connections? Any help would be appreciated.

I am trying to use ColdFusion 7.0 with MySQL 5.1 with a Windows XP OS. Has anyone been successful with this combination? If so, what was involved with respect to MySQL drivers and CF data source connections? Any help would be appreciated.

I am trying to use ColdFusion 7.0 with MySQL 5.1 with a Windows XP OS. Has anyone been successful with this combination? If so, what was involved with respect to MySQL drivers and CF data source connections? Any help would be appreciated.

Well I found out the solution to above problem. Follow the below steps: 1) Download the MySQL Connector J JDBC driver from http://dev.mysql.com/downloads/connector/j/ 2) Make the JDBC driver available to CFMX through the classpath by saving mysql-connector-java-3.0-bin.jar in either $CFMX_HOME/runtime/servers/lib/ for CFMX Server Configuration or $JRUN_HOME/servers/lib/ for CFMX on JRun Configuration. This makes the driver available to all JRun server instances. 3)Restart CFMX server.

Can anybopdy helps me when ever I tried to create DSN on Coldfusion MX7.0.1 administarrtaor for MYSQL 5 DB using built-in MYSQL driver, Iam getting the following error " Connection verification failed for data source: chc_engine java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306? The root cause was that: java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?" Please help

oh those damn brackets...

I am testing CF7 with MySQL 5.0 and have run into a problem with MySQL's DATA LOAD. I'm using the following jdbc driver: mysql-connector-java-3.1.10-bin.jar Here's my code: <cfquery name="ImportIDXRes" datasource="cayrealestate-import"> LOAD DATA LOCAL INFILE 'c:/IDX-data/20061211_listings_res.txt' INTO TABLE idx_res FIELDS TERMINATED BY ',' ENCLOSED BY '"' IGNORE 1 LINES </cfquery> The error I'm getting is: Data truncation: Out of range value adjusted for column 'l_br' at row 5 This error can vary with the text file being imported, for example this is the error I got on the next day's attempt: Data truncation: Out of range value adjusted for column 'u_sq' at row 5 This code has been running fine with MySQL 4.0 and the same driver. Has anyone tested DATA LOAD with MySQL 5.0? Is this a driver problem or some other kind of problem.

Hi. Trying to get MYSQL 5 on my ColdFusion on Mac platform, I have copied the mysql-connector-java-5.0.4-bin.jar to the servers/lib in the JRUN folder and still get the error: Connection verification failed for data source: CFLearning java.sql.SQLException: No suitable driver available for CFLearning, please check the driver setting in resources file, error: null The root cause was that: java.sql.SQLException: No suitable driver available for CFLearning, please check the driver setting in resources file, error: null If Anyone knows the cause of this , I would be most appreciative. Thanks

I've tried the 5.0.5 and the 3.0.17 Connectors, I still get the same error.

I was having the same problem as everyone else using CFMX7, mySql 5 and Windows XP until I read shimju's post above regarding where to copy the jar file if you are using JRun4 as your server. Theirs a couple of hours I'll never get back.