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
logger=com.mysql.jdbc.log.StandardLogger
to the end of the JDBC URL. For example :
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
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.
There are no comments for this entry.
[Add Comment]