0

How to configure database query timeout? I went through the documentation for all available configurations options, but seems like there is no configuration for db query timeout.

I have tried multiple combinations for configuration but those combinations are getting ignored.

Quarkus version: 2.5.4.Final
Java version: 11.0.17

Below are the the log for some of the configurations:

WARN  [io.qua.config] (Quarkus Main Thread) Unrecognized configuration key "quarkus.datasource.mysql.query-timeout" was provided; it will be ignored;

WARN  [io.qua.config] (Quarkus Main Thread) Unrecognized configuration key "quarkus.datasource.db-kind.properties.javax.persistence.query.timeout" was provided; it will be ignored;

WARN  [io.qua.config] (Quarkus Main Thread) Unrecognized configuration key "quarkus.datasource.db-kind.hibernate.query-timeout" was provided; it will be ignored;

WARN  [io.qua.config] (Quarkus Main Thread) Unrecognized configuration key "quarkus.datasource.mysql.query-timeout" was provided; it will be ignored;

WARN  [io.qua.config] (Quarkus Main Thread) Unrecognized configuration key"quarkus.datasource.mysql.jdbc.queryTimeout" was provided; it will be ignored;

PS: I'm using "mysql" database in this application, and want to configure database query timeout from application.yml not in database layer.

Abhishek Pratap Singh
  • 613
  • 3
  • 11
  • 18

1 Answers1

0

https://quarkus.io/guides/all-config#quarkus-agroal_quarkus.datasource.jdbc.additional-jdbc-properties-additional-jdbc-properties is the way to pass additional properties to JDCB driver.
Also check How to set a connection timeout on the MySQL JDBC driver?

Luca Basso Ricci
  • 17,829
  • 2
  • 47
  • 69