Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

adpk77

Programmer
Jun 18, 2006
20
GB
* 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?
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top