Release notes from utPLSQL-cli

utPLSQL-cli v3.2.0

2026-04-28T17:11:23Z

What's Changed

Bump ch.qos.logback:logback-classic from 1.2.11 to 1.2.13 by @dependabot[bot] in #223
update libraries dependencies by @jgebal in #228
Update to Java 17 by @jgebal in #229
Update to utPLSQ-java-api 3.2.4 (using ojdbc version 23.7.0.25.01)

Full Changelog: 3.1.9...v3.2.0

v3.1.9

2026-03-08T11:44:53Z

What's Changed

Bugfix/Locale-Info and Nullpointer by @pesse in #171
Feature/cleanup maven jdbc by @jgebal in #176
Support a_coverage_schemes option of utPLSQL by @pesse in #180
Feature/GitHub actions by @jgebal in #202
Add new --ora-stuck-timeout parameter by @pesse in #198
Update dependencies by @pesse in #204

Full Changelog: v3.1.8...3.1.9

utPLSQL-cli v3.1.8

2019-10-22T20:08:38Z

Compatibility

This version of utPLQL-cli is compatible with all versions of utPLSQL from 3.0.0 to 3.1.8. We encourage you to always use the latest version of cli to communicate with a v3 core.

Changes in this release

New Features

Due to the recent Oracle license changes, utPLSQL-cli is now shipped with all necessary ojdbc drivers!

Enhancements

Default-parameters of the utPLSQL core API are now correctly used when not specified

Bugfixes

Coverage reports are now correctly created (#162, #165)
File-mapping also works now for utPLSQL core 3.0.0-3.0.2 (utPLSQL/utPLSQL-java-api#92)

Internal enhancements

Use publicly available ojdbc libraries
Better coverage self-tests

utPLSQL-cli v3.1.7

2019-07-12T13:15:07Z

Compatibility

This version of utPLQL-cli is compatible with all versions of utPLSQL from 3.0.0 to 3.1.7. We encourage you to always use the latest version of cli to communicate with a v3 core.

Changes in this release

New Features

CLI is now runnable from Java 8-12 (and probably also upcoming versions)
CLI now uses Picocli instead of JCommander. This might have some impact on how parameters are interpreted, for example on windows machines when you define -f=ut_documentation_reporter -o="output.txt" you will have to enclose the "output.txt" part as shown
Support for Tags via --tags=tag1[,tag2[,tag3]]parameter (#157)
Support for random order of test execution via -r/--random-test-order and -seed/--random-test-order-seed (#139)
Ability to enable DBMS_OUTPUT from cli via -D/--dbms_output (#137)

Enhancements

Completely removed HikariCP (#158)
A warning is shown if orai18n.jar is not on the classpath. This is highly recommended due to some strange behaviour of the jdbc-driver otherwise (#146, #153)

Bugfixes

Type mapping (-type_mapping) parameter is now interpreted correctly (#143)

Internal enhancements

Improvement of tests
Refactoring towards immutability
Added some more debug information

utPLSQL-cli v3.1.6

2019-03-25T21:59:58Z

Compatibility

This version of utPLQL-cli is compatible with all versions of utPLSQL from 3.0.0 to 3.1.6. We encourage you to always use the latest version of cli to communicate with a v3 core.

Changes in this release

New Features

CLI now logs some basic information to screen in addition to an eventually configured to-screen-reporter (#89, #76)
- This output can be avoided with the new -q, --quiet parameter
- Much more logging can be output with the new -d, --debug parameter
It's possible to connect as sysdba now via utplsql run "sys as sysdba"/pw@connectstring (#115)
The default timeout of 60 minutes is now configurable via the new -t, --timeout parameter (#124)

Enhancements

Timeout now returns error exit-code (#129)
In case of Oracle stuck-scenario during createStatement, a warning is written to the screen and the same call for running the tests is retried up to 5 times. (#20)
It's now possible to pass usernames containing / and passwords containing @ by encapsulating those in the connectstring with ": utplsql run "my/User"/"P@ssword"@server:1521/Service (#111)
API-version is now stored in a separate, non-compiled file

Bugfixes

Info command should now show the correct version information (#108)
Non-argument call will output help (#110)

Internal enhancements

Update of HikariCP
Improvement of passing user/pw/connect info to connection pool
Improvement of Error-Handling
Cleanup of tests

utPLSQL-cli v3.1.2

2018-12-21T16:02:00Z

Compatibility

This version of utPLQL-cli is compatible with all versions of utPLSQL from 3.0.0 to 3.1.3. We encourage you to always use the latest version of cli to communicate with a v3 core.

Changes in this release

New Features

New command utplsql info [user/password@connectstring] #77
New command utplsql reporters user/password@connecstring
Cli tries to connect to oracle via thick-driver first and use thin-driver as fallback #88 #90 #91

Enhancements

Limit number of connections to number of reporters+1 #85
Include JAXB library so utPLSQL-cli can be run on java 9+10 #82
- There is however still a problem when using HTMLCoverageReporter and Java 9/10
Improved documentation and help-command #31
An existant NLS_LANG-variable will now lead to corresponding ALTER SESSION statements when connecting #101

Bugfixes

HTML Coverage assets are placed and referenced correctly when using output file in subdirectory #94
Java-locale is now correctly derived from LC_ALL or LANG environment variable, not from NLS_LANG #101

Internal enhancements

Refactoring of Command architecture
Refactoring of Connection handling
Improved Error handling

utPLSQL-cli v3.1.0

2018-03-29T12:31:26Z

Compatibility

This version of java-api is compatible with all versions of utPLSQL from 3.0.0 to 3.1.0. We encourage you to always use the latest version of cli to communicate with a v3 core.

Changes in this release

Enhancements

Support for custom reporters. Just call utplsql run user/pass@connstr -f=my_custom_reporter and cli will try to use a database-reporter with the given name
Assets necessary for CoverageHTMLReporter are written to $outputFileName-assets folder (utPLSQL/utPLSQL-java-api#39)
Realtime-Feedback: Output to screen is immediate, output to files is in bulks (#68)
NLS-Support from environment (#56)

Bugfixes

The correct usage is now stated in help message (#63)
Several small improvements

Initial release

2017-11-23T09:14:14Z

First official release of utPLSQL-cli - Command line client for utPLSQL v3

Requirements

Java8
Oracle JDBC driver file (ojdbc8.jar) is required
Oracle i18n driver file (orai18n.jar) is required for national character-set support

Both driver files need to be downloaded and placed in utPLSQL-cli/lib folder

Key features

connectivity to Oracle database without Oracle client software (needs JDBC driver)
support for multiple reporters and multiple output files
real-time reporting to screen (depends on reporter implementation)
documentation reporting in color
mapping of project files to database objects (needed for Sonar reporting)
support for customized project file-mapping rules

utPLSQL versions supported

utPLSQL v3.0.0
utPLSQL v3.0.1
utPLSQL v3.0.2
utPLSQL v3.0.3
utPLSQL v3.0.4