Java json

CRUD with JSON Relational Duality Views

JDBC CRUD sample for JSON Relational Duality Views with OSON and Testcontainers.

#Duality Views#Java#JSON#Testcontainers
What this sample helps you learn

[Click here for the in-depth blog](https://andersswanson.dev/2026/02/24/hands-on-crud-with-jdbc-and-json-relational-duality-views/)

Highlights

  • Serialize Java records into Oracle OSON using a reusable OSONMapper.
  • Insert JSON payloads into a JDV and retrieve generated keys via JDBC RETURNING.
  • Read JDV rows with JsonParser, map them back to typed objects, and apply json_transform updates.
  • Delete documents through the JDV and cascade relational changes automatically.