Oracle REST Data Services 101

Подписаться 9 тыс.

Просмотров 12 тыс.

50% 1

A primer on all things JSON, REST, HTTP - and how ORDS brings those together for Oracle Database.
This longer presentation explains how a GET or POST request turns into a database operation, and how ORDS helps you define the response code header, and body.
TOC:
1:15 Why REST?
7:30 HTTP, REST, & JSON
11:04 Requests & Responses
16:06 Putting it all together in ORDS
21:51 HTTPS & Security
29:27 REST and ORDS
34:32 JSON and ORDS
Follow-up lessons:
Building a REST Service • Oracle REST Data Servi...
Securing a REST Service • Securing an Oracle Dat...
General Information and Examples www.thatjeffsmith.com/oracle-...

Наука

Опубликовано:

23 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 18

@paull9137 2 года назад

I really enjoyed the comment at 33:34! I can relate regarding the extra noise. Thanks for the vid.

@JeffSmiththat 2 года назад

Thanks Paul, I'm still cringing.

@jayshreehindwani6027 4 года назад

Can we have some examples of calling rest procedures through pl/SQL blocks instead of other tools

@JeffSmiththat 4 года назад

here you go www.thatjeffsmith.com/archive/2020/05/calling-ords-from-inside-the-database/

@bifinus 4 года назад

ORDS 19.4.5 will be posted for open download or search on a metalink? Is he there?

@JeffSmiththat 4 года назад

ords 19.4.6 is available now and version 20.2 will be available SHORTLY

@uttarakhandlover884 3 года назад

Jeff. I have client id and secret. Could you please tell that how can i generate the token with given url.

@JeffSmiththat 3 года назад

curl -i -k \ --user [client_id]:[client_secret] \ --data "grant_type=client_credentials" \ yourserver:port/ords/user/oauth/token

@docflexis9052 2 месяца назад

Hi Jeff my Oracle Apex GO button is disabled .Kindly guide me on how to enable it.

@JeffSmiththat 2 месяца назад

Did you install apex, and then install ORDS? ORDS when it is installed/configured, should see that APEX is there, and auto set itself up to support it. if you go to ords/apex instead of ords/ - does it bring up APEX? Do you see any error messages as the ords startup routine runs?

@docflexis9052 2 месяца назад

@@JeffSmiththat Yes I did install Apex first then followed by ORDS. However that is sorted now. I am getting a new error after clicking the GO button. This is the error: Not Found HTTP Status Code: 404. The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured.

@JeffSmiththat 2 месяца назад

See my other questions in previous reply @@docflexis9052

@mikhaill244 2 года назад

Hi Jeff. 1. What was this movie at 7:08? 2. It would be great if you showed how to create and use REST from scratch in SQL Developer or SQL Developer Web. Some kind of practical example. For example, step 1 - installing REST, step 2 - creating REST in SQL Developer, step 3 - test service in a browser.

@JeffSmiththat 2 года назад

1. Train to Busan www.imdb.com/title/tt5700672/ 2. I do exactly this in this newer, shorter video :) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-1LBmLTe8sIc.html

@mikhaill244 2 года назад

Thank you, Jeff. I will definitely watch your new video.

@MohamedFouad2 3 года назад

I have a question please Mr. Jeff. I decided to use SYS_GUID() to generate my id for the table of which datatype is RAW (44), So it looks like that ... CREATE TABLE "EAMI_EMPLOYEES" ( "EMP_ID" RAW(44) DEFAULT SYS_GUID(), ... ) It works pretty well in the database itself. But in the API response I don't get the GUID value of the "EMP_ID" field right. It's something else like "Km/8UAx2R5e5exutZrnXkA==" While it is something like "2A6FFC500C764797B97B1BAD66B9D790" in the database. Could you please help me with this problem? Thanks in advance!

@MohamedFouad2 3 года назад

I resolved it by using RawToHex(EMP_ID)

@JeffSmiththat 3 года назад

Probably need to use a function on the RAW column, we're probably encoding it...I'll do up an example for you shortly.