Configuring Jetty in Standalone ORDS

thatjeffsmith ORDS 0 Comments

For all of my ORDS demos, I’m running it as a standalone process. There’s no Tomcat or Apache involved – and that’s OK. Your needs may require otherwise, and that’s OK too. When running in a standalone configuration like this, ORDS’ HTTP(S) functionality is being delivered by an embedded Jetty web server. Jetty is an Eclipse project. Very cool stuff …

How to Update the ORDS_PUBLIC_USER Password

thatjeffsmith ORDS 11 Comments

ORDS_PUBLIC_USER is the database user that’s used to create your ORDS connection pool(s). Each database configured with ORDS gets one. When you publish a RESTful Service under HR on database X, ORDS resolves the call to the proper jdbc connection pool, then proxy connects from ORDS_PUBLIC_USER to user HR, and runs the SQL or PL/SQL. So, now imagine what happens …

ORDS, RESTful Services, and $URI

thatjeffsmith ORDS 5 Comments

Someone asked: I see reference to a ‘$URI’ in an ORDS GET Handler example, can you explain what this is? Yes. Or, I can with the help of some of our DOCS. The appropriate section would be: Columns in result sets whose first character is $ are given special treatment, they are assumed to denote columns that must be transformed …

Auto REST with ORDS: An Overview and What’s Next?

thatjeffsmith ORDS 0 Comments

In the current issue of Oracle Magazine, you can read all about how to get started with the Auto REST feature of Oracle REST Data Services…or in other words, how to automatically make Tables and Views available via REST APIs. A table or view is very easy to consider as a resource in the REST model. What ORDS does is …

Parameters and Binds for your RESTful Services

thatjeffsmith ORDS 0 Comments

I have a very simple, and not very elegant stored procedure. CREATE OR REPLACE PROCEDURE ADD_EMP ( P_EMP_NAME IN SIMPLE_EMP.name%TYPE, P_EMP_SALARY IN SIMPLE_EMP.SALARY%TYPE, P_OUT_ID OUT SIMPLE_EMP.id%TYPE, P_OUT_TOTAL OUT INTEGER ) AS BEGIN INSERT INTO SIMPLE_EMP (name, SALARY) VALUES (P_EMP_NAME, P_EMP_SALARY) RETURN id INTO P_OUT_ID;   SELECT COUNT(id) INTO P_OUT_TOTAL FROM SIMPLE_EMP;   EXCEPTION WHEN OTHERS THEN HTP.print(SQLERRM); END; Sidebar: Like, …