March 19, 2021
Alert about MySQL Connector/J 8.0.23
Comments
(8)
March 19, 2021
Alert about MySQL Connector/J 8.0.23
Stargate Connections - Media Services Department
Newbie 1 posts
Followers: 1 people
(8)

We encountered a problem while setting up a new ColdFusion 2021 server, and felt it warranted an alert to other users who want to use MySQL through the community version of the MySQL Connector/J.

The currently available connector version 8.0.23 implements a change that breaks date values returned in queries in ColdFusion. Instead of returning the typical date or datetime string one expects, the connector now returns a LocalDateTime Java object. This is incompatible with any of the standard ColdFusion date-related functions, and causes errors.

To resolve the issue, we had to replace Connector/J 8.0.23 with Connector/J 8.0.22 instead, and everything is fine.

To download the connector: https://dev.mysql.com/downloads/connector/j/

To read about the issue:
https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-23.html#connector-j-8-0-23-feature

8 Comments
2021-07-22 18:28:15
2021-07-22 18:28:15

I have some news on this. First, there is indeed already a bug report filed for this (CF-4211276). FWIW, it was filed on Mar 9, a week before this post.

Second, I also just added a comment there, clarifying both how this issue is clarified in the docs on the change in that 8.0.23 driver, and how it really would be up to Adobe to fix it (as it requires just a very simple change in a single java call they do for us)

Folks seeing this post should register a vote on the bug. There was only 1, when I added the second just now.

Like
(1)
>
Charlie Arehart
's comment
2021-07-22 18:31:04
2021-07-22 18:31:04
>
Charlie Arehart
's comment

Thanks Charlie

Like
2021-07-22 13:27:56
2021-07-22 13:27:56

Has a ticket been created?

Like
(3)
>
ellipsisces1292chris
's comment
2021-07-22 14:35:02
2021-07-22 14:35:02
>
ellipsisces1292chris
's comment

If one has not, then before that may be done, I have a question for anyone focused on this problem: has the problem been confirmed to still exist–and to not be solved by a later mysql driver update? (I am not focused on the problem myself, to be clear. I’m just helping out here, as I can.)

Like
>
Charlie Arehart
's comment
2021-07-22 17:03:08
2021-07-22 17:03:08
>
Charlie Arehart
's comment

Yes, tested 8.0.23, 24, 25, 26 all the same error on CF 2021

Like
>
ellipsisces1292chris
's comment
2021-07-22 18:27:26
2021-07-22 18:27:26
>
ellipsisces1292chris
's comment

Thanks for that clarification. I have done some more digging into this today.

I’ll add a new comment as a top-level reply, as sometimes people don’t see or pay attention to replies to replies.

Like
2021-03-24 17:48:13
2021-03-24 17:48:13

Stargate, if you may not know, the place where you would create the sort of bug report that Brad is referring to is https://tracker.adobe.com .

Like
2021-03-23 17:47:06
2021-03-23 17:47:06

Is there a ticket in for CF to better handle this new Java class out of the box in its date-related functions?

Like
Add Comment