Jboss EAP 7 - Oracle XE Datasource configuration

[@navdeepbhatia5030]

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)

[@amalnv4721]

I am not able to unwrap oracle connection. How can I use oracle features like Array descriptor in code?

[@rangareddy3753]

Hi @Veerababu, could you please help me in understanding the same in Windows using console

[@LearningJboss]

I guess there is no difference

[@rnt802]

"WFLYJCA0040: failed to invoke operation: WFLYJCA0047: Connection is not valid" This error appears and does not work =(

[@aniruddhakamdi3707]

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]"

[@LearningJboss]

In domain mode make sure you have to keep oracle driver modules in all the machines ( master,slave1 ..... etc )

[@aniruddhakamdi3707]

@@LearningJboss thanks , it helped

[@kumarkoruturu8187]

Hi Sir .. nice video Could you please provide that war file and text file sir

[@LearningJboss]

Share your email

[@vineelkumar875]

hi guys please let me know url to download database

[@vineelkumar875]

oracle database file needed