Hi, I have recently started using the Jmix platform, and I have developed many applications on the Cuba Platform. I need to connect a custom database such as FireBird or Db2. After reading the documentation and forum, I managed to connect Db2 and import some entities along with their associated Browser and Edit screens (List - Detail). My current challenge is understanding how to use a custom Main Data Store. I have tried multiple times to modify the app properties for the custom main store, but with limited success. Thank you in advance!
Hi Paolo,
Generally we recommend using only supported databases (HSQL, PostgreSQL, MS SQLServer, MySQL, MariaDB, Oracle) as a main data store. Also, you can use a custom database as an additional data store, see Connecting to Unsupported Databases.
Technically, any database with a JDBC driver can also be used as a main datastore, but we cannot guarantee compatibility of all functionality and add-ons.
If you want to experiment, take a look at this example: jmix-projects/sample-firebird-main-data-store. It demonstrates usage of Firebird as a main data store. See the README for details.
Regards,
Konstantin