What dialects are available in QIE?

Question

I want to install a new instance of QIE and would like to use either MySql or MSSQL for the QIE database. For the -Dhibernate.dialect option what dialects are available to choose from?

Answer 1

These are the dialects available in QIE 
 
MySql 

com.qvera.qie.persistence.MySQLUnicodeDialect 
 
Available as of QIE version .49 
com.qvera.qie.persistence.MySQL5UnicodeDialect 
com.qvera.qie.persistence.MySQL55UnicodeDialect 
com.qvera.qie.persistence.MySQL57UnicodeDialect 
com.qvera.qie.persistence.MySQL8UnicodeDialect 

MariaDb 

Available as of QIE version .49 
com.qvera.qie.persistence.MariaDBUnicodeDialect 
com.qvera.qie.persistence.MariaDB53UnicodeDialect 
com.qvera.qie.persistence.MariaDB10UnicodeDialect 
com.qvera.qie.persistence.MariaDB102UnicodeDialect 
com.qvera.qie.persistence.MariaDB103UnicodeDialect 

Available as of QIE version .51

com.qvera.qie.persistence.MariaDB106UnicodeDialect 

com.qvera.qie.persistence.MariaDB107UnicodeDialect 

MSSQL 

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