adding a datasource in coldfusion using mysql driver will get you:
[]java.sql.SQLException: Communication failure during handshake...
to fix:
1. download mysql-connector-java-3.0.17-ga.tar.gz (using connector 5.x didnt work for me)
2. extract and copy mysql-connector-java-3.0.17-ga-bin.jar to /opt/coldfusionmx/wwwroot/WEB-INF/lib/
3. add classpath /opt/coldfusionmx/wwwroot/WEB-INF/lib/ in cf admin
4. restart cf
5. add datasource using other driver
jdbc url: jdbc:mysql://<host>:<port>/<database name>
driver class: com.mysql.jdbc.Driver
booyah!!
(reference: http://helpx.adobe.com/coldfusion/kb/configure-jdbc-driver-mysql-4.html)
No comments:
Post a Comment