Hi Vijay K,
this is just an idea, because I had similar issues with MariaDB:
Can you add this code for a moment, right into the beginning of the onRequestStart function of coldbox Application.cfc (this should be in line 91) and load a page to show a dump of the dialect set to your datasource? That should work on CF2018.
ObjORM=ORMGetSession( “put_name_of_your_datasource_here” );
it will dump the selected dialect, just to make sure the one that has been defined by you in the Application.cfc is correct. When hibernate can’t find a dialect you have set, it may decide to guess one.
What I’ve read is, that in CF you can specify dialects with the fully qualified class name. Don’t know the hibernate version CF2018 use, but here is a list of 5.0:
That means, you could try setting:
NOTE: Somehow CF2018 stores the orm datasource dialect. When changing the dialect, you’ll need to restart the engine.
Just a try and idea, don’t know it this is really a help.