Skip to main content
A
Anonymous
September 16, 2015
Answered

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

  • September 16, 2015
  • 2 replies
  • 4349 views

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

This topic has been closed for replies.
Correct answer BKBK

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.

2 replies

J
jbird4k2
Participant
June 26, 2020

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?

J
jbird4k2
Participant
June 26, 2020

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

 

BKBK
Community Expert
BKBKCommunity ExpertCorrect answer
Community Expert
September 17, 2015

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.

    A
    Anonymous
    September 17, 2015

    Thank you BKBK for everything. 5.5 working great.

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    September 17, 2015

    Glad to hear.

    All the best.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices