How to Update the ORDS_PUBLIC_USER Password

thatjeffsmith ORDS 10 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 …

Release News – What’s On Tap

thatjeffsmith SQL Developer 26 Comments

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 this year, you’ll see us put our product (SQLDev, Data Modeler, SQLcl, ORDS) release updates …

Mandatory SQLDev Tip: Filter Your History

thatjeffsmith SQL Developer 2 Comments

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 will save you so much time, you’ll be mad I didn’t make you learn it …

Generating a Data Dictionary Report and Diagram for a SubView

thatjeffsmith SQL Developer 5 Comments

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 the main File menu. First, we don’t want the main diagram in the report, that’ll …

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 …