Database connection validation with Quarkus distribution #15750

devRoemer · 2022-11-29T16:07:36Z

devRoemer
Nov 29, 2022

In HA environments, it was possible before to configure a validation so that the db connection is restored, e.g. after a rolling update of postgres.

It was done like that:

<validation>
    <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker"></valid-connection-checker>
    <background-validation>true</background-validation>
    <background-validation-millis>120000</background-validation-millis>
</validation>

More detailed description on the problem can be found here:

How can the same be accomplished with the Quarkus distribution?

Used Chart for deployment: https://github.com/codecentric/helm-charts/tree/master/charts/keycloakx

sschu · 2022-11-30T16:35:42Z

sschu
Nov 30, 2022
Collaborator

There are similar options for Quarkus, see https://quarkus.io/guides/datasource#quarkus-agroal_quarkus.datasource.jdbc.background-validation-interval.

0 replies

Navigation Menu

Repository navigation

Database connection validation with Quarkus distribution #15750

Uh oh!

{{title}}

Uh oh!

Replies: 1 comment

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

Database connection validation with Quarkus distribution #15750

Uh oh!

devRoemer Nov 29, 2022

Replies: 1 comment

Uh oh!

sschu Nov 30, 2022 Collaborator

devRoemer
Nov 29, 2022

sschu
Nov 30, 2022
Collaborator