Samples in this directory demonstrate how Oracle AI Database treats JSON as a first-class data model, including JSON Relational Duality Views and binary JSON payload handling from Java applications.
| Sample | Description |
|---|---|
| jpa-duality-views | Generate JSON Relational Duality Views from Spring Data JPA entities, persist JSONB payloads, and exercise full CRUD flows backed by Oracle Database Free and Testcontainers. |
| crud-duality-views | Run CRUD operations against a JSON Relational Duality View using Oracle JDBC, OSON serialization, and Testcontainers-powered integration tests. |
| jdbc-json-basic | Work with the Oracle JSON data type via JDBC: bind OracleJsonObject payloads, query with SQL/JSON operators, and validate the flow with Testcontainers. |
| jdbc-json-analytics | Perform advanced SQL/JSON analytics with JSON_TABLE, JSON_EXISTS, and JSON_ARRAYAGG over nested order documents using plain JDBC. |
| json-event-streaming | Publish and consume Oracle JSON documents over OKafka, streaming OSON payloads through Transactional Event Queue topics with integration tests. |
- Java 21+
- Maven 3.9+
- Docker Desktop or another OCI-compatible container runtime (required for Testcontainers-based integration tests)