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

[Guest]

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.

[Guest]

Thank you BKBK for everything. 5.5 working great.

[BKBK]

Glad to hear.

All the best.

[judo1]

I have the jar file in the lib folder but no joy. The attached file is a composite of shots from the CF Administrator. The text is "Connection verification failed for data source: proavs
java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to establish connection"

The insert is what displays when I click the edit icon.

The Access DBs all use Port 8500

Charlie suggested a 4 letter entry in Advanced Settings, but the place to put it does not exist.

I really don't know what I am doing. I was happy bumbling along with MSAccess and CF until my ISP converted to the new "No MSAccess" version of CF.

I'm still on Windows 10 and CF 2018.

I sympathize with the young fellow who ws worried about turnip trucks.

John

[Charlie Arehart]

As for your error trying to verify a mysql datasource, do you in fact have mysql installed and running, listening on port 3306? It's not like Access, where you just point to a file. 

Next, you have named a path in the database field (in your screenshot) where instead you should just be naming the name of the mysql database (not its path). 

It seems you're saying you're new to using mysql as a alternative to ms access. Are you using a tool to help build and view the mysql db before trying to use it with CF? That will help you. There are many web resources that can introduce you to that (without any connection to cf, I mean). 

Finally, if I'm the Charlie you refer to, I don't recall what discussion about MS Access that you're referring to. Was it a discussion in another thread here, in recent weeks? If you think it relevant, can you point to it?

[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

[BKBK]

Hi @jbird4k2 ,

Nil desperandum! The Community version of MySQL is free for personal use.  An alternative MySQL database server that is open-source and free for use is MariaDB.

Check out the ColdFusion 2018 Support Matrix. It tells you that the MySQL version you need is 5.7. That corresponds to MariaDB version 10.2. You can download the latest builds of these versions from the archives of the respective sites:

• MySQL 5.7.44 ( https://downloads.mysql.com/archives/community/ ) 
• MariaDB 10.2.44 ( https://mariadb.org/download/?t=mariadb&o=true&p=mariadb&r=10.2.44&os=windows&cpu=x86_64&pkg=msi&mir... )