Keycloak 16.1.0 with Oracle 19c

Hi…

I’m using Keycloak 16.1.0 and want to integrate it with Oracle 19c database. I’m using it in standalone mode. Here are my module.xml and standalone.xml files

module.xml:

<?xml version=”1.0" ?>
        <module xmlns=”urn:jboss:module:1.3" name=”com.oracle”>
           <resources>
                 <resource-root path=”ojdbc8.jar”/>
            </resources>
            <dependencies>
                 <module name=”javax.api”/>
                 <module name=”javax.transaction.api”/>
             </dependencies>
        </module>

standalone.xml

 <datasource jndi-name="java:jboss/datasources/KeycloakDS" pool-name="KeycloakDS" enabled="true" use-java-context="true" statistics-enabled="${wildfly.datasources.statistics-enabled:${wildfly.statistics-enabled:false}}">
                <connection-url>jdbc:oracle:thin:@myoracledB:1525/orcl</connection-url>
                <driver>oracle</driver>
                <security>
                    <user-name>userame</user-name>
                    <password>pwd</password>
                </security>
				<pool>
					<max-pool-size>20</max-pool-size>
				</pool>
            </datasource>

           <driver name="oracle" module="com.oracle">
					<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
					<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
		   </driver>

<default-bindings context-service="java:jboss/ee/concurrency/context/default" datasource="java:jboss/datasources/keycloakDS" managed-executor-service="java:jboss/ee/concurrency/executor/default" managed-scheduled-executor-service="java:jboss/ee/concurrency/scheduler/default" managed-thread-factory="java:jboss/ee/concurrency/factory/default"/>

    <spi name="connectionsJpa">
            <provider name="default" enabled="true">
                <properties>
                    <property name="dataSource" value="java:jboss/datasources/KeycloakDS"/>
                    <property name="initializeEmpty" value="true"/>
                    <property name="migrationStrategy" value="update"/>
					<property name="driverDialect" value="org.hibernate.dialect.Oracle19cDialect"/>
                    <property name="migrationExport" value="${jboss.home.dir}/keycloak-database-update.sql"/>
                </properties>
            </provider>
        </spi>

With above configuration, I’m getting below error:

ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation (“add”) failed - address: ([(“deployment” => “keycloak-server.war”)]) - failure description: {
“WFLYCTL0412: Required services that are not installed:” => [“jboss.naming.context.java.jboss.datasources.keycloakDS”],
“WFLYCTL0180: Services with missing/unavailable dependencies” => [“jboss.naming.context.java.module.auth.auth.DefaultDataSource is missing [jboss.naming.context.java.jboss.datasources.keycloakDS]”]
}
18:25:50,229 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation (“add”) failed - address: ([
(“subsystem” => “datasources”),
(“data-source” => “KeycloakDS”)
]) - failure description: {
“WFLYCTL0412: Required services that are not installed:” => [“jboss.jdbc-driver.oracle”],
“WFLYCTL0180: Services with missing/unavailable dependencies” => [
“jboss.driver-demander.java:jboss/datasources/KeycloakDS is missing [jboss.jdbc-driver.oracle]”,
“org.wildfly.data-source.KeycloakDS is missing [jboss.jdbc-driver.oracle]”
]
}
18:25:50,378 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation (“add”) failed - address: ([
(“subsystem” => “datasources”),
(“data-source” => “KeycloakDS”)
]) - failure description: {
“WFLYCTL0412: Required services that are not installed:” => [
“jboss.jdbc-driver.oracle”,
“jboss.jdbc-driver.oracle”
],
“WFLYCTL0180: Services with missing/unavailable dependencies” => [
“jboss.driver-demander.java:jboss/datasources/KeycloakDS is missing [jboss.jdbc-driver.oracle]”,
“org.wildfly.data-source.KeycloakDS is missing [jboss.jdbc-driver.oracle]”,
“org.wildfly.data-source.KeycloakDS is missing [jboss.jdbc-driver.oracle]”
]
}

tried to figure-out the solution, but not successfull… Can anybody help

Thanks in advance…