Oracle AI Database Samples

You may also browse all samples here: https://anders-swanson.github.io/oracle-database-code-samples/

Have a code sample you'd like to contribute? See the contributor guide.

New to Oracle AI Database? Start Here

Navigating this repository

Each module in this project contains a separate Oracle AI Database sample, mainly implemented in Java. Use the README to find a sample you're interested in, or navigate to the directory of your choice.

Samples in other languages

• Python: Python code samples using the python-oracledb driver
• Go: Go code samples using the godror driver.
• Typescript/NodeJS: Typescript code samples using the node-oracledb driver
• PLSQL: Code samples in PL/SQL.

Java Oracle AI Database Code Samples

Collection of Java samples and demo applications using Oracle AI Database, with a focus on the converged database architecture.

Sample Project	Description
AI Vector Search	Implement AI Vector Search with Oracle AI Database over JDBC to find semantically similar documents. The OracleVectorSample class provides a reference implementation for Vector Search with Oracle AI Database.
Database Per Service Example	Demonstrates the database-per-service pattern with separate Oracle AI Database pluggable databases (PDBs), one Spring Boot service per PDB, and an application-layer composition runner.
JDBC Hybrid Search	Combine semantic vector similarity with relational filters and JSON metadata predicates in one Oracle AI Database JDBC query.
JDBC JSON Oracle Text	Demonstrate Oracle Text JSON full-text search over plain JDBC with native JSON columns, JSON search indexes, ranked json_textcontains queries, and NEAR proximity search.
JDBC UUID Primary Keys	Store Java UUID primary keys in Oracle AI Database as compact RAW(16) values using explicit JDBC byte conversion.
LangChain4j Agent Memory	Use LangChain4j with Oracle AI Database as durable agent memory, combining AI Vector Search, Oracle Text over JSON memories, and writeback of new handoff context.
JSON Data and Duality Views	Sample Java applications using the Oracle JSON Data type and Oracle AI Database JSON Relational Duality Views.
Oracle AI Database JDBC Event Streaming	Stream events with Oracle AI Database TxEventQ using plain JDBC! The producer and consumer invoke stored procedures to send and receive asynchronous messages on Oracle AI Database Transactional Event Queues.
Oracle AI Database JDBC Property Graph	Basic Oracle Property Graph sample over JDBC using CREATE PROPERTY GRAPH, GRAPH_TABLE, Testcontainers, and an SVG diagram of the sample vertices, edges, and query results.
Oracle AI Database JDBC Spatial Example	Basic Oracle Spatial sample over JDBC using JGeometry, SDO_FILTER, SDO_WITHIN_DISTANCE, SDO_GEOM.SDO_DISTANCE, and an SVG diagram of the sample geometries and distances.
Oracle AI Database JMS Producer Consumer Example	Example using Oracle AI Database JDBC to produce and consume messages over the JMS API. Includes examples using topics for JMS multi-consumer pub/sub, and JMS queues (point-to-point).
Migrate Apache Kafka to Oracle AI Database TxEventQ	Sample that demonstrates how to migrate an Apache Kafka application to use Oracle AI Database Transactional Event Queues
MCP Agent with SQLcl and Langchain4j	Simple example using Langchain4j's agent SDK to integrate with the SQLcl MCP server for an agentic natural language database interface.
MicroTx Java Sample	Spring Boot service scaffold for an Oracle Transaction Manager for Microservices sample.
News Event Streaming Converged Database App	Demo Converged Database app using Transactional Event Queues, JSON Relational Duality Views, AI Vector Search, and Relational components of Oracle AI Database. The app integrates with OCI GenAI to process, embed, and serve news articles.
Oracle AI Database Kafka APIs	Producer, consumer, and transactional messaging code samples using the Kafka Java Client for Oracle AI Database Transactional Event Queues.
Oracle AI Database E2E Observability	Spring Boot WebMVC/UCP observability lab with JDBC traces, logs, metrics, Oracle AI Database Free, Grafana LGTM, and generated TLS certificates.
ORDS Docker Compose	2-container setup for ORDS using Oracle AI Database Free
ORDS Testcontainers	Run Oracle REST Data Services (ORDS) with Testcontainers against Oracle AI Database Free using a reusable Java container setup.
Sessionless Transactions	Learn how to use Sessionless Transactions to run database operations with no persistent client-side session or connection.
Spring Boot Dynamic Property Source	Demonstrates implementing dynamic Spring Boot property sources using Oracle AI Database as a property store. Valuable for Spring Developers who want to get the most out of their configuration management.
Spring Boot Custom JDBC Tracer	Implement a custom OpenTelemetry tracer for the Oracle AI Database JDBC driver (OJDBC)
Spring Boot OJDBC Tracing	How to trace Oracle AI Database JDBC connections with OpenTelemetry.
Spring Data MongoDB Oracle API	Demonstration of using Oracle AI Database's MongoDB compatible API with Spring Data MongoDB.
Spring JPA Example	Learn Spring JPA by example with Oracle AI Database Free.
Spring Boot CDC with JMS	Create a simple, asynchronous, event-driven CDC implementation using Spring JMS and Oracle AI Database Transactional Event Queues.
Spring Boot Database Client Info	Set database client info in your connections, viewable in views like V$SESSION.
Spring Boot JMS Example	Learn how to use Oracle AI Database Transactional Event Queues with the Java JMS API for asynchronous event-streaming.
Spring Boot JMS Tracing	Sample traces from your Spring JMS applications using Oracle AI Database Transactional Event Queues
Spring Boot Resource Loader	Access Oracle AI Database blobs using the Spring Resource API.
Spring Cloud Config Server	Client/server example using Oracle AI Database as a JDBC backend for Spring Cloud Config
Spring Vault Oracle App	Sample application demonstrating how to dynamically load Oracle Cloud Infrastructure (OCI) Vault key/values as Spring properties leveraging Spring Cloud Oracle.
Support Ticket Intelligence	Spring Boot support workflow sample combining Oracle AI Database TxEventQ, JSON, Oracle Text, vector search, SQL property graph, and JSON Relational Duality Views.
TxEventQ Examples	Assorted messages examples with Oracle AI Database Transactional Event Queues, including Kafka, JMS, PL/SQL, and ORDS.
TxEventQ Multi-Database Propagation	Propagate messages between remote databases using Transactional Event Queues (TxEventQ).
Oracle Testcontainers	Learn how to use the popular Testcontainers library by example with Oracle AI Database Free.

Oracle AI Database Free

This repository uses containerized instances of Oracle AI Database Free for testing. The testcontainers module provides a hands-on example using Oracle AI Database Free to test Java applications on a local machine with throwaway database container instances.

If you're using Oracle AI Database, I highly recommend Oracle AI Database Free + Testcontainers to build modular, simple test cases.