11 Replies Latest reply: Jan 18, 2013 12:10 AM by 983057 RSS

    Apex restful service on localhost

    983057
      I have install Apex 4.2.1 on 11g o my localhost
      while creating a restful services i am not getting "test" and "bind variable" buttons.
      and i can't access the restful service.. please give me some idea

      Edited by: 980054 on Jan 5, 2013 1:33 AM
        • 1. Re: Apex restful service on localhost
          NehaPatil
          Having same problem.. please someone help me...
          there is no test button to test service..
          • 2. Re: Apex restful service on localhost
            Udo
            Hello,

            sorry for the late response...
            Which APEX Listener version do you use?
            Please note that RESTful services in APEX 4.2 only work with APEX Listener 2, no earlier release and no other web server for APEX (i.e, not with OHS or EPG).

            -Udo
            • 3. Re: Apex restful service on localhost
              983057
              Thank you Udo,

              I have already installed Apex listener 2 on Weblogic server but it gives 404 page not found error. then I tried to install in standalone mode, but it gives page not found. So now what should i do ?, I google but no post on how to reinstall apex listener or how to remove apex listener, so that i can reinstall listener.. plese help me.

              -Jigar Parekh.

              Edited by: 980054 on Jan 11, 2013 8:49 PM
              • 4. Re: Apex restful service on localhost
                Udo
                Removing would be just undeploying. But I don't think this will really help you.
                If you don't see these buttons, probably either something with your browser or with your static contents ("images") is wrong.
                I have already installed Apex listener 2 on Weblogic server but it gives 404 page not found error.
                On which occasion do you get that 404?

                -Udo
                • 5. Re: Apex restful service on localhost
                  Colm Divilly
                  If the test and bind variables buttons are hidden, it is because APEX has RESTful Services disabled. Please double check you have followed all steps in the APEX 4.2.1 install guide including the additional steps requried to enable RESTful Services. If you continue to have problems it would be worth posting the issue in the APEX forum.

                  Regards,
                  Colm
                  • 6. Re: Apex restful service on localhost
                    983057
                    hi Colm
                    I have check and followed all the steps to enable the restful services. still while checking listener it shows 404 page not found. and also i am unable to see Oracle XE home page. it gives data not found.
                    • 7. Re: Apex restful service on localhost
                      983057
                      Hi

                      I have installed oracle 11g on a new PC, and install apex but still the problem remains same, TEST button is hidden.
                      I start apex listener in standalone mode

                      C:\Temp>java -jar apex.war
                      Jan 17, 2013 2:33:48 PM oracle.dbtools.standalone.Standalone execute
                      INFO: NOTE:

                      Standalone mode is designed for use in development and test environments. It is
                      not supported for use in production environments.

                      Jan 17, 2013 2:33:48 PM oracle.dbtools.standalone.Standalone execute
                      INFO: Starting standalone Web Container in: C:\Temp\temp\apex
                      Jan 17, 2013 2:33:48 PM oracle.dbtools.standalone.Deployer deploy
                      INFO: Will deploy application path = C:\Temp\temp\apex\apex\WEB-INF\web.xml
                      Jan 17, 2013 2:33:48 PM oracle.dbtools.standalone.Deployer deploy
                      INFO: Deployed application path = C:\Temp\temp\apex\apex\WEB-INF\web.xml
                      Jan 17, 2013 2:33:48 PM oracle.dbtools.common.config.file.ConfigurationFolder l
                      gConfigFolder
                      INFO: Using configuration folder: C:\Temp\temp\apex
                      Configuration properties for: apex
                      cache.caching=false
                      cache.directory=/tmp/apex/cache
                      cache.duration=days
                      cache.expiration=7
                      cache.maxEntries=500
                      cache.monitorInterval=60
                      cache.procedureNameList=
                      cache.type=lru
                      db.hostname=localhost
                      db.password=******
                      db.port=1521
                      db.sid=xe
                      debug.debugger=false
                      debug.printDebugToScreen=false
                      error.keepErrorMessages=true
                      error.maxEntries=50
                      jdbc.DriverType=thin
                      jdbc.InactivityTimeout=1800
                      jdbc.InitialLimit=3
                      jdbc.MaxConnectionReuseCount=1000
                      jdbc.MaxLimit=10
                      jdbc.MaxStatementsLimit=10
                      jdbc.MinLimit=1
                      jdbc.statementTimeout=900
                      log.logging=false
                      log.maxEntries=50
                      misc.compress=
                      misc.defaultPage=apex
                      security.disableDefaultExclusionList=false
                      security.maxEntries=2000
                      db.username=apex_public_user
                      Using JDBC driver: Oracle JDBC driver version: 11.2.0.3.0
                      Jan 17, 2013 2:33:50 PM oracle.dbtools.rt.web.SCListener contextInitialized
                      INFO: Oracle Application Express Listener initialized
                      Application Express Listener version : 2.0.0.354.17.06
                      Application Express Listener server info: Grizzly/1.9.49

                      Jan 17, 2013 2:33:50 PM com.sun.grizzly.Controller logVersion
                      INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 1/17/13 2:33 PM
                      Jan 17, 2013 2:33:50 PM oracle.dbtools.standalone.Standalone execute
                      INFO: http://localhost:9999/apex started.

                      http://localhost:9999/apex - gives blank page
                      and
                      http://localhost:9999/apex/listenerconfigure - gives 404 page not found

                      Edited by: 980054 on Jan 17, 2013 1:09 AM
                      • 8. Re: Apex restful service on localhost
                        Colm Divilly
                        Parekh, please make sure you have reviewed the Listener install guide and release notes, there is no /apex/listenerConfigure URL in 2.0.0 as the web based UI has been superceded by a SQL Developer based UI.

                        Edited by: Colm Divilly on Jan 17, 2013 8:47 AM
                        • 9. Re: Apex restful service on localhost
                          983057
                          hi
                          thanx for a help , finally i install apexlistener on Glassfish server and now everything works fine.
                          Now Test button is visible.

                          Edited by: Parekh Jigar on Jan 17, 2013 10:11 PM
                          • 10. Re: Apex restful service on localhost
                            983057
                            The problem was in apex listener configuration, in
                            standalone mode it don't work , it works only with Glassfish
                            • 11. Re: Apex restful service on localhost
                              983057
                              The problem was in apex listener configuration, in
                              standalone mode it don't work , it works only with Glassfish.