CODEWITHSUNDEEP
mysqlcoldfusioncoldfusion-10
Aniruddha
Aniruddha

Reputation: 3317

Error connecting MySQL to ColdFusion10

I can't get my ColdFusion 10 datasource to connect to MySql v5.xx

For the connector type, I'm using: MySQL (4/5)

I get this error:

Connection verification failed for data source: cfMySqlDSN
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
The root cause was that: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

Could anyone please help me resolve this issue?

Upvotes: 3

Views: 1264

Answers (1)

Adam Cameron
Adam Cameron

Reputation: 29870

I had the same thing, raised it with Adobe, and no-one could replicate it.

In the end I rolled back to the version of the MySQL driver that shipped with CF9, and it worked. Possibly try that.

The file in question is [ColdFusion dir]/WEB-INF/cfusion/lib/mysql-connector-java-commercial-[some version number]-bin.jar

Upvotes: 3

Related Questions