Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 SODA for Java

• SODA for Java Prerequisites
• SODA for Java Overview
• Using SODA for Java
  • Getting Started with SODA for Java
  • Creating a New Document Collection with SODA for Java
  • Opening an Existing Document Collection with SODA for Java
  • Checking Whether a Given Collection Exists with SODA for Java
  • Discovering Existing Collections with SODA for Java
  • Dropping a Document Collection with SODA for Java
    • If You Need To Drop and Re-Create a Collection...
  • Creating and Using Documents with SODA for Java
  • Handling Transactions with SODA for Java
  • Inserting Documents into Collections with SODA for Java
  • Saving Documents into Collections with SODA for Java
  • Finding Documents in Collections with SODA for Java
  • Replacing Documents in a Collection with SODA for Java
  • Removing Documents from a Collection with SODA for Java
  • OracleOperationBuilder Methods, Terminal and Nonterminal
  • Using Filter Specifications (QBEs) with SODA for Java
    • Sample JSON Documents
    • Using Paths in QBEs
    • Using QBE Basic Field Operators
    • Using QBE Logical Combining Operators
    • Using Logical Operator $not
    • Using Nested Conditions
    • Using QBE Operator $id
    • Using QBE Operator $orderby
    • Querying With a Filter Specification
• SODA Paths
• SODA Filter Specifications (QBEs)
  • Composite Filters
    • Orderby Clause Sorts Selected Objects
  • Filter Conditions
    • Basic Field Clause
    • Logical Clause
      • Omitting $and
    • Nested-Condition Clause
    • Special-Criterion Clause
      • ID Clause
• SODA Collection Metadata Caching
  • Enabling Collection Metadata Caching
  • Shared Collection Metadata Cache
  • Local Collection Metadata Cache
• SODA Collection Configuration Using Custom Metadata
  • Getting the Metadata of an Existing Collection
  • Creating Custom Metadata for a Collection
  • Collection Metadata Components
    • Schema
    • Table or View
    • Key Column Name
    • Key Column Type
    • Key Column Max Length
    • Key Column Assignment Method
    • Key Column Sequence Name
    • Content Column Name
    • Content Column Type
    • Content Column Max Length
    • Content Column JSON Validation
    • Content Column SecureFiles LOB Compression
    • Content Column SecureFiles LOB Cache
    • Content Column SecureFiles LOB Encryption
    • Version Column Name
    • Version Column Generation Method
    • Last-Modified Time Stamp Column Name
    • Last-Modified Column Index Name
    • Creation Time Stamp Column Name
    • Media Type Column Name
    • Read Only

A SODA for Java Core Interfaces

Index