Skip to main content
A
Anonymous
August 20, 2006
Question

MySQL/CF DataSource Problem

  • August 20, 2006
  • 4 replies
  • 1139 views
Hello,

I am running Mac OS X and I am trying to connect MySQL to Coldfusion but every time I am going to create a datasource in coldfusion I get the following error.....

Connection verification failed for data source: MySQL_mysql
java.sql.SQLException: No suitable driver available for MySQL_mysql, please check the driver setting in resources file, error: null
The root cause was that: java.sql.SQLException: No suitable driver available for MySQL_mysql, please check the driver setting in resources file, error: null

Just a little background, I have install CF with the multiserver option using JRun4 and I am able to get CF up and running but after placing the connector for MySQL under the /lib folder under JRun4 folder I am not able to connect and I get the error above. Then I tried to place the connector under the /server/lib under JRun4 folder but still the same issue. Also I am running MySQL 5 and I am using the connector for java version 3.1.10, and I also have tried the version 5.0.3.

Can anyone help me please or just point me in the right direction

Thanks
This topic has been closed for replies.

4 replies

A
Andy_Baz
Inspiring
January 31, 2017

Over ten years later and this post still fixed an issue i was having.....God Bless you adobe forums user Defuse

A
Anonymous
August 22, 2006
ksmith

Thank you it work just fine....thanks a lot I can start my projects now.
A
Anonymous
August 21, 2006
Thanks Defuse

Yes I am using other when creatign the datasource and I am using the correct structure for the url and the class drivers, but so far nothing has help. I am runing CF on top of JRun4 and that is where I am confuse as to the /lib where I have to place the connector.

Thanks for the help
D
Defuse
Participating Frequently
August 21, 2006
Like I said, I'm definitely not a Mac user and I've never installed CFMX or JRun on OS X, however I did find this link http://www.adobe.com/support/coldfusion/j2ee/cfmx-mac-onjrunandtomcat.html#installdeployjrun

In there it shows the JRun installation as jrun_root/jrun4/servers/server_name/cfusion or jrun_root/bin/

I know that doesn't help much, but somewhere in one of those two directories will be the lib/ directory you will need. There should be other JARs in the lib/ directory.

Sorry I couldn't help you any more than that. I'm sure that if you place that MySQL driver in the right place your problems will go away.
D
Defuse
Participating Frequently
August 21, 2006
The version of MySQL you're using is fine and with the version of the JDBC driver you're using, it is supported. What I'm wondering is how you're setting up your datasource. If you want to use MySQL 5, you cannot set up a datasource in the CF admin by selecting the "MySQL." choice. You have to use "other".

Make sure the JDBC driver is in {cfusionmx home}/lib. I'm not a Mac user, so I don't know the default install location for ColdFusion. Anyway, once you get the JDBC driver there, restart ColdFusion.

In the administrator, select "other" for your datasource and fill in the following fields as follows:

1. The name of your datasource
2. jdbc:mysql://localhost:3306/<database> <-- whatever your database name is
3. Driver class: com.mysql.jdbc.Driver
4. Driver name: leave blank
5. Your MySQL database user and password.

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