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

Dialects are grouped by database and by the QIE release where they became available.

Legend: 

✅ Supported as of version  

❌ Removed (dropped) in version

 

MySQL

✅ Supported

QIE Version: 25.2.1+
• com.qvera.qie.persistence.MySQL84UnicodeDialect
• com.qvera.qie.persistence.MySQL80UnicodeDialect

QIE Version: 0.49+
• com.qvera.qie.persistence.MySQL8UnicodeDialect

 

❌ Removed in QIE 25.2.1
• com.qvera.qie.persistence.MySQL57UnicodeDialect
• com.qvera.qie.persistence.MySQL55UnicodeDialect
• com.qvera.qie.persistence.MySQL5UnicodeDialect
• com.qvera.qie.persistence.MySQLUnicodeDialect

 

MariaDB

✅ Supported

QIE Version: 25.2.1+
• com.qvera.qie.persistence.MariaDB114UnicodeDialect
• com.qvera.qie.persistence.MariaDB1011UnicodeDialect
• com.qvera.qie.persistence.MariaDB105UnicodeDialect
• com.qvera.qie.persistence.MariaDB104UnicodeDialect

QIE Version: 0.51+
• com.qvera.qie.persistence.MariaDB107UnicodeDialect
• com.qvera.qie.persistence.MariaDB106UnicodeDialect

 

❌ Removed in QIE 25.2.1
• com.qvera.qie.persistence.MariaDB103UnicodeDialect
• com.qvera.qie.persistence.MariaDB102UnicodeDialect
• com.qvera.qie.persistence.MariaDB10UnicodeDialect
• com.qvera.qie.persistence.MariaDB53UnicodeDialect
• com.qvera.qie.persistence.MariaDBUnicodeDialect

 

Microsoft SQL Server (MSSQL)

✅ Supported

QIE Version: 23.4.1+
• com.qvera.qie.persistence.SQLServer2022UnicodeDialect

QIE Version: 0.47+
• com.qvera.qie.persistence.SQLServer2019UnicodeDialect
• com.qvera.qie.persistence.SQLServer2017UnicodeDialect
• com.qvera.qie.persistence.SQLServer2016UnicodeDialect

 

❌ Removed in QIE 25.2.1
• com.qvera.qie.persistence.SQLServer2014UnicodeDialect
• com.qvera.qie.persistence.SQLServer2012UnicodeDialect
• com.qvera.qie.persistence.SQLServer2008UnicodeDialect
• com.qvera.qie.persistence.SQLServer2005UnicodeDialect

Comments

Last updated on 02/03/2025