ORM Dialect in Application.cfc prevents multi datasource/multi dialect

Description

In my Lucee 4.5 application I was using multiple datasources in ORM, both MSSQL and MySQL.

In Lucee 5.2 I have to specify a dialect in ORM settings, which prevents me from using both MySQL and MSSQL in one application. It is not possible to specify multiple dialects.

Environment

None

Activity

Show:
Michael Offner
November 16, 2018, 6:18 PM

Hibernate 3.5.5.74 partly solves the issue but also need an update in Lucee itself (coming soon)
https://github.com/lucee/extension-hibernate/commit/da26629d6cc18a6d61c53f14ad3bc2e4dfc701e9

Michael Offner
November 16, 2018, 6:36 PM

Lucee 5.3.2.16 support struct and simple values for dialect,dbcreate,schema,sqlscript and catalog.

Michael Offner
November 19, 2018, 10:17 AM

improving autodetecting dialect wit hibernate 3 will take a lot of this, most likely a fix not necessary when we move to Hibernate 5. So we will not address that issue for the moment.
We prefer to spend that tiume migrating to Hibernate 5.

Michael Offner
November 19, 2018, 10:22 AM

see for more details

Pothys - MitrahSoft
November 19, 2018, 2:25 PM

Added test cases for this issue. Issue fixed in 5.3.2.16 lucee snapshot version.

Pull Request : https://github.com/lucee/Lucee/pull/609

Fixed

Assignee

Michael Offner

Reporter

Wil de Bruin

Priority

Blocker

Labels

Fix versions

Sprint

None
Configure