Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-3808

jdbcURL Oracle with multiple database url connection gets an error on EJB Timer Datasource

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Critical
    • 7.12.1.GA
    • 7.10.0.GA, 7.10.1.GA
    • Kie-Server
    • None
    • Openshift 4.6 using KieApp RHPAM 7.10-1 Operator 7.11

    • 2021 Week 40-42 (from Oct 4), 2021 Week 43-45 (from Oct 25), 2021 Week 46-48 (from Nov 15), 2021 Week 49-51 (from Dec 6th), 2022 Week 02-04 (from Jan 10)

    Description

      When you try to configure the jdbcUrl in the KieApp using multiple database URLs like this:

      jdbcUrl="jdbc:oracle:thin:@(DESCRIPTION=

      (LOAD_BALANCE=on)

      (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=1521))) (CONNECT_DATA=(SERVICE_NAME=service_name)))"

      Then RHPAM prints an INFO with a syntax error like this:
      INFO EJB Timer will be auto configured if any datasource is configured via DB_SERVICE_PREFIX_MAPPING or DATASOURCES envs. INFO configuring EJB Timer Datasource based on DATASOURCES env /opt/eap/bin/launch/jboss-kie-kieserver.sh: eval: line 171: syntax error near unexpected token `(' /opt/eap/bin/launch/jboss-kie-kieserver.sh: eval: line 171: `EJB_TIMER_XA_CONNECTION_PROPERTY_URL=jdbc:oracle:thin:@(DESCRIPTION=(CONNECT_TIMEOUT= 20)(RETRY_COUNT=3)(RETRY_DELAY=3)(TRANSPORT_CONNECT_TIMEOUT=3 sec)(ADDRESS_LIST =(LOAD_BALANCE=on)(ADDRESS = (PROTOCOL = TCP)(HOST=some.host2.com)(PORT=1521))(ADDRESS = (PROTOCOL = TCP)(HOST=some.host2.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME = serviceName))'

      Attachments

        Activity

          People

            rhn-support-fspolti Filippe Spolti
            rhn-gps-pamenon Paulo Menon (Inactive)
            Karel Suta Karel Suta
            Karel Suta Karel Suta
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: