Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

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

Guest
Sep 16, 2015 Sep 16, 2015

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

TOPICS
Database access
4.3K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Sep 16, 2015 Sep 16, 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 drive

...
Translate
Community Expert ,
Sep 16, 2015 Sep 16, 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.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Sep 17, 2015 Sep 17, 2015

Thank you BKBK for everything. 5.5 working great.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Sep 17, 2015 Sep 17, 2015

Glad to hear.

All the best.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 26, 2020 Jun 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?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 26, 2020 Jun 26, 2020
LATEST

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

 

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