We ran into a problem recently when trying to upgrade our system to use MySQL 5.6. We're running ColdFusion 9 Enterpise with the MySQL JDBC drivers that ship with CF9 and CF10 and as soon as we swicthed our testing environments over to MySQL 5.6 everything blew up.

What we found is that the MySQL team has finally removed support for a long depricated function, a function all of the legacy JDBC drivers are still using.

The MySQL drivers that ship with CF 9 and CF 10 are, 5.1.11 and 5.1.17 respectively. Anything older than 5.1.22 when combined with MySQL 5.6 will produce the following error:

You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right syntax
to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1

To correct the issue you need to go download the latest MySQL JDBC driver, at the very least 5.1.22 or greater. Please keep in mind, while this is a pretty safe thing to do, Adobe's offical position is that they do not support any MySQL version greater than 5.1

Adobe ColdFusion Support Matrix

Driver Downloads:

http://dev.mysql.com/downloads/connector/j/

Pete Frietag (http://www.petefreitag.com) has logged a bug with Adobe - help us get it fixed by up voting the issue so they'll include the latest driver with th enext patch

https://bugbase.adobe.com/index.cfm?event=bug&id=3506758

More nerdy details on the issue can be found here:

https://netbeans.org/bugzilla/show_bug.cgi?id=224260

https://www.adobe.com/products/coldfusion-family.html

So, maybe I'm late to the game wih this, but I was just on Adobe.com and happended to look at ColdFusion Builder 2 in the store and saw they now offer upgrade pricing for Builder if you have any of the following:

Read more...

I'm impressed. You don't often see big companies with well established niches come around and really innovate, but RIM (Blackberry) has really done it this time.

They're getting ready to release their competitor to the iPad, the Blackberry Playbook and to make sure they have a well stocked library of apps ready they've made an incredible offer. Write an app for the Playbook, get it approved for the store and they'll send you a FREE playbook as a thank you.

Read more...

So our first ever cfdevcamp came and went this weekend. The day went very well and most of it is already a blur... We had a great turnout, including around 7 or 8 people who came in from outside Phoenix. 5 or 6 from Tucson, one from S California and I think even one person from Seattle!

I'm so proud of out team, everyone worked so hard to make this event happen and then spent an entire Saturday helping total strangers learn a little but more about ColdFusion. It was exciting to be part of something like that.

This post is mostly for myself and the other members of the cfdevcamp Phoenix team, after hosting a big event like that it's best to get down your immediate thoughts on what went well and what didn't can be crucial for planning your next big event.

Read more...