What this sample helps you learn
This example application demonstrates how to add client information to Oracle AI Database connections in a Spring Boot application. It sets client identifiers on database connections for better monitoring and tracing. The application includes a simple REST API for managing books, which sets custom client info (MODULE and ACTION) on each connection used in the API operations.
What this sample demonstrates
Spring
Runnable Spring behavior on Oracle AI Database.
Use when Spring needs to be tested against real database behavior.
Observability
Tracing and client metadata samples for following application work into database sessions.
Use when teams need to correlate HTTP, JDBC, JMS, and database activity during operations.
Highlights
- ClientInfoApplication: The main Spring Boot application class that configures the DataSource with client info using a BeanPostProcessor.
- ClientInfoDataSource: A wrapper around the DataSource that applies client info properties to connections.
- BooksController: A REST controller providing CRUD operations for books, using low-level JDBC with custom client info settings (OCSID.MODULE = "Books", OCSID.ACTION = method name).