Details
-
Feature
-
Status: Released (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
-
None
Description
Current Situation
- Since release 1.10 JobScheduler ships with the JDBC Driver 9.4.1201-jdbc4.jar. This JDBC Driver is compiled for Java 1.6 and is used for compatibility with the JobScheduler installer that supports older JobScheduler releases.
- This JDBC Driver is reported to work well with PostgreSQL releases 9.1 and later. However, we received reports that this JDBC Driver does not work well when used with older PostgreSQL releases 8.x.
- When using older PostgreSQL release before 9.1 then users should check that the setting standard_conforming_strings = on is in use.
Desired Behavior
- JobScheduler should ship with a more recent release of the JDBC Driver that is compatible with older PostgreSQL releases.
- JDBC Driver postgresql-9.4.1209.jar
- is compiled for Java 1.8
- fixes a number of issues that are relevant for use with JobScheduler, e.g. https://github.com/pgjdbc/pgjdbc/pull/427
Maintainer Notes
- PostgreSQL JDBC Drivers are available from https://jdbc.postgresql.org/download.html