This discussion is archived
11 Replies Latest reply: Jan 17, 2013 10:10 PM by 983057 RSS

Apex restful service on localhost

983057 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    Having same problem.. please someone help me...
    there is no test button to test service..
  • 2. Re: Apex restful service on localhost
    Udo Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    The problem was in apex listener configuration, in
    standalone mode it don't work , it works only with Glassfish.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points