New Oracle REST Data Services (ORDS) drop today. Per usual, mostly bug fixes And per usual, sometimes we like to sneak in new features as well, and this release is no different. You can now have ORDS automatically create POST handlers for executing your PL/SQL. …
Configuring Jetty in Standalone ORDS
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 …
Five (5) People to Follow On Twitter
I wrote this on LinkedIn, but that platform doesn’t play nice with Flipboard, and not all of you are connected with me there. So, if you Twitter, take a second and follow these people. You can thank me later. If you’re looking to follow even …
How to Update the ORDS_PUBLIC_USER Password
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 …
Release News – What’s On Tap
SQL Developer has averaged about a single major release a year. We’ve also always had an Early Adopter or open beta where we would debut new features, and you could provide feedback. I think this worked – quite well even. But that’s over. Starting later …
Mandatory SQLDev Tip: Filter Your History
It’s Friday! Let’s be honest though – you’ve not accomplished much this week. Monday was a holiday, emails have stacked up, lots of your co-workers are on vacation. So how can we rescue this losing scenario and turn it into a major victory? This trick …
How Do I Get My Charts Out of a Report?
Someone asked, I have this cool report, how do I get the chart out of it? For now I’ve been taking screenshots. So let’s look at how you can get your Report out to HTML (and a PNG.) When I say HTML, I mean you …
Generating a Data Dictionary Report and Diagram for a SubView
Your relational models can get big. Bigger than the human mind can easily consume. So instead of generating a report of 2,500 objects, you might want to break down your model to smaller chunks, AKA SubViews. So let’s open the reports, which you’ll find on …
Thoughts on GLOC Conference and ORDS/REST Demos
I had a very, very enjoyable time at the Great Lakes Oracle Conference this week in Cleveland (OHIO! – Just in case Joel is reading this.) About 400 people attended, and I think it’s become one of the best conferences in the US, esp for …
ORDS, RESTful Services, and $URI
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 …
