Skip to main content
CF Dev
Participant
Oct 12, 2021 10:10 AM UTC
Answered

Error in ormseetings.dialect for Azure

Hi All,

We are trying to connect Azure DB by CF ORM. But it keeps showing the error message like either

 

Unable to determine Dialect to use [name=Microsoft Azure SQL Database, majorVersion=12]; user must register resolver or explicitly set 'hibernate.dialect'

 

OR

java.lang.NullPointerException
at coldfusion.orm.hibernate.HibernateConfiguration.determineDialect(HibernateConfiguration.java:401)
a

 

We tried to setup "ormseetings.dialect" with different values in application.cfc,

e.g.

MicrosoftSQLServer

org.hibernate.dialect.SQLServer2008Dialect
org.hibernate.dialect.SQLServer2012Dialect
org.hibernate.dialect.SQLServerDialect
org.hibernate.dialect.MicrosoftSQLServer2012Dialect
SQLServer2012Dialect
SQLServer2008Dialect

 

But all failed, any idea which value would be correct in "ormseetings.dialect" to make it works?

 

Thanks,

CF Dev

 

This topic is closed to new replies. Start a new post to keep the conversation going.
CF DevCorrect answer
Participant
Oct 13, 2021 10:35 PM UTC

the DB name attribute is correct, which works in any CF queries, just didn't work for CF ORM, we setup a new CF instance, it works now.

Thank you for your reply!

View reply

5 replies

Community Expert
Dave WattsCommunity Expert
Community Expert
Oct 12, 2021 2:58 PM UTC

What is in your JDBC URL, if anything? I think you need to make sure that "databaseName" is set properly in there, so that CF doesn't try to connect to the master DB, which isn't allowed in Azure SQL.

 

Dave Watts, Eidolon LLC

Translate
Dave Watts, Eidolon LLC
CF DevAuthorCorrect answer
Participant
Oct 13, 2021 10:35 PM UTC

the DB name attribute is correct, which works in any CF queries, just didn't work for CF ORM, we setup a new CF instance, it works now.

Thank you for your reply!

Translate
Charlie Arehart
Community Expert
Charlie ArehartCommunity Expert
Community Expert
Oct 12, 2021 11:30 AM UTC

You've said 3 times, ormseetings.dialect. Is that just a typo here, and you're really using ormsettings.dialect instead in your code? If it's correct, I have nothing else to offer on the problem for now. Perhaps others will. 

Translate
/Charlie (troubleshooter, carehart. org)
CF DevAuthor
Participant
Oct 13, 2021 10:33 PM UTC

Sorry, I did a typo here which should be "this.ormsettings", it works after we setup a new CF instance.

Translate
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices