Skip to Main Content
  • Questions
  • unable to successfully created Rest Enabled Sql

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Daxesh.

Asked: June 20, 2024 - 10:38 pm UTC

Last updated: June 26, 2024 - 2:29 am UTC

Version: 24.1

Viewed 1000+ times

You Asked

1) I am using oracle xe 21c database, apex 24.1 and deployed on tomcat 9.0.90 on my labtop
2) I try to connect my office server using Rest enabled sql service. Where I rest enabled entire schema
3) On my labtop when I try to connect it giving me error : The URL of this remote server does not point to a REST Enabled SQL service. Please check the details of your REST Enabled SQL service definition.
4) When I write same url in browser and ending with table name it showing the data.
5) Before 24.1 menas in 18.x to 20.x its working.
6) For rest enabled sql require same version of ords both side? Please guide because both side apex version and ords version are different (my labtop and my office server I am try using remotely )
7) At my office I rest enabled schema from sql workshop->restfull service also run the following scripts
BEGIN
ORDS.enable_schema(
p_enabled => TRUE,
p_schema => 'SVM',
p_url_mapping_type => 'BASE_PATH',
p_url_mapping_pattern => 'hr',
p_auto_rest_auth => FALSE
);

COMMIT;
END;
/

PLEASE REFERE THE ATTACHED VIDEO

https://drive.google.com/file/d/1VONL-ngqD53xjnxKLWSzob63qtD-jSdy/view?usp=sharing

same case appear on apex.oracle.com

workspace :[redacted]
username:[redacted]
password :[redacted]
Application id :[redacted]



Rest enabled SQL service name : svm

and Connor said...

Thanks for putting a test case on apex.oracle.com

Check app ID 237846 for the changes I made - basically it was changing the URL to

http://139.167.246.14:8181/svm/vishnu/svm/

and same in the credential.

I got that from these tutorials by the APEX team






Rating

  (2 ratings)

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

Comments

daxesh, June 25, 2024 - 6:24 am UTC

Thank you to pointing me my error / mistake . now it is working.
Connor McDonald
June 26, 2024 - 2:29 am UTC

glad we could help

More to Explore

Security

All of the vital components for a secure database are covered in the Security guide.