ORM dialect definition error

Hi,

Im getting below error in Lucee5
“A valid dialect definition inside the application event listener
(Application.cfc) is missing. The dialect cannot be determinated
automatically”

It was working for some time and suddenly I got this error. Attached
screenshot for reference.

Below is the ORM setting code :
// ORM SETTINGS
this.ormEnabled = true;
this.ormSettings = {
// ENTITY LOCATIONS, ADD MORE LOCATIONS AS YOU SEE FIT
cfclocation=[ “models”, “modules” ],
// THE DIALECT OF YOUR DATABASE OR LET HIBERNATE FIGURE IT OUT, UP
TO YOU TO CONFIGURE
dialect = “SQLServer2008”,
// DO NOT REMOVE THE FOLLOWING LINE OR AUTO-UPDATES MIGHT FAIL.
dbcreate = “update”,
// FILL OUT: IF YOU WANT CHANGE SECONDARY CACHE, PLEASE UPDATE HERE
secondarycacheenabled = false,
cacheprovider = “ehCache”,
// ORM SESSION MANAGEMENT SETTINGS, DO NOT CHANGE
logSQL = false,
flushAtRequestEnd = false,
autoManageSession = false,
// ORM EVENTS MUST BE TURNED ON FOR CONTENTBOX TO WORK
eventHandling = true,
eventHandler = “cborm.models.EventHandler”,
// THIS IS ADDED SO OTHER CFML ENGINES CAN WORK WITH CONTENTBOX
skipCFCWithError = true
};

Can anyone please tell, what I am missing.

Thanks,
Saravanan

I don’t think SQLServer2008 is a valid dialect. Have you tried "
MicrosoftSQLServer"?

dialect = “MicrosoftSQLServer”

SethOn Tue, Aug 2, 2016 at 6:22 AM, Saravana K <@Saravana_K> wrote:

Hi,

Im getting below error in Lucee5
“A valid dialect definition inside the application event listener
(Application.cfc) is missing. The dialect cannot be determinated
automatically”

It was working for some time and suddenly I got this error. Attached
screenshot for reference.

Below is the ORM setting code :
// ORM SETTINGS
this.ormEnabled = true;
this.ormSettings = {
// ENTITY LOCATIONS, ADD MORE LOCATIONS AS YOU SEE FIT
cfclocation=[ “models”, “modules” ],
// THE DIALECT OF YOUR DATABASE OR LET HIBERNATE FIGURE IT OUT, UP
TO YOU TO CONFIGURE
dialect = “SQLServer2008”,
// DO NOT REMOVE THE FOLLOWING LINE OR AUTO-UPDATES MIGHT FAIL.
dbcreate = “update”,
// FILL OUT: IF YOU WANT CHANGE SECONDARY CACHE, PLEASE UPDATE HERE
secondarycacheenabled = false,
cacheprovider = “ehCache”,
// ORM SESSION MANAGEMENT SETTINGS, DO NOT CHANGE
logSQL = false,
flushAtRequestEnd = false,
autoManageSession = false,
// ORM EVENTS MUST BE TURNED ON FOR CONTENTBOX TO WORK
eventHandling = true,
eventHandler = “cborm.models.EventHandler”,
// THIS IS ADDED SO OTHER CFML ENGINES CAN WORK WITH CONTENTBOX
skipCFCWithError = true
};

Can anyone please tell, what I am missing.

Thanks,
Saravanan


Get 10% off of the regular price for this years CFCamp in Munich, Germany
(Oct. 20th & 21st) with the Lucee discount code Lucee@cfcamp. 189€
instead of 210€. Visit
https://ti.to/cfcamp/cfcamp-2016/discount/Lucee@cfcamp

You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/5101e1a8-415c-44cd-9400-bacd09408741%40googlegroups.com
https://groups.google.com/d/msgid/lucee/5101e1a8-415c-44cd-9400-bacd09408741%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.