Highlighted

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

Participant ,
Sep 16, 2015

Copy link to clipboard

Copied

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

Adobe Community Professional
Correct answer by BKBK | Adobe Community Professional

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.

TOPICS
Database access

Views

2.1K

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

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

Participant ,
Sep 16, 2015

Copy link to clipboard

Copied

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

Adobe Community Professional
Correct answer by BKBK | Adobe Community Professional

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.

TOPICS
Database access

Views

2.1K

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Sep 16, 2015 0
Adobe Community Professional ,
Sep 16, 2015

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 16, 2015 0
Participant ,
Sep 17, 2015

Copy link to clipboard

Copied

Thank you BKBK for everything. 5.5 working great.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 17, 2015 0
Adobe Community Professional ,
Sep 17, 2015

Copy link to clipboard

Copied

Glad to hear.

All the best.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 17, 2015 0
New Here ,
Jun 26, 2020

Copy link to clipboard

Copied

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?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jun 26, 2020 0
jbird4k2 LATEST
New Here ,
Jun 26, 2020

Copy link to clipboard

Copied

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

 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jun 26, 2020 0