Mar 7
Further to my other posts, I have now discovered what the problem is with most of the other driver versions, they cause a conflict with the Logger and existing drivers in CFMX causing a log4 error. The below solution should allow you to use the new drivers. Thanks to Stephen Moretti for this info.
The solution is to add this connection string
Views: 330
logger=com.mysql.jdbc.log.StandardLogger
to the end of the JDBC URL.
For example :
jdbc:mysql://localhost:3306/mydatabase?logger=com.mysql.jdbc.log.StandardLogger
Other useful additions to the connection string are
useUnicode=true
and
characterEncoding=UTF8
for internationalisation, giving you : jdbc:mysql://localhost:3306/mydatabase?logger=com.mysql.jdbc.log.StandardLogger&useUnicode=true&characterEncoding=UTF8
NOTE: Don't use the connection string box in the datasource form as this doesn't work for "other" type datasources.
Recent Comments