Uploaded image for project: 'HAL'
  1. HAL
  2. HAL-1670

Cannot add Oracle URL to XA Datasource

XMLWordPrintable

    • Hide

      Navigate to subsystems->datasources & drivers, then click to add an XA datasource.
      When prompted on step 4 to enter properties, provide:
      URL=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx)(PORT=1521))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=xxxx)))

      Press enter to confirm

      Show
      Navigate to subsystems->datasources & drivers, then click to add an XA datasource. When prompted on step 4 to enter properties, provide: URL=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx)(PORT=1521))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=xxxx))) Press enter to confirm

      When using the admin console to add a new XA datasource, entering an Oracle formatted datasource URL like below fails with the following message:

      URL=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xx)(PORT=1521))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=xxxx)))
      
      Invalid format. Add new properties as key=value pairs, the special character allowed in the value are: - . : @ ; = ? ! # $ % & [ ]
      

      This is a valid Oracle URL that should be allowed in the configuration.

              istudens@redhat.com Ivo Studensky
              rhn-support-tcowhey TJ Cowhey
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: