[CONNECTORS-1763] Update the default PostgreSQL JDBC Driver

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: ManifoldCF 2.26
• Fix Version/s: ManifoldCF 2.28
• Component/s: Framework core
• Assignee: Unassigned
• Reporter: Piergiorgio Lucidi
• Created: 19/Aug/24 13:06
• Updated: 11/Oct/24 10:11

Description

Trying to deploy ManifoldCF using PostgreSQL using the default PostgreSQL JDBC Driver v. 42.1.3, the following warning message is returned during the bootstrap:

WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.postgresql.jdbc.TimestampUtils (file:/usr/share/manifoldcf/lib/postgresql-42.1.3.jar) to field java.util.TimeZone.defaultTimeZone
WARNING: Please consider reporting this to the maintainers of org.postgresql.jdbc.TimestampUtils
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release

The problem is related to the old PostgreSQL JDBC Driver implementation that is not compliant with the new Java Modules architecture introduced after Java 9.

I think that we should update it to the latest version 42.7.3.

Here the issue explained in the GitHub project:

https://github.com/pgjdbc/pgjdbc/issues/986