Connection verification failed for data source - mysql.jdbc.Driver

[ranger]

I am getting this message when trying to add a mySQL (don't ask) database in CF Admin. Connection verification failed for data source: shownets java.sql.SQLException: No suitable driver available for shownets, please check the driver setting in resources file, error: com.mysql.jdbc.Driver

The root cause was that: java.sql.SQLException: No suitable driver available for shownets, please check the driver setting in resources file, error: com.mysql.jdbc.Driver I've tried all kinds of instructions from posts and nothing seems to werk.  This is on my 32 bit platform. Tryng to get all the bugs out before setting up 64 bit version.

Tnx a

[BKBK · Accepted solution]

It seems you have recently installed Coldfusion. I say this because recent versions of Coldfusion no longer ship with the JDBC driver for MySQL. You therefore have to download and install it yourself.

To do so, go to the download page for the JDBC driver for MySQL. Select Platform Independent as connector platform. Download the platform-independent ZIP file, mysql-connector-java-x.x.xx.zip. (x.x.xx stands for the version number)

Extract the ZIP file. Open the resulting folder, and locate the driver. It is a JAR file called mysql-connector-java-x.x.xx-bin.jar (x.x.xx stands for the version number). Copy the file to Coldfusion's lib directory.

Restart Coldfusion. Voilà - you are ready to go.

[ranger]

Thank you BKBK for everything. 5.5 working great.

[BKBK]

Glad to hear.

All the best.

[jbird4k2]

Hi 

I just installed CF18 on a new win 10 box, added the mysql driver and tried to connect to MySql and recieved a msg that CF now requires a commercial version of MySql??????   I use my personal machine for "experimenting / educating " my self.  I really dont want to pay for a commercial version of a db that I am not doing commercial work on.   Is there an open source rdbms that some one reccomend that will work with CF18?

[jbird4k2]

well, leave it to me to fat finger something.  I had selected mysql (direct) in in stead of mysql 5.   my apologies