Skip to main content
C
CF Dev
Participant
October 12, 2021
Answered

Error in ormseetings.dialect for Azure

  • October 12, 2021
  • 2 replies
  • 319 views

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 has been closed for replies.
Correct answer CF Dev

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!

2 replies

D
Community Expert
Dave WattsCommunity Expert
Community Expert
October 12, 2021

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

Dave Watts, Eidolon LLC
C
CF DevAuthorCorrect answer
Participant
October 13, 2021

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!

Charlie Arehart
Community Expert
Charlie ArehartCommunity Expert
Community Expert
October 12, 2021

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. 

/Charlie (troubleshooter, carehart. org)
C
CF DevAuthor
Participant
October 13, 2021

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

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