Experiencing JSON in Oracle Autonomous Database for Cloud Native Geeks in less than 15 Minutes


Oracle DB has been supporting JSON for quite some time, but you probably didn't know it! Let's se how easy is to start puting and geting json data in it. The most quick way to get a JSON db up and running is creating an Autonomous Transaction Processing instance. Create the instance and forget there … Continue reading Experiencing JSON in Oracle Autonomous Database for Cloud Native Geeks in less than 15 Minutes

Microservices and SODA: JSON Data Stored in an Oracle Database Accessed through​ REST or Java


Simple Oracle Document Access SODA (Simple Oracle Document Access) is a non-SQL style of storing/retrieving JSON data in an Oracle database. It's so easy to work with SODA! Let's get started. First, enable ORDS schema in your database. Second, deploy ORDS in K8s (you can also deploy ORDS standalone in your laptop or in a container … Continue reading Microservices and SODA: JSON Data Stored in an Oracle Database Accessed through​ REST or Java

Setup ORDS in a PDB


ORDS utilizes several schemas for working properly. Follow these steps just in case your database hasn't been set up. NOTE: you need DBA privileges as well as 2 tablespaces created before proceeding, ask your dba or get this info before starting (although you can also manage it on the fly if you have a few … Continue reading Setup ORDS in a PDB

Creating a Java Microservice with Helidon/Microservice Archetype Deployed in Kubernetes


With Helidon you can create Java microservices easily. In this blog, we are creating/exposing a REST service that gets a JSON document stored in an Oracle database and retrieves it to the requestor. For retrieving the JSON document from the database we are using ORDS and SODA but you can use JDBC as well, we'll show … Continue reading Creating a Java Microservice with Helidon/Microservice Archetype Deployed in Kubernetes

Deploy ORDS (Oracle Rest Data Services) to Kubernetes Cluster


ORDS is a piece of software that acts as an intermediary between Oracle Database and the layers where business logic is implemented and/or consumed. NOTE: If your database hasn't been set up for ORDS just google for it or take a look at this post. With ORDS you expose database objects as REST. ORDS can be … Continue reading Deploy ORDS (Oracle Rest Data Services) to Kubernetes Cluster