What database is recommended for Orbeon

Hi,

The organization where we are going to install Orbeon would like to know, what database is recommended for Orbeon:

1. Oracle
2. MySQL
3. DB2
4. MSSQL


I can see that most of the comments in the forum are based on Oracle and MySQL, but which of the 4 database mentioned above works best with Orbeon.

Regards
Balatharan

Balatharan,

That would probably be Oracle. Oracle was the first relational database we supported.

With Orbeon Forms 4.3, some features were supported in MySQL and DB2 but not Oracle, but 4.4 (coming out soon) brings Oracle back on par.

MySQL support has slower search at this point.

SQL Server is not yet supported, but we are working on unifying the relational code so adding support for that (and other relational databases) will become easier soon. See also:

https://github.com/orbeon/orbeon-forms/issues/697
https://github.com/orbeon/orbeon-forms/issues/966

-Erik