I am trying to use javamelody to monitor the SQL-Statements of my Coldfusion 10 Application.
I have created a custom datasource with the following properties:
JDBC-URL: jdbc:mysql://localhost:3306/prod?characterEncoding=latin1&driver=com. mysql.jdbc.Driver
Driver Class: net.bull.javamelody.JdbcDriver
Driver Name: com.mysql.jdbc.Driver
but when trying to verify this datasource it tells me immediatelly (so no real timeout stuff)
Connection verification failed for data source: prodmelody
java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to establish connection
When I put something else under Driver Class, it comes with "No suitable Driver found", so the Driver generically must be found.
When I put com.mysql.jdbc.Driver as Driver Class it works (but it doesnt go through javamelody then)
The Documentation tells me to add a "driver" Property with the original driver name, so I added that to the JDBC-URL as well as I used it as "Driver Name". (also tried with just each one of them, same thing).
Any Ideas what could be wrong here, and how I could correct that? I expect that javamelody does not know where to really go to, and therefore comes back immediatelly with this error Message.
Europe, Middle East and Africa