I am trying to connect Keycloak to a PostgreSQL database, keycloak project is written in springboot and Keycloak is failing to recognize the PostgreSQL JDBC driver, showing the error:
"Driver does not support the provided URL: jdbc:postgresql://localhost:5432/keycloak"
I have: -Setting up Keycloak to use PostgreSQL as its database. -Adding the PostgreSQL JDBC driver so that Keycloak can communicate with the database. -Facing an issue where Keycloak is unable to find or use the JDBC driver, even after adding it manually or through pom.xml.
Title: "Keycloak PostgreSQL Connection Error: Driver does not support the provided URL"
Details: "I'm trying to configure Keycloak to use a PostgreSQL database, but I keep getting the error: Driver does not support the provided URL: jdbc:postgresql://localhost:5432/keycloak.
I've already:
-Added the PostgreSQL JDBC driver (postgresql-42.7.5.jar) to quarkus/server/target/lib/. -Added the dependency in pom.xml. -Set environment variables: KC_DB, KC_DB_URL, KC_DB_USERNAME, etc. -Verified that PostgreSQL is running and accessible.
But after building Keycloak with mvn clean install -DskipTests, the driver seems to disappear or is not recognized.
Has anyone faced this issue? How do I properly add the PostgreSQL JDBC driver so that Keycloak detects it?"
Details: "I'm trying to configure Keycloak to use a PostgreSQL database, but I keep getting the error: Driver does not support the provided URL: jdbc:postgresql://localhost:5432/keycloak.
I've already:
-Added the PostgreSQL JDBC driver (postgresql-42.7.5.jar) to quarkus/server/target/lib/. -Added the dependency in pom.xml. -Set environment variables: KC_DB, KC_DB_URL, KC_DB_USERNAME, etc. -Verified that PostgreSQL is running and accessible.
But after building Keycloak with mvn clean install -DskipTests, the driver seems to disappear or is not recognized.
Has anyone faced this issue? How do I properly add the PostgreSQL JDBC driver so that Keycloak detects it?"