Details

    • Type: Feature Request
    • Status: Triage (View Workflow)
    • Priority: Optional
    • Resolution: Unresolved
    • Affects Version/s: 9.0.0
    • Fix Version/s: None
    • Component/s: Containers, Database
    • Labels:
      None
    • Docs QE Status:
      NEW
    • QE Status:
      NEW

      Description

      Oracle defines two types of connection string:

      1. jdbc:oracle:thin:HOSTNAME:PORT:SID
      2. jdbc:oracle:thin:HOSTNAME:PORT/SERVICENAME

      The docker image uses the first format, but when using oracle's connection manager you have to use the second one.
      Please add the option to do so

      My solution (intuitive - I don't understand jboss-cli.sh enough to make a PR):
      in file `server/tools/cli/databases/oracle/change-database.cli` change the relevant line to:

      /subsystem=datasources/data-source=KeycloakDS: add(jndi-name=java:jboss/datasources/KeycloakDS,enabled=true,use-java-context=true,use-ccm=true, connection-url=jdbc:oracle:thin:@${env.DB_ADDR:oracle}:${env.DB_PORT:1521}${env.ORACLE_SERVICE_SEPERATOR:":"}${env.DB_DATABASE:XE}${env.JDBC_PARAMS:}, driver-name=oracle)
      

      in file `server/tools/docker-entrypoint.sh` change the line containing `DB_NAME="Oracle";;` to:

      if [[ -z ${ORACLE_SERVICE_SEPERATOR:-} ]]; then
          if [[ -z ${ORACLE_IS_SERVICENAME:-} ]]; then
              ORACLE_SERVICE_SEPERATOR=":"
          else
              ORACLE_SERVICE_SEPERATOR="/"
          fi
      fi
      DB_NAME="Oracle"
      ;;
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                mh.guinness Guin Ness
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: