What this sample helps you learn
This module demonstrates Oracle Text JSON full-text search over plain JDBC on Oracle AI Database. The sample shows how to:
What this sample demonstrates
JSON
Document-shaped data and SQL/JSON querying inside Oracle AI Database.
Use when records need flexible structure without leaving SQL, indexes, constraints, and transactions.
Highlights
- load JSON documents from src/main/resources/documents.json
- store those documents in a native JSON column using OSON/JDBC JSON binding
- create a JSON search index with CREATE SEARCH INDEX ... FOR JSON
- run ranked json_textcontains queries with SCORE