PL/SQL Connector Builder Types

RawJDBC Connector Builder

• Generates plain Java JDBC code (implementation classes and transfer objects) to call PL/SQL programs and work with database objects.
• Requires a standard database connection.
• Ideal for unit tests and scenarios where you want to manage transactions programmatically.
• Offers a minimal, low-level connector style with little abstraction.

Java RPC Connector Builder

• Generates a clean service layer with interfaces, following familiar Java EE-style patterns.
• Each call runs within its own transaction, so no additional transaction handling is required.
• Best suited for Spring / Spring Boot and simple Java factory-based setups.

Batch/Stream Processor

• The Batch/Stream Processor is available in two variants: one built on the RawJDBC Connector and one built on the Java RPC Connector.
• Requires a single strongly typed cursor returned by a PL/SQL procedure or function.
• Generates a Java Stream that reads the cursor row-by-row, enabling direct processing without loading the full result set into memory.

Java EE Connector Builder

• Generates the Java JDBC access code to call the PL/SQL program code and generates Java EE Beans using Java EE Datasources.

MicroProfile Connector Builder

• Generates the Java JDBC access code to call the PL/SQL program code and generates MicroProfile Beans using MicroProfile Datasources.

RMI Connector Builder

• Generates both client and server code for the complete RMI remote infrastructure.