Javamigrate-kafka-to-oracle

Kafka App Step 3

Migration step that adds transactional database writes to the Kafka-to-TxEventQ consumer.

JSONDuality ViewsTxEventQKafka#Duality Views#Java#JSON#Kafka#TxEventQ
What this sample helps you learn

This module is step 3 of the [Kafka-to-TxEventQ migration sample](../README.md). It builds on the OSON-based messaging flow from step 2 and adds transactional database writes on the consumer side.

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.

Duality Views

Document-shaped access over relational tables using JSON Relational Duality Views.

Use when APIs need JSON documents without giving up relational storage, SQL, constraints, and transactions.

TxEventQ

Transactional queues for database-backed events and messaging.

Use when event delivery and data changes need the same transaction boundary.

Kafka

Kafka-compatible eventing and migration paths backed by Oracle AI Database queues.

Use when comparing separate-broker designs or moving Kafka-shaped workloads toward database-native eventing.

Highlights

  • Java 21+
  • Maven 3.9+
  • Oracle AI Database Free running on localhost:1521
  • The testuser schema and TxEventQ grants created with ../testuser.sql