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.
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;