Hibernate error about default data source not compatible w/ DevServices automagic?

[kenyee]

"Model classes are defined for the default persistence unit but configured datasource not found: the default EntityManagerFactory will not be created. To solve this, configure the default datasource. Refer to https://quarkus.io/guides/datasource for guidance."

Looks like this checks for a default data source:

quarkus/extensions/hibernate-orm/deployment/src/main/java/io/quarkus/hibernate/orm/deployment/HibernateOrmProcessor.java

Line 927 in 731b9a4

throw new ConfigurationException(

But in dev services, it mentions: "The database Dev Services will be enabled when a reactive or JDBC datasource extension is present in the application, and the database URL has not been configured. "
So to have the dev services automagic that starts up a test container with mysql for you, you need to not specify the "quarkus.datasource.jdbc.url" but the code above checks for the URL and throws an error when you try deploying to prod.

I'm using Panache if that matters, but that error check is in the Hibernate code.
Also using CloudSQL/MySQL, so the DB kind in prod is:
quarkus.datasource.db-kind=other
Dialect is specified for Hibernate though....not sure why it's looking for the default data source for models.

I then added this to application.properties:

## default datasource has to be defined
quarkus.datasource.jdbc.url=jdbc:h2:mem:default
quarkus.datasource.db-kind=h2
quarkus.datasource.username=sa
quarkus.datasource.password=

%prod.quarkus.datasource.db-kind=other
%prod.quarkus.datasource.jdbc.url=jdbc:mysql:///mycloudsqldb
%prod.quarkus.datasource.jdbc.driver=com.mysql.cj.jdbc.Driver

Now Agroal doesn't like this because database kind is "other" and it gets confused (probably should mention what to do on the Quarkus Deploying to Google Cloud docs...it's also using the wrong driver:

2022-03-05 15:56:49,139 WARN  [io.qua.agr.run.AgroalConnectionConfigurer] (main) Agroal does not support detecting if a connection is still usable after an exception for database kind: other
2022-03-05 15:56:49,232 WARN  [io.agr.pool] (main) Datasource '<default>': Driver does not support the provided URL: jdbc:h2:mem:default
2022-03-05 15:57:02,650 WARN  [io.agr.pool] (agroal-11) Datasource '<default>': Driver does not support the provided URL: jdbc:h2:mem:default
2022-03-05 15:57:02,813 ERROR [io.qua.run.Application] (main) Failed to start application (with profile prod): java.sql.SQLException: Driver does not support the provided URL: jdbc:h2:mem:default
	at io.agroal.pool.ConnectionFactory.connectionSetup(ConnectionFactory.java:226)

Is there any way to specify that dev services should run only in local dev to autostart a mysql testcontainer, but also specify the default JDBC URL so it uses mysql?

This also seems like a bug or two?
this seems like a hibernate bug as well as an agroal bug when used w/ CloudSQL?

[kenyee]

FYI, this happened because the %prod.quarkus.datasource.username and %prod.quarkus.datasource.password were reading blank system env vars