Data Source Failure

[HueysDad]

I'm using CF 6.1 and MySQL 4.1 and had problems getting the handshake to work
which I resolved. Now I'm getting the following error :

Connection verification failed for data source: learningcoldfusion
[]java.sql.SQLException: No suitable driver available for learningcoldfusion,
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 learningcoldfusion, please check the driver setting in resources file,
error: com.mysql.jdbc.Driver

I'm new to CF and learning as I go, but now I'm stuck without a DB connection.
Any ideas on this? I've googles the rror code and such and have not found
anything that seems to work or resolve the issues.

I'm running on a local machine with XP SP2.

Thank you in advance for any help you can offer.

[mxstu]

I'm assuming you followed the instructions in this tech note to resolve the
handshake error?
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url]

If so, is it possible that you have more than one version of the mySQL
connector jar in the cf_root/WEB-INF/lib directory ? (ie. two connector jar
files with different version numbers)

[HueysDad]

Hi;

Thank-you for the speedy reply! the onnly files I have in cf_root/WEB-INF/lib
is:
js.jar
mysql-connector-java-3.1.11-bin.jar
empty.txt

I did not get the error message:
Connection verification failed for data source: learningcoldfusion
[]java.sql.SQLException: No suitable driver available for learningcoldfusion,
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 learningcoldfusion, please check the driver setting in resources file,
error: com.mysql.jdbc.Driver

Until after I followed the tech note at:
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url]

[mxstu]

Did you make sure to restart the CF services after placing the jar in the cf_root/WEB-INF/lib directory?

[mxstu]

I just tried version 3.1.11 with MX 6.1 and got a Log4Jlogger class error.

Connection verification failed for data source: mySQLDSN
[]java.sql.SQLException: Unable to instantiate logger class
'com.mysql.jdbc.log.Log4JLogger', exception in constructor?
The root cause was that: java.sql.SQLException: Unable to instantiate logger
class 'com.mysql.jdbc.log.Log4JLogger', exception in constructor


There were some [url]http://www.sargeway.com/blog/index.cfm?mode=entry&entry=62[/url]
with some of the 3.1.x jars and MX6.1. Try using another version of the jar.
I've had success with some of the older versions, both (3.0.17ga) and (3.1.9).
Although, some of the later versions may work as well.

You can probably find them at any one of the ftp mirror sites listed at
mysql.com. For example:
[url]ftp://ftp.orst.edu/pub/mysql/Downloads/Connector-J/[/url]
[url]ftp://mirror.services.wisc.edu/mirrors/mysql/Downloads/Connector-J/[/url]

[HueysDad]

Thanks again for the information.

I have been very diligent in starting and stoping the CF Services whenever
I've made changes. I just tried mysql-connector-java-3.0.17-ga-bin.jar as well
as the mysql-connector-java-3.2.0-alpha-bin.jar and I get the same erro code I
have been.

I noticed in the 3.0.17.jar there are some accompanying files and folders
(/lib and com/mysql/jbdc ) do any of these need to be extracted into my
CF-root/ oe WEB-INF/ folders? Or???

Anymore help would be most appreciated!

[mxstu]

No. You should only need to place the mysql-connector-java-3.0.17-ga-bin.jar
file in the cf_root/WEB-INF/lib directory. Just make sure the
mysql-connector-java-3.0.17-ga-bin.jar file is the only version of the mySQL
jar in the cf_root/WEB-INF/lib directory (ie. remove any other versions of the
jar from that directory)

[HueysDad]

I removed the js.jar file from cf_root/WEB-INF/lib directory. The only file in
there is mysql-connector-java-3.0.17-ga-bin.jar

And I still get:

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

I've started and stopped the service. I've got the JDBC URL:
jdbc:mysql://localhost:3306/learningcoldfusion
and the JDB Driver Name as: com.mysql.jdbc.Driver

Sigh...any other ideas?

[mxstu]

You don't need to remove js.jar. Only other versions of the mySQL jar. Check to see if there are any other versions in the class path.

[HueysDad]

Hi;

Not sure where the class patch is that I should look at? Like I said...I'm new to CF and MySQL and feeling really dumb right about now... :(

[mxstu]

Well, now I feel silly for forgetting a simple cause of this error ;-) Before
you check the class path, check your datasource settings. This It is a string
of paths separated by a comma. However, check the datasource settings first as
that might be your problem.

[HueysDad]

WOOOO HOOOO...I'm in business!!

I had the Drive Class as the Driver Name. I also did not have the MySQL
Connector/J noted as the Driver Name!

Thank you so much for yuor persistence and patience in helping me through
this. I was about ready to put myself on suicide watch! :)

Thanks again!