The job supports encryption of database credentials if used with a Hibernate configuration file, see JS7 - How to encrypt and decrypt Database Credentials.

Changes

Starting from Release 2.0.0 the PLSQLJob
- is implemented on top of the JDBC Interface of the Oracle® JDBC Driver.
- The Oracle® JDBC Driver performs a commit operation when a connection is closed without an explicit commit or rollback.
Starting from Release 2.7.1 the PLSQLJob is implemented using Hibernate
- no commit or rollback operation is performed when the connection is closed.

Starting from Release 2.7.2 the PLSQLJob

makes use of the Hikari connection pool that ships with Hibernate,
performs a rollback operation when a connection is closed,
closes the connection in the event that a cancel/kill or suspend/kill operation is performed on the order.

Jira

server	SOS JIRA
columnIds	issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columns	key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId	6dc67751-9d67-34cd-985b-194a8cdc9602
key	JITL-743

Usage

When defining the job either:

...