DB2 Connection error from quarkus

[srigano]

Hello Quarkus Dev Team :)
I'm having an issue : i want to connect to a DB2.

here is my application.properties:

quarkus.http.port=8080 quarkus.datasource.db-kind=db2 quarkus.datasource.username=****** quarkus.datasource.password=***** quarkus.datasource.jdbc.url=jdbc:db2://*****:10007/***** quarkus.datasource.jdbc.min-size=0 quarkus.datasource.jdbc.max-size=10 quarkus.hibernate-orm.database.generation=none quarkus.hibernate-orm.log.sql=true quarkus.log.level=INFO quarkus.log.console.level=INFO
when i start my application i got this error:

Failed to run post-boot validation: org.hibernate.exception.SQLGrammarException: Unable to open JDBC Connection for DDL execution
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
at org.hibernate.resource.transaction.backend.jta.internal.DdlTransactionIsolatorJtaImpl.(DdlTransactionIsolatorJtaImpl.java:62)
at org.hibernate.resource.transaction.backend.jta.internal.JtaTransactionCoordinatorBuilderImpl.buildDdlTransactionIsolator(JtaTransactionCoordinatorBuilderImpl.java:53)
at org.hibernate.tool.schema.internal.HibernateSchemaManagementTool.getDdlTransactionIsolator(HibernateSchemaManagementTool.java:204)
at org.hibernate.tool.schema.internal.AbstractSchemaValidator.doValidation(AbstractSchemaValidator.java:59)
at io.quarkus.hibernate.orm.runtime.schema.SchemaManagementIntegrator.runPostBootValidation(SchemaManagementIntegrator.java:130)
at io.quarkus.hibernate.orm.runtime.HibernateOrmRecorder$6.run(HibernateOrmRecorder.java:146)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][t4][10509][13454][4.29.24] La connexion au serveur de données a échoué. La licence IBM Data Server for JDBC and SQLJ n'était pas valide
ou n'a pas été activée pour le sous-système DB2 for z/OS. Si vous vous connectez directement au
serveur de données et que vous utilisez DB2 Connect Unlimited Edition for System z, effectuez
l'étape d'activation en exécutant le programme d'activation du kit d'activation de licence.
Si vous utilisez une autre édition de DB2 Connect, procurez-vous le fichier de licence,
db2jcc_license_cisuz.jar, qui se trouve dans le kit d'activation de licence et suivez les instructions d'installation
pour inclure ce fichier dans le chemin d'accès aux classes. ERRORCODE=-4230, SQLSTATE=42968
at com.ibm.db2.jcc.am.b7.a(b7.java:810)
at com.ibm.db2.jcc.am.b7.a(b7.java:66)
at com.ibm.db2.jcc.am.b7.a(b7.java:133)
at com.ibm.db2.jcc.am.ap.a(ap.java:2139)
at com.ibm.db2.jcc.am.Connection.isLicenseValidatedWithServerLicenseProc(Connection.java:9305)
at com.ibm.db2.jcc.am.Connection.validatedByLicenseProc(Connection.java:5157)
at com.ibm.db2.jcc.am.Connection.checkForLicenseRestrictions(Connection.java:5119)
at com.ibm.db2.jcc.am.Connection.completeConnect(Connection.java:5058)
at com.ibm.db2.jcc.t4.b.completeConnect(b.java:693)
at com.ibm.db2.jcc.t4.b.a(b.java:469)
at com.ibm.db2.jcc.t4.b.a(b.java:428)
at com.ibm.db2.jcc.t4.b.(b.java:366)
at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:243)
at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:200)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:491)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:117)
at io.agroal.pool.ConnectionFactory.createConnection(ConnectionFactory.java:204)
at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:509)
at io.agroal.pool.ConnectionPool$CreateConnectionTask.call(ConnectionPool.java:490)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at io.agroal.pool.util.PriorityScheduledExecutor.beforeExecute(PriorityScheduledExecutor.java:75)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1126)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
... 1 more

In my pom.xml file i correctly add theses dependencies:
<dependency> <groupId>io.quarkus</groupId> <artifactId>quarkus-jdbc-db2</artifactId> </dependency> <dependency> <groupId>db2jccdriver</groupId> <artifactId>db2jcc_license_cisuz</artifactId> <version>10.5.0.8</version> </dependency>
I took a look to quarkus.io documentation, and i can see that (here : https://quarkus.io/guides/datasource) :

To do this create a src/main/resources/container-license-acceptance.txt files in your project and add a line with the image name and tag of the database. By default Quarkus uses the default image for the current version of Testcontainers, if you attempt to start Quarkus the resulting failure will tell you the exact image name in use for you to add to the file.

OK but is there any way to indicate a local .jar file for db2 license ?
Why adding the license file in dependencies isn't enough ?

Thank you very much.

Steve

[gastaldi]

Seems to be an issue already reported in #16613

[srigano]

indeed, sorry