Database Tasks don't work on PostgreSQL 9.6

[rbeckman-nextgen]

It appears this is a bug in the PostgreSQL JDBC driver:

• [https://www.postgresql.org/message-id/flat/CADK3HHJmcHQta9QRYq%3Ddo01BFJbYjqMAQjYhue9Yo5PnZSs-wQ%40mail.gmail.com#CADK3HHJmcHQta9QRYq=do01BFJbYjqMAQjYhue9Yo5PnZSs-wQ@mail.gmail.com]
• [https://github.com/fix: support PostgreSQL 9.6 pgjdbc/pgjdbc#560]
• [https://github.com/fixed index ASC/DESC for 9.6 pgjdbc/pgjdbc#569]

The solution appears to be to upgrade to the latest version of the driver.

Imported Issue. Original Details:
Reporter: narupley
Created: 2016-11-10T11:44:25.000-0800

[rbeckman-nextgen]

Revision 8137: Updated the PostgreSQL JDBC driver to the latest 4.1 (JRE 7 compatible) release.

Imported Comment. Original Details:
Author: narupley
Created: 2016-11-10T12:18:58.000-0800

[rbeckman-nextgen]

The forum thread [here|http://www.mirthcorp.com/community/forums/showthread.php?t=216632] mentions a separate error occurring in logs, possibly related to autovacuuming and ASLR. I haven't been able to reproduce it, but worth looking into in case it's related. Test on appliances as well.

Imported Comment. Original Details:
Author: narupley
Created: 2016-11-10T12:51:50.000-0800

[rbeckman-nextgen]

OS(s) and JRE version: virtual Window 7 with JRE version 1.8.0_111-b14
Version(s)/Build(s) to reproduce failure: mirthconnect-3.4.2.8129.b167-windows-x64
Version(s)/Build(s) to verify fixes: mirthconnect-3.5.0.8156.b2066-windows-x64
PostgreSQL version: postgresql-9.6.1-1-windows-x64.exe
How Tested:

Install Postgres 9.6.1 (including pgadmin 4)

Using pgadmin to Create "mirthdb" database in Postgres

Launch MC server using postgres for mirthdb (database.url = jdbc:postgresql://localhost:5434/mirthdb)

Create a channel (channel read/writer)

Deploy channel

In Channels view, locate channel local ID (should be 1)

From pgadmin, expand mirthdb > Schemas > public > Tables > d_mm1 > Indexes > Select "d_mm1_index3" , then select "Delete/Drop"

Back to MC administrator > Settings > Database Tasks > Refresh, expect to see Task Name "Add Metadata Index"

Select Run Task and verify Task completes successfully

Observed Failure:
In MC 342, NOT able to view Database task
{code}ERROR 2017-01-05 09:49:20,051 [AWT-EventQueue-2] com.mirth.connect.client.ui.Frame: Error loading database tasks: com.mirth.connect.client.core.ClientException: {code}

Verified Fixed:
Able to open Database task and Run Task successfully
Tested successfully with the following tasks:

Add Metadata Index

Remove Old Pre-3.3 Code Template table

Remove Old 2.x Message Table

Imported Comment. Original Details:
Author: minht
Created: 2017-01-05T13:24:28.000-0800