What MySQL connector are folks using with CF2021? ...
# adobej
Jim Priest
05/13/2024, 11:16 PMWhat MySQL connector are folks using with CF2021? I'm trying to update our JVM to 11.0.22 (from 11.0.10) and having issues. Currently using Connector 8.0.22 due to this bug https://tracker.adobe.com/#/view/CF-4211276 (which Adobe says was fixed in Update 11) but it doesn't work - I get an error:
com.mysql.cj.exceptions.CJCommunicationsException
I also tried Connector 8.4 (the latest) which does work - but returns dates as objects (which is mentioned in the ticket)... but it's unclear if I still need the JVM arg and/or the hotfix?
h
hemi345
05/14/2024, 3:50 PMI'm using MySQL connector 8.0.22 with JVM 11.0.20 successfully. I haven't tried JVM 11.0.22 yet.
👍 1
hemi345
05/14/2024, 5:15 PM8.0.22 appears to be working fine with JDK 11.0.23
hemi345
05/14/2024, 5:16 PMin my dev environment.
hemi345
05/14/2024, 5:32 PMFWIW, 8.4.0 appears to work fine with JDK 11.0.23 on CF2021 as well.
👍 1
j
Jim Priest
05/14/2024, 8:20 PMNice! Thanks for confirming this. Just curious what Update are you on with 2021?
Jim Priest
05/14/2024, 8:24 PM@hemi345 I'm on Update 13 FWIW.
h
hemi345
05/14/2024, 8:53 PMI'm on Update 13 also.
hemi345
05/14/2024, 9:39 PMI still need to do some more testing to see if that bug that Ben Nadel posted about in Adobe's bug tracker affects us at all, but so far things look good.
👍 1
j
Jim Priest
05/14/2024, 10:58 PMI ran into an issue using zero dates ('0000-00-00 000000') and 2021 and Adobe provided a hotfix for that - I'm wondering if the issue I'm experiencing could be in the hotfix since it does seem to work with 8.4 for you.
Jim Priest
05/17/2024, 7:30 PM@hemi345 I'm still debugging this ... just curious - what version of MySQL are you using??
Jim Priest
05/21/2024, 8:40 PMI finally got this resolved and the issue turned out to be... the hotfix Adobe supplied us to fix ... another date related issue... 😕
3 Views