Thanks Sir , Quite useful , Tried the same after installing Oracle 12c R2 and followed the steps shared , It worked (We need to use the jdbc jar file as per the oracle version)
how do we configure oracle with windows via domain mode ? via standalone mode test connection is successful and didn't have to do much but in domain mode it does not work. Windows machine standalone mode : 1) make sure oracle is working, then start the standalone via port offset, load the jboss console, load the ojdbc jar file in container, enable jar file 2) next thing is we create datasource through configuration tab, configuration->subsystem>datasources> choose xa or non xa > select the driver > give connection url hostname as localhost and at after port 1521 type xe > test the connection and its done Its successful domain mode : 1) make sure oracle is working, start via domain.bat , then in modules section go till com folder and create another folder called oracle and put ojdbc file over there, 2) we also have to make some changes in domain.xml under driver we have to add another driver for oracle 3)) load the jar file in container via console, assign it to server group, load the server group 3) create the datasource ... configurations > subsystems> profile of server > datasource > select oracle driver which we created manually in domain.xml file earlier > give driver name and jndi name > local host url with default port and xe, 4) test connection - its failing with below error. 2019-10-10 21:01:13,920 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 66) WFLYCTL0013: Operation ("add") failed - address: ([ ("subsystem" => "datasources"), ("data-source" => "OracleDS_paytm") ]) - failure description: { "WFLYCTL0412: Required services that are not installed:" => ["jboss.jdbc-driver.oracle"], "WFLYCTL0180: Services with missing/unavailable dependencies" => [ "org.wildfly.data-source.OracleDS_paytm is missing [jboss.jdbc-driver.oracle]", "jboss.driver-demander.java:/OracleDS_paytm is missing [jboss.jdbc-driver.oracle]"
