Does anyone know anything about the MySQL (3.x) Driver that comes installed
with coldfusion? No luck with yahoo search or coldfusion documentation.
I am trying to create a datasource for mysql database. I tried using the
mysql (3.x) driver but i got this error:
Connection verification failed for data source: DTD_Test
java.sql.SQLException: Communication failure during handshake. Is there a
server running on 127.0.0.1:3306?
The root cause was that: java.sql.SQLException: Communication failure during
handshake. Is there a server running on 127.0.0.1:3306?
I then found this post
http://www.easycfm.com/forums/viewmessages.cfm?Forum=32&Topic=5625 and i
have been doing as it says: ColdFusion MX: Configuring the MySQL JDBC driver
I downloaded the mysql-connector-java-3.1.7.zip file from and extracted ONLY
the Executable jar file
Then in the ColdFusion Administrator, I clicked on the "Java and JVM" page.
Entered the full path to the JAR file in the Class Path field.