QIE Build 24.2.* requires Microsoft SQL Server 2016 or greater. How do I update the version in QIE?

Question

I am getting this alert:

QIE Build 24.2.1.16442 requires Microsoft SQL Server 2016 or greater. Please upgrade your Microsoft SQL Server version.

How do I update the version or dialect in QIE so it matches my sql version?

Answer 1

The dialect is defined on the QIE service manager. It is in the Startup Tab under the Arguments

-Dhibernate.dialect=com.qvera.qie.persistence.SQLServer????UnicodeDialect

We need to update this to match your sql version here is a list of values:

com.qvera.qie.persistence.SQLServer2005UnicodeDialect 
com.qvera.qie.persistence.SQLServer2008UnicodeDialect 
com.qvera.qie.persistence.SQLServer2012UnicodeDialect 
com.qvera.qie.persistence.SQLServer2014UnicodeDialect 
 
Available as of QIE version .47 
com.qvera.qie.persistence.SQLServer2016UnicodeDialect 
com.qvera.qie.persistence.SQLServer2017UnicodeDialect 
com.qvera.qie.persistence.SQLServer2019UnicodeDialect
 
Available as of QIE version 23.4.1 
com.qvera.qie.persistence.SQLServer2022UnicodeDialect  

Once you have updated that you can click apply. Then go to the general tab and stop then start the service for the changes to take effect.