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…