2 Replies Latest reply: Oct 21, 2012 1:56 PM by Krishna Rathnam-Oracle RSS

    APEX Listener 2.0 configuration issue

    Krishna Rathnam-Oracle
      Hi people,

      I have some questions on Apex Listener 2.0 configuration for calling procedures in different schemas within the same database via URL. I wanted access procedures that I created in HR & SCOTT schema in the "orcl" database.

      I have configured the apex listener, deployed the war's on weblogic and I am able access the workspace & Apex admin server console:

      I have also added additional database connections pointing to HR & SCOTT schema using the commands below and provided necessary details when prompted:

      java -jar apex.war setup --database hr
      java -jar apex.war setup --database scott

      I also added some url mapping definitions & my current mapping file is as follows:

      <?xml version="1.0" encoding="UTF-8"?>
      <pool-config xmlns="http://xmlns.oracle.com/apex/pool-config">
      <pool base-path="/" name="hr" updated="2012-10-17T16:33:09.608Z"/>
      <pool base-path="/st" name="scott" updated="2012-10-17T17:09:26.71Z"/>
      <pool base-url="http://aosdemeamt05.oracle.com:7001/apex/st" name="scott" updated="2012-10-17T17:12:35.07Z"/>
      </pool-config>

      The following call to the update_emp_sal procedure redirects to the HR schema and displays the appropriate HTML content I have within that procedure:
      http://aosdemeamt05.oracle.com:7001/apex/update_emp_sal

      The following URL also works fine as I have explicitly qualified the procedure with hr schema:
      http://aosdemeamt05.oracle.com:7001/apex/hr.update_emp_sal

      However, the call to the same procedure in scott schema errors out with 404. The URL I am issuing is http://aosdemeamt05.oracle.com:7001/apex/scott.update_emp_sal, although the procedure is present in the schema.

      I have also tried the following URL's based on the URL mapping definitions I have specified above for scott schema and all of them error out:

      The URL http://aosdemeamt05.oracle.com:7001/apex/st/update_emp_sal errors with the following message. My assumption was that the "/st" base-path will result in a redirection to "scott database" I had created earlier:

      Error Alias "st" does not exist

      I have also made sure to restart the Weblogic AdminServer every time I've added a new database connection or mapping url definition.

      Could someone please guide me on what I am missing here? I am essentially looking to be able to call procedures from different schemas within the same database via URL.

      Thanks a ton.

      Best Regards
      Krishna