ORM dialect definition error

169 views
Skip to first unread message

Saravana K

unread,
Aug 2, 2016, 8:22:11 AM8/2/16
to Lucee
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
Lucee5_ContentBox_ORM_Issue.png

Seth Johnson

unread,
Aug 3, 2016, 12:43:53 PM8/3/16
to lu...@googlegroups.com
I don't think SQLServer2008 is a valid dialect.  Have you tried "MicrosoftSQLServer"?

dialect = "MicrosoftSQLServer"

Seth

--
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+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/lucee/5101e1a8-415c-44cd-9400-bacd09408741%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages