3 Replies Latest reply on Mar 17, 2016 1:13 PM by PeeZu

    Single ORDS install with Multiple Databases (version 3.0.3)

    Jeremx

      I do not install ORDS with multiple database :

       

      - install :

      java -jar ords.war setup advanced --database DEV

      ..

      ..

      INFO: Completed installation for Oracle REST Data Services version 3.0.3.351.13.24. Elapsed time: 00:00:21.43

       

      java -jar ords.war map-url --type base-path /dev DEV

      ...

       

       

      - I'm testing :

      http://10.XX.XX.XX:8080/ords/dev/ >> works

      Debug Trace

       mapped request using: /dev/* to: dev

       

      - I activated the schema and object (table) :

       

      BEGIN
      ORDS.ENABLE_SCHEMA(p_enabled => TRUE,
         p_schema => 'SISTM',
         p_url_mapping_type => 'BASE_PATH',
         p_url_mapping_pattern => 'sistm',
         p_auto_rest_auth => FALSE);
      
      
          ORDS.ENABLE_OBJECT(p_enabled => TRUE,
                             p_schema => 'SISTM',
                             p_object => 'EXEC_IMP',
                             p_object_type => 'TABLE',
                             p_object_alias => 'exec_imp',
                             p_auto_rest_auth => FALSE);
         
         commit;
        
      end;
      /
      
      

       

      I'm testing :

      http://10.XX.XX.XX:8080/ords/dev/sistm/exec_imp >> don't works

      Debug Trace

      Could not find any dispatcher to handle request:

      --Attributes--

      apex.diagnostic.context = ...

      ECID-Principal = ECIDPrincipal [ecid=u7vOZtJ-0tylATgpcLZTbw..]

      oracle.dbtools.http.ecid = 5XEUAG44FdhGgKzWf_gnoA..

      oracle.dbtools.common.di.Services = Request Scope

      --Attributes--

      GET /ords/dev/sistm/exec_imp HTTP/1.1

      Host: 10.10.10.174

      host: 10.10.10.174:8080

      user-agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:44.0) Gecko/20100101 Firefox/44.0

      accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8

      accept-language: en-US,fr;q=0.8,fr-FR;q=0.5,en;q=0.3

      accept-encoding: gzip, deflate

      connection: keep-alive

      ...

       

       

      Is this a bug or I forgot a step?

       

      Thanks