mySQL Drivers and Cold Fusion 6.1

[Michael London]

Hello all,

I have scoured the forums for some answers to the following problem:

We are trying to install the latest mySQL drivers into Windows Based
Cold Fusion 6.1. We have followed the instructions Macromedia provided
on their site.

- Placed the [mysql-connector-java-3.1.10-bin.jar] file into the
CFusion\wwwroot\web-inf\lib directory.

- Added the full path to the JAR file in the JAVA/JVM Section of CF
Administrator:
[C:\CFusionMX\wwwroot\WEB-INF\mysql-connector-java-3.1.10-bin.jar]

- Restarted the services

- setup the JDBC URL to:
[jdbc:mysql://remoteHostAddress:3306/dbaseName]

- Set the Driver class to:
[com.mysql.jdbc.Driver]

- Added the appropriate Username and Password

After all this, I am getting a timeout error:
[java.sql.SQLException: coldfusion.sql.DatabaseConnectionException:
Timed out trying to establish connection. The root cause was that:
java.sql.SQLException: coldfusion.sql.DatabaseConnectionException: Timed
out trying to establish connection]

I have seen this error reported in threads dealing with Cold Fusion 7.0
and MySQL.

Does anyone have any thoughts on this?

Thanks in advance for any help you can provide.

Mike

[Mountain Lover]

The best 3.1.x driver I've gotten to work with CFMX 6.1 is 3.1.7. 3.1.10
works great with CFMX7. That said, 3.0.x is supposed to work too and
would probably be better for using in CFMX6.1

HTH

--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]

[Michael London]

FOLLOWUP:

Turns out there is something uniquely wrong with the settings on this
particular server. I setup the driver on another server and there were
no issues (other than having to set the characterEncoding and useUnicode
switches).




Michael London wrote:

> Hello all,
>
> I have scoured the forums for some answers to the following problem:
>
> We are trying to install the latest mySQL drivers into Windows Based
> Cold Fusion 6.1. We have followed the instructions Macromedia provided
> on their site.
>
> - Placed the [mysql-connector-java-3.1.10-bin.jar] file into the
> CFusion\wwwroot\web-inf\lib directory.
>
> - Added the full path to the JAR file in the JAVA/JVM Section of CF
> Administrator:
> [C:\CFusionMX\wwwroot\WEB-INF\mysql-connector-java-3.1.10-bin.jar]
>
> - Restarted the services
>
> - setup the JDBC URL to:
> [jdbc:mysql://remoteHostAddress:3306/dbaseName]
>
> - Set the Driver class to:
> [com.mysql.jdbc.Driver]
>
> - Added the appropriate Username and Password
>
> After all this, I am getting a timeout error:
> [java.sql.SQLException: coldfusion.sql.DatabaseConnectionException:
> Timed out trying to establish connection. The root cause was that:
> java.sql.SQLException: coldfusion.sql.DatabaseConnectionException: Timed
> out trying to establish connection]
>
> I have seen this error reported in threads dealing with Cold Fusion 7.0
> and MySQL.
>
> Does anyone have any thoughts on this?
>
> Thanks in advance for any help you can provide.
>
> Mike