ColdFusion 8: Built-in Support for MySQL 4/5

coldfusion (This post is more than 2 years old.)

This will be a short post - but I just wanted to make sure folks saw the new support for MySQL 4 and 5 in the ColdFusion Administrator. Finally! Now you don't need to download the Jar and set up a custom DSN everytime you want to connect to a MySQL database.


Download attached file.

Hire Me!

I'm currently looking for my next role in developer evangelism and advocacy. I have a long history of helping companies work with developers and love to write, create demos, and present at conferences. You can find my resume to learn more and drop me an email (raymondcamden@gmail.com) to reach out.

Support this Content!

If you like this content, please consider supporting me. You can become a Patron, visit my Amazon wishlist, or buy me a coffee! Any support helps!

Want to get a copy of every new post? Use the form below to sign up for my newsletter.

Archived Comments

Comment 1 by Phillip Senn posted on 6/2/2007 at 6:18 PM

This was one of the features mentioned in the 1 hour free "ColdFusion 8 Beta Preview" at www.lynda.com.

Comment 2 by Raymond Camden posted on 6/2/2007 at 6:23 PM

Errrr.... and? Or are you just letting folks know about the free preview?

Comment 3 by O?uz Demirkap? posted on 6/2/2007 at 9:33 PM

If you have your MySQL on a Linux box and would like to have Unicode support, you still need to use the old method to define your DSN.

This is the JDBC URL which is created by default: "jdbc:mysql://localhost:3306/mydatabase?"

It must be like "jdbc:mysql://localhost:3306/mydatabase??useUnicode=true&characterEncoding=UTF-8 "

You can find detailed instructions MySQL installation as manual on page: http://howtoforge.com/coldf...

Comment 4 by Emmet posted on 6/2/2007 at 9:47 PM

speaking of... we recently knocked out some mysql sites on one of our servers when we did the 7.02 upgrade. woops. What a pain to manually upgrade each sites driver.

Comment 5 by Lars posted on 6/2/2007 at 11:06 PM

"If you have your MySQL on a Linux box and would like to have Unicode support, you still need to use the old method to define your DSN."

Not true. Just create a datasource with the new driver marked MySQL 4/5 and then add the options useUnicode=true&characterEncoding=UTF-8 to the Connection String field. The options automatically get appended to the JDBC URL.

Comment 6 by J.J. Merrick posted on 6/3/2007 at 3:18 AM

It was one of the first things I noticed since I screwed up and deleted all my settings and had to add my DSN back... I was like YES native 4/5 support.

Comment 7 by Roberto posted on 6/3/2007 at 5:54 PM

Support for PostgreSQL is built-in too?

Rob

Comment 8 by Raymond Camden posted on 6/3/2007 at 6:02 PM

Yes, but wasn't it in earlier?

Comment 9 by Roberto posted on 6/4/2007 at 10:36 AM

No, i had to 5 download the Jar driver and set up a custom DSN.

Thanks

Rob