Hide Forgot
Description of problem: I cannot start portal configured to use JTA (two separate XA Datasources) according to https://docs.jboss.org/author/display/GTNPORTAL38/JTA+integration with Oracle databases There are links to logs: https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/EPP/view/EPP/view/6.2/view/UI%20Database%20Support/job/epp6_ui_selenium_tests_db_oracle11gR1/147/consoleText https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/EPP/view/EPP/view/6.2/view/UI%20Database%20Support/job/epp6_ui_selenium_tests_db_oracle11gR2/125/consoleText https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/EPP/view/EPP/view/6.2/view/UI%20Database%20Support/job/epp6_ui_selenium_tests_db_oracle11gR2RAC/133/consoleText https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/EPP/view/EPP/view/6.2/view/UI%20Database%20Support/job/epp6_ui_selenium_tests_db_oracle11gR1RAC/181/consoleText https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/EPP/view/EPP/view/6.2/view/UI%20Database%20Support/job/epp6_ui_selenium_tests_db_oracle12c/29/consoleText
It's failing because both datasources are using same oracle database, which doesn't work correctly with JTA. I've added warning into https://docs.jboss.org/author/display/GTNPORTAL38/JTA+integration section 2.b. For testing it with XA datasources, you need to ensure that either: - Both datasources are using different database - Portal is using shared XA datasource for both IDM and JCR
I tested with oracle11gR1 for IDM xa-datasource and oracle11gR2 for JCR xa-datasource (separate ds scenario). Portal started without errors and I didn't encounter any problems while doing a quick manual test.
Verified in 6.2.0.ER8. Clean startup & manual CRUD test with navigation node and user. DS combinations, IDM + JCR: a) 11gR1 + 11gR2 b) 11gR1RAC + 11gR2RAC c) 11gR2 + 12c