Embeded Keycloak giving me "Failed to Connect to Database" #14982

jocko-angi · 2022-10-18T16:48:24Z

jocko-angi
Oct 18, 2022

I'm building a Java Spring Boot application with Keycloak 18.0.0 embedded in it.

Running locally I'm able to successfully connect to my local PostGres server and everything works well.

When I attempt to attach to our Dev environment server through changes to the application.properties and the springboot.datasource configuration the application boots, and initial Spring Boot connections to the database are established but then I get this error just before the RestEasy configuration:

[2022-10-18 10:13:55.204]  ZPK=[,,] -     0 ERROR [main] --- o.k.services: java.lang.RuntimeException: Failed to connect to database

But that's all I get. There is 0 description as to why this is happening or which configuration is failing. I have set breakpoints and walked through the code and it appears to be occurring in the org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory which is loading configurations from the keycloak-server.json configuration file.

Here is what the default conectionJpa section of my file looks like -- I am not convinced this is correct, and I know for a fact that what appears to be templated values are only ever generating the default values:

	"connectionsJpa": {
		"provider": "default",
		"default": {
			"url": "${keycloak.connectionsJpa.default.url:jdbc:postgresql://localhost:5432/keycloak}",
			"driver": "${keycloak.connectionsJpa.default.driver:org.postgresql.Driver}",
			"driverDialect": "${keycloak.connectionsJpa.default.driverDialect:}",
			"user": "${keycloak.connectionsJpa.default.user:keycloak}",
			"password": "${keycloak.connectionsJpa.default.password:keycloak}",
			"initializeEmpty": true,
			"migrationStrategy": "update",
			"showSql": "${keycloak.connectionsJpa.default.showSql:false}",
			"formatSql": "${keycloak.connectionsJpa.default.formatSql:true}",
			"globalStatsInterval": "${keycloak.connectionsJpa.default.globalStatsInterval:-1}"
		}
	},

So my questions are:

Is this this correct JPA configuration for the Keycloak connectionsJpa configuration?
How do I get it to use my SpringBoot datasource configuration instead of whatever is in this file right now?
Why is there a separate configuration for this in Keycloak at all, when I thought the whole intention of SpringBoot was to abstract this away?

Thanks in advance for your responses.

Navigation Menu

Repository navigation

Embeded Keycloak giving me "Failed to Connect to Database" #14982

Uh oh!

{{title}}

Uh oh!

Replies: 0 comments

Select a reply

Uh oh!

Embeded Keycloak giving me "Failed to Connect to Database" #14982

Uh oh!

jocko-angi Oct 18, 2022

Replies: 0 comments

jocko-angi
Oct 18, 2022