How to connect my Quarkus project to SQLITE database?

Question

Sorry im newbie here, my quarkus project is get data from mysql database and generate the data to sqlite database. i have 2 question:

1. is quarkus possible to connect 2 database in same time?(in my case connect from mysql and connect to sqlite) and how the correct way to do it?
2. How the correct way to connect my quarkus project with sqlite? Beacause i have seen the documentation from quarkus.io, and i didnt see the extension for connect my quarkus project into sqlite database. list quarkus jbdc to connect database

thanks

Answer 1

The answer depends a bit on if you are using Hibernate ORM or plain JDBC datasources.

Connecting to a sqlite datasource

If you're not using native, you can just use the plain old sqlite JDBC driver and do something like: https://quarkus.io/guides/datasource#other-databases .

This is an example for Oracle but do the exact same thing for sqlite.

Injecting named datasources

To handle multiple datasources, just follow this part of the guide: https://quarkus.io/guides/datasource#multiple-datasources .

You can perfectly well handle both sqlite and MySQL.

Hibernate ORM

So for Hibernate ORM, you will need the multiple persistence units support that is coming with Quarkus 1.8 that should be released on September 15th.

We already released 1.8.0.CR1 and if you're curious and want to give it a test ride, the documentation is available here (it's not yet on the website, it will be pushed with the Final release): https://github.com/quarkusio/quarkus/blob/master/docs/src/main/asciidoc/hibernate-orm.adoc#multiple-persistence-units .