PL/SQL Enterprise Workbench

26.1.0 (2026-01-25)

PL/SQL Connector Builder:
- Refreshed and updated the PL/SQL Connector Builder.
- Removed the PL/SQL Spring Remoting Connector Builder because it will no longer be supported.
- Removed Java EE client remoting generation. Only server-side generation remains, as client remoting in cloud infrastructure is typically not a useful scenario.
- Added MicroProfile PL/SQL Connector Builder bean generation.
PL/SQL Workbench and editors:
- Improvements in connection handling.

PL/SQL Connector Builder:
- Added Java records as transfer objects (not supported for subclassed user-defined types-subclassed user-defined types are still Java classes).

PL/SQL Enterprise Workbench Eclipse Plugin:
- Requires at least Java 21.
- Requires Eclipse 4.17.x (2024-06).
PL/SQL Enterprise Workbench Maven Plugin:
- Requires at least Java 11.
- Requires at least Maven 3.6.x.
PL/SQL Enterprise Workbench SQL and PL/SQL Development:
- Minor improvements and fixes.
PL/SQL Enterprise Workbench Connector Builder:
- Minor improvements and fixes.

Minor update and fixes.

Production release:

A license key is required to use the PL/SQL Enterprise Workbench and the PL/SQL Connector Builder.

SQL Worksheet
- The SQL Worksheet has been completely remastered, refitted, and optimized.
- Optimized for temporary SQL statements.
- Optimized transaction handling with non-blocking access to other editors.
Script Editor
- The Script Editor has been completely remastered, refitted, and optimized.
- Optimized for persistent scripts in a well-organized folder structure.
- Improved failure handling and error information.
- Optimized transaction handling with non-blocking access to other editors.
PL/SQL Editor
- The PL/SQL Editor has been completely remastered, refitted, and optimized.
- Optimized for a well-organized folder structure.
- Hyperlinks for fast navigation between PL/SQL packages, functions, and procedures.
- Info, warning, and error messages with additional plain information for developers.
- Functions to compile, recompile, and drop objects for full Oracle database development operations.
PL/SQL Connector Builder
- The PL/SQL Connector Builder has been completely remastered, refitted, and optimized.
- The configuration for each PL/SQL Connector Builder is stored in a file.
- A PL/SQL Connector Builder can be run from the Eclipse IDE or from a Maven build.

One-Phase Generator
- Two-phase generator refactored into fully configurable single-phase generators for different use cases (Spring Remoting, Raw JDBC, Java RPC, JEE, Batch, RMI, ...).
- The second layer generates a Java 5 Spring Remoting client layer for an Eclipse RCP application.
- Limited support for data types: only scalar data types, PL/SQL tables, and strong REF CURSOR are supported, with fixed mappings to Java types.
Full support for all data types supported by the Oracle JDBC driver and Oracle JDBC extensions
- Scalar data type support.
- PL/SQL tables.
- Nested tables.
- Zoned date and timestamp data types.
- Subclassed user-defined types.
Support for different Java access strategies for Java transfer objects
- Public attributes.
- Private attributes using getter and setter methods.
- Java records.
Configurable mapping from Oracle to Java data types
- Configurable Oracle numeric to Java numeric data type mappings.
- Configurable Oracle date and timestamp mappings to legacy Date/Timestamp and modern LocalDate/LocalDateTime/ZonedDateTime types.
Fully automated test system
- Oracle JDBC driver tests with all combinations of data types and Oracle JDBC driver versions against Oracle databases: 11g, 12c, 18c, 19c, 21c, 23c, 23ai, and Oracle Autonomous Database.

Two-Phase Generator
- First-phase generator generates Java 1.4 Oracle JDBC access code for the server layer.
- The second layer generates a Java 5 Spring Remoting client layer for an Eclipse RCP application.
- Limited support for data types: only scalar data types, PL/SQL tables, and strong REF CURSOR are supported, with fixed mappings to Java types.