Skip to Main Content
Transactional Event Queues: Kafka Java Clients for Oracle Database

About This Workshop

Youtube Video

About This Workshop
This lab walks attendees through the end-to-end process of using Kafka Java client APIs with Oracle TxEventQ. You’ll clone the official sample repo, build and run the Oracle Kafka Java client (okafka) and a demo microservice, create TxEventQ topics, produce messages, and consume them with a Java consumer. The exercises include: (1) running an out-of-the-box Kafka Java app against TxEventQ, (2) migrating a simple Kafka app to TxEventQ, and (3) demonstrating transactional produce/consume patterns and partitioning/rebalancing behavior with Oracle’s Kafka compatibility layer. Practical takeaways include configuration snippets, recommended partition/consumer strategies, and tradeoffs when consolidating streaming into the database.

Workshop Info

1 hour

  • Workshop Modules

  • 1. Introduction & Architecture

  • What is Oracle TxEventQ?
  • How does Kafka compatibility work?
  • Benefits vs. running a separate Kafka cluster
  • Use cases: streaming AI pipelines, event-driven apps, data synchronization

  • 2. Environment Setup 

  • Clone GitHub repo (okafka + sample apps)
  • Verify Java, Maven/Gradle installation
  • Configure connection to Oracle DB (Autonomous or containerized)

  • 3. Quickstart: Kafka Producer/Consumer with TxEventQ

  • Create TxEventQ topic/partition in Oracle DB
  • Run Java producer to publish messages
  • Run Java consumer to consume messages
  • Observe event persistence in Oracle DB
  • Test consumer group rebalancing

  • 4. Migration Exercise (25 min)

  • Take an existing Kafka Java app
  • Swap dependencies to Oracle okafka client
  • Re-run app against TxEventQ
  • Demonstrate transactional produce/consume (atomic DB + event)

  • 5. Advanced Features & Discussion

  • Exactly-once semantics in TxEventQ
  • Scaling consumers with partition rebalancing
  • Integration with other Oracle Database features (analytics, AI/ML pipelines)
  • When to choose TxEventQ vs Kafka

Developer skills / knowledge

  • Comfortable writing/running Java applications (JDK 11+ recommended).
  • Familiarity with Apache Kafka concepts (topics, partitions, producers, consumers, rebalance).
  • Basic SQL and Oracle Database familiarity helpful but not required.

Other Workshops you might like