MySQL ORM Dialect in Application.cfc no longer auto-detects

Description

A valid dialect definition inside the application event listener (Application.cfc) is missing. The dialect cannot be determinated automatically

Lucee 5.2.7.34-SNAPSHOT Error (application)

`A valid dialect definition inside the application event listener (Application.cfc) is missing. The dialect cannot be determinated automatically`

This was not the case with all Lucee 5.1.x and some Lucee 5.2.x versions.

Now, it seems that you need to set Dialect = "MySQLwithInnoDB"
It would be preferrabled if it could auto determine... like it did.

Environment

None

Activity

Show:
Gavin Pickin
March 23, 2018, 10:01 PM

Definitely on the same version of MySQL.
MSSQL always needed the Dialect to be set. I believe it would only guess MySQL.

I haven't tested the Derby one yet... which is a good point.
I'll try and test that.

Pothys - MitrahSoft
March 26, 2018, 4:05 PM

I've analyzed this ticket & confirmed the issue happened on latest version of lucee. Mysql doesn't auto detect the dialect. Dialect should be need for only MSSQL server.

Issue happens only with latest mysql *8.0.9 *version. It's working fine with latest versions.

Pothys - MitrahSoft
March 27, 2018, 6:41 AM

I've added testcase for this ticket.
Pull request: https://github.com/lucee/Lucee/pull/424

Gavin Pickin
April 6, 2018, 5:48 PM

Thanks - looking forward to the release.

Zac Spitzer
July 12, 2019, 7:31 PM

just hit this with mssql with Lucee 5.2.9.31

Fixed

Assignee

Michael Offner

Reporter

Gavin Pickin

Priority

New

Labels

Fix versions

Sprint

None
Configure