JobScheduler should use OID field type instead of BYTEA for logs in PostgreSQL databases

Desired Behavior

• JobScheduler should use the OID field type instead of BYTEA for logs in PostgreSQL databases
• With the BYTEA field type the logs cannot be retrieved with hibernate as hibernate maps the @LOB field to a blob which results in a getBlob() call in JDBC. This call expects an integer value as resultkey for the blobs table.
• A workaround is to leave away the @lob. This works with MySQL and PostgreSQL but not with Oracle.

Maintainer Note

• This feature is not intended for immediate implementation.
• As there is a workaround for JID (the jar com.sos.hibernate_pgsql.jar), this will be taken into consideration for a future re-write of the JOC Cockpit.