EnterpriseDB Technical Alert for Connectors 10.0.2 #20180511.01

This article was originally published on May 11, 2018

SEVERITY: Moderate

ALERT FOCUS

This alert is for customers using:

• EnterpriseDB Connectors (ODBC, JDBC, DotNet, OCL)

RECOMMENDED ACTIONS

Status:  Moderate  

Recommended: The update contains enhancements and important fixes that relate to EDB Connectors (JDBC,ODBC,OCI,.NET). EDB urges users to apply this update at the next possible downtime.

WHAT IS IN THIS ALERT 

EnterpriseDB JDBC Driver version 42.2.2.1

---------------------------------------------------------------

•  Merge with community driver from PGJDBC 42.1.4 to PGJDBC 42.2.2  

More information about enhancements and fixes in the community driver can be found at 

https://jdbc.postgresql.org/documentation/changelog.html#version_42.2.2 

EnterpriseDB .Net Driver version 3.2.6.1

---------------------------------------------------------------

• Merge with new release of community Npgsql version 3.2.6

More information about this and other fixes in the community driver can be found at https://github.com/npgsql/npgsql/releases/tag/v3.2.6 

EnterpriseDB ODBC Driver version 10.01.0000.01

---------------------------------------------------------------------

• Merge with community version: 10.01.0000. Contains upstream changes from psqlODBC 09.06.0300 to psqlODBC 10.01.0000 

More information about this and other fixes in the community driver can be found at https://odbc.postgresql.org/docs/release.html 

EnterpriseDB OCI Connector version 10.0.1.0

-----------------------------------------------------------------

• Contains few fixes. Details in following section. 

This software update contains the following enhancements and fixes:

---------------------------------------------------------------------------------------------- 

• [OCL] Issue with date retrieval using edb-oci library (Support Ticket #725489, EC-113)
• [JDBC] Fix for ISO datestyle against dblink server with different format for dates (Support Ticket #720394, EC-123)
• [JDBC] Fix for connection errors logged as SEVERE (EC-190)
• [JDBC] Fix for error retrieving text content as CLOB using ResultSet.getClob() (Support Ticket #740422, EC-164)
• [ODBC] Fix for show sys/dbo table in MS Access (EC-248)
• [ODBC] Fix for import data into MS Excel (EC-262)
• [ODBC] Fixed various memory leaks in OCI (Support Ticket #737725)
• [OCL] Fix for OCIDateToText conversion of dates (Support Ticket #743801, EC-178)
• [OCL] Rounding issue with timestamp values in milliseconds (Support Ticket #728550, EC-114)
• [DotNet] Receive "statement timeout" in the application (Support Ticket #743290, EC-177)

Connectors Version Matrix 

IS THIS ALERT FOR ME?

This alert is for customers using:

- EDB Postgres Advanced Server 9.6.x, 10.x.x 

- Postgres Plus Advanced Server 9.4.x, 9.5.x

- Connectors (ODBC, JDBC, DotNet, OCL)
 

HOW TO GET THE UPDATE AND APPLY IT

This update is available through the StackBuilder Plus Module for EDB Postgres Advanced Server and Postgres Plus Advanced Server respectively.

Please perform the following steps to update your Connectors for EDB Postgres Advanced Server or Postgres Plus Advanced Server. 

1. Right-click on the system tray icon (PostgreSQL Elephant) and select 'Install Components'.  StackBuilder Plus will start and the available updates will be displayed in bold type in the component selection screen.

OR

Run StackBuilder Plus directly from the Application Menu. The update will automatically be selected and displayed in bold type.

2. Click ‘Next’ and you will be asked to authenticate with EnterpriseDB.

3. Click ‘Next’ and choose the download directory (where the update will be downloaded).

4. The installation will start once the download is complete.

This update is also available as an RPM package that can be downloaded from the EnterpriseDB yum.enterprisedb.com repository. You will need a username and password to access yum.enterprisedb.com, and you should contact your account manager or sales@enterprisedb.com if you do not have one.

TROUBLESHOOTING 

If you experience any problems applying the upgrade or restoring the old version after applying the upgrade, please contact Technical Support at:

Email:  support@enterprisedb.com

Phone: 

US: +1-732-331-1320 or 1-800-235-5891

UK: +44-2033719820

Brazil: +55-2139581371 

India: +91-20-66449612