2 SODA for Java Overview

SODA for Java is a Java API that implements Simple Oracle Document Access (SODA). You can use it with Java to perform create, read (retrieve), update, and delete (CRUD) operations on documents of any kind, and you can use it to query JSON documents.

SODA is a set of NoSQL-style APIs that let you create and store collections of documents in Oracle Database, retrieve them, and query them, without needing to know Structured Query Language (SQL) or how the data in the documents is stored in the database.

Oracle relational database management system (RDBMS) supports storing and querying JSON data. To access this functionality, you need structured query language (SQL) with special JSON SQL operators and Java Database Connectivity (JDBC). SODA for Java hides the complexities of SQL/JSON programming.

The remaining topics of this document describe various features of SODA for Java.

Note:

This book provides information about using SODA with Java applications. To use SODA for Java you also need to understand SODA generally. For such general information, please consult Oracle Database Introduction to Simple Oracle Document Access (SODA).

See Also:

• SODA for Java on GitHub

• SODA for Java Releases

• SODA for Java Javadoc for detailed information about specific Java methods

• https://docs.oracle.com/en/database/oracle/simple-oracle-document-access/ for complete information about SODA and its implementations

• Oracle Database JSON Developer’s Guide for information about using SQL and PL/SQL with JSON data