The long awaited MySQL 5 has been released. New to this significantly update are views, triggers, stored procedures, and more. I’ve been using MySQL 5 since very early beta days, and it has been solid and stable (and every bug I reported has been fixed). Download your copy now.
MySQL 5 Released
18 responses to “MySQL 5 Released”
-
Will this work with CF7? I’m sure there is an updated JDBC driver to be found at the MySQL site.
-
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.
-
All is working well for me. 🙂 I really hope Macrobe adds support for mySQL 4.x and 5.x in the next CF7 updater.
-
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
🙂 -
actually… the connector link on the tech note is bad. The link to the connector is now:
http://dev.mysql.com/downloads/connector/j/ -
Thanks for posting that, Rick.
-
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 -
lol
my bad… had port in [] – just delete this and last post, thanks -
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. -
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 -
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. -
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.
Leave a Reply