Error in ormseetings.dialect for Azure

[CF Dev]

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

[Charlie Arehart]

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. 

[CF Dev]

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

[CF Dev]

Thank you again!

[Dave Watts]

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

[CF Dev · Accepted solution]

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!