I ran into the bug described here: https://bugs.mysql.com/bug.php?id=102435
It's over a year old but when I use Commandbox to load cfengine: adobe@2018 I get this problem. Can anyone provide suggestions on how to either be more specific on the cfengine I use or how to resolve this issue? It's basically a bug in the cf connector driver for mySql (as I understand it) I would think adobe@2018 would be picking up the fixed connector but obviously it appears not to be for me. The symptoms I am having are date fields queried from a table are showing as objects not dates in <cfquery> results.
teaman
05/17/2022, 4:53 AM
@bdw429s any suggestions on how to do a downgrade of the mySql connector in the cfusion lib for adobe@2018 server in commandBox?
b
bdw429s
05/17/2022, 5:09 AM
@teaman Delete the jar and add the version you'd like to use 🙂
t
teaman
05/17/2022, 5:40 AM
@bdw429s I would think others are running into this issue when they load adobe@2018 server. I've read that even @2021 is encountering this issue. So if I were to add the version of the connector that I like, as soon as a new CF version comes out, it will break again (unless Adobe actually fixes this issue).
b
bdw429s
05/17/2022, 6:11 AM
I'm not entirely sure what the issue is you're referring to, but Adobe doesn't bundle ANY MySQL JDBC drivers with ACF for licensing reasons.
bdw429s
05/17/2022, 6:11 AM
We added the jar into ACF until 2021 when they introduce the modules you can install with cfpm