[b]Coldfusion Administration:Adding Data Sources Error[/b]

[adpk77]

* Connection verification failed for data source: online_store
[]java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?
The root cause was that: java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?

Thats the message I get when I try to add a mysql database using the coldfusion admin page. I never get this error when I add an access database.

Where could I be going wrong?

Could anyone help or suggest something?

 

[r937]

see

http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=6ef0253

the only reason i know about this is because the same error happened to me, and i had to ask for help on a coldfusion discussion forum too

r937.com | rudy.ca

 

[adpk77]

I followed the instructions from that link but i am still facing some problems.

Regd the drivers and connectors, I had downloaded MySQL Connector/J 5.0

where it states to enter jdbc url, i entered in the following:
jdbc:mysql://[localhost]:[3306]/[online_store]

for driver class: com.mysql.jdbc.5.0.4

I am confused with steps 2 and 3.

2. Extract the mysql-connector-java-3.{n}-bin.jar file from the downloaded archive file.
3. Save the mysql-connector-java-3.{n}-bin.jar file in thecf_root/WEB-INF/lib directory.

What i am confused about is do we extract the main zip file to a folder of same name and copy and paste the jar file to destination folder or do we extract the jar file itself which opens up 3 folders and paste to destination folder?

below is the error i get.

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