Skip to Main Content
  • Questions
  • Make schema/Object for Restfull service.

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Daxesh.

Asked: August 14, 2020 - 9:14 am UTC

Last updated: August 15, 2020 - 6:48 am UTC

Version: 12.2.0.1 AND 11.2.0.4

Viewed 1000+ times

You Asked

I have installed oracle apex developed an application and deploy it on tomcat using ords I followed following steps.
1) After installing apex and developed successful application run scritps
@apex_rest_config.sql
I unlock account APEX_PUBLIC_USER and APEX_REST_PUBLIC_USER .

2) After that I installed tomcat 8.5
3) I download ords.zip and extract it in a directory say c:\ords_install.
4) I make one directory named config-ords under c:\ords_install
5) Edit ords_param.properties under c:\ords_install\param and update parameters values and my file looking like
db.hostname=localhost
db.port=1521
db.servicename=orcl
db.sid=
db.username=APEX_PUBLIC_USER
migrate.apex.rest=false
rest.services.apex.add=
rest.services.ords.add=true
schema.tablespace.default=APEX_TS
schema.tablespace.temp=TEMP
standalone.http.port=8181
standalone.static.images=
user.tablespace.default=USERS
user.tablespace.temp=TEMP

6) java -jar ords.war configdir C:\ords_install\config-ords
7) java -jar ords.war

my ords not configure in standalone mode.

My application nicely work on tomcat but how to I make my schema/Table REST Enable. Please guide me.

my tomcat on Different Machine and Database on Different machine. NOT BOTH ON SAME MACHINE.

and Connor said...

If you are in SQL Developer, create a connection to the schema you want to enable REST for and then just right click on the connection and choose "REST Services > Enable REST Services..."

Or you can do it from the database via a PLSQL call

BEGIN
    ORDS.ENABLE_SCHEMA(p_enabled => TRUE,
                       p_schema => 'MY_SCHEMA',
                       p_url_mapping_type => 'BASE_PATH',
                       p_url_mapping_pattern => 'my_path',
                       p_auto_rest_auth => FALSE);
    COMMIT;
END;


Is this answer out of date? If it is, please let us know via a Comment