25.1.1 (2025-05-22)

Minor update and fixes.

25.1.0 (2025-04-27)

Going in Production Release:

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

  • Sql-Worksheet
    • Sql-Worksheet are completely remastered, refitted and optimized.
    • Optimized for temporary SQL statements.
    • Optimized transaction handling with non blocking other editors.
  • Script-Editor
    • Script-Editor are completely remastered, refitted and optimized.
    • Optimized for persistent scripts in a well organized folder structure.
    • Good failure handling and error information.
    • Optimized transaction handling with non blocking other editors.
  • PL/SQL-Editor
    • PL/SQL-Editor completely remastered, refitted and optimized.
    • Optimized for for 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 the developer.
    • All functions to compile, recompile and drop objects for full development Oracle DB operations.
  • PL/SQL Connector Builder
    • PL/SQL Connector Builder 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.

End of Beta Phase

Beta39 (2024-07-14)

  • PL/SQL Enterprise Workbench:
    • New Connector Builder for MicroProfile and Angular Services - currently in Experimental State.
    • HR-Example Demonstration for new Connector Builder.
    • Oracle 11g removed from test suite. Oracle 11g support will be removed future versions.

Beta38 (2024-03-15)

  • PL/SQL Enterprise Workbench:
    • Navigator decorator status fixed.

Beta37 (2024-03-03)

  • PL/SQL Enterprise Workbench:
    • Colored display of messages, warnings and errors in PL/SQL Log view.
    • Optimized load and parse of file resourced.
    • Fix in preferences.

Beta36 (2024-02-11)

  • PL/SQL Enterprise Workbench:
    • UI Hot Fixes : Faster restart, Copy to clipboard fix, compile resources includes comments.

Beta35 (2024-02-05)

  • PL/SQL Enterprise Workbench:
    • UI Hot Fixes.

Beta34 (2024-01-21)

  • PL/SQL Enterprise Workbench:
    • Editor improvements and fixes.
    • Connector Builder uses advanced connection pooling.

Beta33 (2023-06-25)

  • PL/SQL Enterprise Workbench:
    • Minor Improvements of Sql-Editors.
    • Fixed Transaction Handling in Sql-Editors.
    • Update Code Assists During Edit.
    • Added Spring Boot MVC Demo - including running Oracle DB as Docker Container.
    • Updated Parameter Types Examples - including running Oracle DB as Docker Container.
    • Added Timestamp with Time Zone Parameter Types Example.
    • Oracle 23c Support - Tested - Validated.

Beta32 - Fix (2023-03-15)

  • PL/SQL Enterprise Workbench:
    • Identify of PL/SQL Object Types / Parser Fix
    • Editor Optimization
    • Outline Optimization

Beta31 (2023-02-19)

  • PL/SQL Enterprise Workbench:
    • Further Improvement of Script-Editor
    • Further Improvement Sql-Result-View
    • Rename Filename from PL/SQL Navigation View
    • Execute Scripts from PL/SQL Navigation View
    • Copy Sql-Statements of Scripts from Outline View

Beta30 - Hotfix (2023-01-10)

  • PL/SQL Enterprise Workbench:
    • Running PL/SQL Connector Builder

Beta29 (2023-01-08)

  • PL/SQL Enterprise Workbench:
    • Improvement of Script-Editor
    • Improvement of Sql-Worksheet-Editor
    • Sql-Result-View Improved and Supports Copy

Beta28 (2022-06-30)

  • PL/SQL Enterprise Workbench:
    • Improvement of Editors
    • Support of Datatype Timestamp of Timezone

Beta27 (2022-01-09)

  • PL/SQL Enterprise Workbench:
    • SQL Worksheets for every database connection to execute simple SQL commands.
    • DBMS Output view added.
    • Improved code completion and code assist.

Beta26 (2021-10-25)

  • PL/SQL Enterprise Workbench:
    • Execution of SQL, SQL-Begin-Blocks and SQL-Declare-Blocks.
    • Support of SQL and PL/SQL scripts.
    • Output of SQL-Select-Results.
    • Output Log of SQL Error.

Beta25 (2021-07-04)

  • PL/SQL Enterprise Workbench:
    • Major UI Problems with Java 11 and new obfuscator version fixed.

Beta24 (2021-06-28)

  • PL/SQL Enterprise Workbench:
    • PL/SQL Resource Search
    • PL/SQL Function and Type Search
    • PL/SQL Folder Wizard
  • PL/SQL Connector Builder
    • Minor bug fixes

Beta23 (2021-06-07)

Beta22 (2021-05-24)

  • PL/SQL Enterprise Workbench Perspective:
    • Complete refactored task, job and process handling for all views and editors.
  • PL/SQL Connector Builder:
    • Improved error handling of not supported data types.
  • PL/SQL Editor:
    • Improved SQL-Code-Assist.
  • Examples:
    • Docker containerized examples:
      • JavaEE : Wildfly example including full App-Container setup for SpringApi and FactoryApi.
      • RMI : Containerized example for SpringApi and FactoryApi.
      • HTTP-SpringRemoting : Spring-Boot containerized example.

Beta21 (2021-02-21)

  • PL/SQL Connector Builder:
    • ROWTYPE is not any more supported due to since Oracle 19c JDBC Driver ROWTYPE is not any more supported
    • SDO_GEOMETRY is not any more supported. SDO-Geometry drivers had always been external libraries and are not maintained any more.
  • PL/SQL Editor:
    • Code completion, text hover and hyperlinks for SQL commands 'SELECT', 'UPDATE', 'DELETE', 'INSERT' and 'MERGE' as well as for implicit and explicit cursors supported.
  • Examples:
    • Updated to Oracle 21.1 JDBC Driver from Maven Repository.

Beta20 (2020-10-30)

  • Improved PL/SQL code assist, texthover and hyperlinks and code completion.
  • Improved Windows 10 handling.

Beta19 (2020-06-28)

  • Improved PL/SQL Editor, better error handling, more code completion, content assist, text hover and hyperlinks.

Beta18 (2019-11-24)

  • Multi-Schema and Mixed-Schema Code Completion support.

Beta17 (2019-08-23)

  • Code completion for PL/SQL Records, PL/SQL Tables, Collections and User Defined Objects optimized.
  • Oracle 19c tests passed without issues.

Beta16 (2019-07-09)

  • Small UI fixes : images of tooltip / filter inside folders.

Beta15 (2019-06-28)

  • Editor supports hyperlink (press CTRL) functionality and text hover (tool tip).

Beta14 (2019-06-03)

  • Hot Fix : Java-Class-Not-Found

Beta13 (2019-05-24)

  • Editor improvement and fixes.
  • Performance tuning of generator and editor content assist.
  • Oracle 18c fixes.

Beta12 (2019-04-17)

  • Editor improved.
  • Supports connection configuration via URL.
  • Autonomous Database ATP/ADW supported.
  • The generated code throws only SQLException.

Beta11 (2018-11-13)

  • PL/SQL Connector Builder processes Private Synonyms and allows setting of Schema Prefix to access objects from other schemas.
  • PL/SQL Connector Builder supports the data type Rowtype for parameter, ref cursor and in package defined collections.
  • In package defined collections supports element type PL/SQL Record.

Beta10 (2018-06-17)

  • PL/SQL Connector Builder generates Java code for Factory-API and Spring-API.
  • Transfer Objects generates public fields or private fields and getter/setter-methods.
  • Spring-HTTP-Remoting is refactored from XML-configuration to annotation configuration.
  • PL/SQL Connector Builder can be used as Maven-Plugin from separate download.
  • Set warning level of compiled database objects.
  • Smaller bug fixes of builder and ui increases stability.

Beta9 (2018-02-12)

  • Some UI problem fixed.
  • Editor parser failure fixed.
  • Performance of Connector Builder improved.
  • Improvement of Java-Doc generation.
  • RMI Connector Builder left experimental state.
  • PL/SQL Batch/Stream Connector Builder left experimental state.
  • Update online documentation.

Beta8 (2018-01-14)

  • Some hard errors fixed (incl. generate new connection).
  • Connector Builder generates Java-Doc in generated Java source code.
  • RMI Connector Builder (experimental state) added.
  • PL/SQL Batch/Stream Connector Builder (experimental state) added.

Beta7 (2017-12-01)

For future improvements the connector builder core is completely refactored. Uninstall the previous version before installing this version.

  • The PL/SQL Enterprise Workbench plugin requires Java 8 to run and supports Eclipse Mars, Neon and Oxygen.
  • The generated code does not run on Java 5 and Java 6 any more - at least Java 7 is required.
  • Before the connector builder starts to run, all parameter type are validated.
  • The Raw JDBC Connector Builder generates static wrapper methods.
  • The JEE Connector Builder has left experimental state.
  • User defined objects have now a Java transfer object and a Java implementation file.
  • The calling interface has not changed - just the Raw JDBC Connector Builder wrapper methods became static.

Beta6 (2017-07-26)

Improvements and Fixes

  • Builder improvement:
    • PL/SQL record supported.
  • UI improvement:
    • Filter handling with upper case filenames fixed.
    • Minor UI bugs fixed and minor improvements.

Beta5 (2017-07-20)

Improvements and Fixes

  • Hard problems with Windows OS version fixed (Sorry, I'm developing under OSX and Linux).

Beta4 (2017-07-18)

Improvements and Fixes

  • Builder improvement:
    • Configure conversion of integer, floating point, date and timestamp values individually.
    • Edit your own Java class preamble.
    • Custom annotations for version information etc.
    • Support of overloaded procedures/functions.

Beta3 (2017-05-26)

Improvements and Fixes

  • Builder improvement:
    • User type of multidimensional collections are implemented.
    • User defined object and collection types as attribute of ref cursor are supported.
    • Raw-JDBC Builder, Java-RPC-Builder and Spring-Remoting-Builder have stable state - there haven't been any changes since kickoff.
    • The JavaEE-Builder has still experimental state.
    • The integration test suite covers all oracle types for any builder and all numeric conversion models.

Beta2 (2017-05-10)

Improvements and Fixes

  • Better connection handling inside plugin.
  • All long running operations implemented as Eclipse jobs.
  • Better stability of Connector Builder.
  • Some build fixes of Connector Builder.
  • Support of binary types.
  • Working of complete integration test suite to check all builder in any combination.

Kickoff Release - Beta1 (2017-02-27)

Start publishing project in Eclipse Marketplace.

  • Structure of Connector Builder and interfaces has reached stable stable state.
  • Eclipse Plugin allows productive work but needs a lot of improvement.