Default data source is not picked by hibernate ORM when there are two data sources

[yesvike]

My application have reactive postgres data source and jdbc db2 data source. I cannot go with reactive approach for db2 also because of existing open issue (eclipse-vertx/vertx-sql-client#1131).

Using Hibernate reactive ORM with Mutiny for Postgres and Agroal for db2 transactions.

During application startup Hibernate ORM is not able to pick the default datasource in the application.properties file and throws error

Exception: Model classes are defined for the default persistence unit, but no default datasource was found. The default EntityManagerFactory will not be created. To solve this, configu
re the default datasource. Refer to https://quarkus.io/guides/datasource for guidance.
        at io.quarkus.hibernate.orm.deployment.HibernateOrmProcessor.handleHibernateORMWithNoPersistenceXml(HibernateOrmProcessor.java:932)
        at io.quarkus.hibernate.orm.deployment.HibernateOrmProcessor.configurationDescriptorBuilding(HibernateOrmProcessor.java:420)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:568)
        at io.quarkus.deployment.ExtensionLoader$2.execute(ExtensionLoader.java:882)
        at io.quarkus.builder.BuildContext.run(BuildContext.java:277)
        at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
        at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2449)
        at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1478)
        at java.base/java.lang.Thread.run(Thread.java:833)
        at org.jboss.threads.JBossThread.run(JBossThread.java:501)

Here is my application.properties

# Postgres reactive datasource
quarkus.datasource.db-kind=postgresql
quarkus.datasource.jdbc=false
quarkus.datasource.reactive.url=***
quarkus.datasource.username=***
quarkus.datasource.password=***


#DB2 Agoral data source
quarkus.datasource.legacy.db-kind=db2
quarkus.datasource.legacy.reactive=false
quarkus.datasource.legacy.jdbc.url=***
quarkus.datasource.legacy.username=***
quarkus.datasource.legacy.password=***

I also tried changing db2 data source to default and postgres data source to named one like below, and now hibernate orm not able to pick the datasource pg. Appreciate any suggestions. Thanks.

quarkus.datasource.pg.db-kind=postgresql
quarkus.datasource.pg.reactive.url=***
quarkus.datasource.pg.username=***
quarkus.datasource.pg.password=***
quarkus.datasource.pg.reactive.max-size=10
quarkus.hibernate-orm.pg.datasource=pg
quarkus.hibernate-orm.pg.packages=com.models.dbEntities

[yesvike]

Seems to be an open issue
#13425

[gsmet]

Yes, the Hibernate Reactive extension doesn't support multiple persistence units at the moment.
And you cannot mix Hibernate Reactive and Hibernate ORM.