Java EE (Java Enterprise Edition) General Discussion

Hi,
when creating the REST Enabled SQL reference, don't add the ~/_/sql~ to the URL; so simply use
http://<host>/<ORDS war file>/EDW/edw_myit_service/
Note that for REST Enabled SQL the user name as well as the password are case sensitive; so you typically need to enter the user name in upper case.
regards
-Carsten

Hi Carsten
Url is without the "_/sql"
Checked and double checked user. Authenticating using a user/pwd stored in Tomcat (tomcat-users.xml). However also tried the schema owner (uppercase) and the same message appears telling me the schema is not rest enabled when both curl and Insomnia work with either user/password.

Using Ords 19.4.6 and APEX 20.1

Hi,
OK - so we might need to check generic HTTP connectivity. Can you navigate to SQL Workshop > SQL Commands and execute the following:

declare
    l_clob clob;
begin
    apex_web_service.g_request_headers( 1 ).name := 'Content-Type';
    apex_web_service.g_request_headers( 1 ).value := 'application/json';


    l_clob := apex_web_service.make_rest_request( 
                  p_url         => 'http://..../EDW/edw_myit_service', 
                  p_http_method => 'POST',
                  p_username    => '...',
                  p_password    => '...',
                  p_body        => '{"statementText":"select sysdate from dual"}' );


    htp.p( l_clob );
end;

This should be the equivalent to your "curl" command. Do you see the REST Enabled SQL response JSON ...?
regards
-Carsten