18 thoughts

  1. 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.

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

  3. 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

  4. 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.

  5. 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.

  6. 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.

  7. 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

  8. 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.

  9. 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.

  10. 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

  11. 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.

Leave a Reply