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?
@rangareddy37533 жыл бұрын
Hi @Veerababu, could you please help me in understanding the same in Windows using console
@LearningJboss3 жыл бұрын
I guess there is no difference
@rnt8026 жыл бұрын
"WFLYJCA0040: failed to invoke operation: WFLYJCA0047: Connection is not valid" This error appears and does not work =(
@aniruddhakamdi37075 жыл бұрын
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]"
@LearningJboss5 жыл бұрын
In domain mode make sure you have to keep oracle driver modules in all the machines ( master,slave1 ..... etc )
@aniruddhakamdi37074 жыл бұрын
@@LearningJboss thanks , it helped
@kumarkoruturu81872 жыл бұрын
Hi Sir .. nice video Could you please provide that war file and text file sir
@LearningJboss2 жыл бұрын
Share your email
@vineelkumar8753 жыл бұрын
hi guys please let me know url to download database