Title:
Postgres JDBC driver is so old we cannot use current features in Postgres and self-upgrades beyond 8.3 fail
| View in TrackerStatus/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): Brian Ghidinelli / Brian Ghidinelli (Brian Ghidinelli)
Created: 06/23/2014
Versions: 10.0
Failure Type: Performance Issue
Found In Build/Fixed In Build: Final / CF10_Update14
Priority/Frequency: Major / All users will encounter
Locale/System: English / Win All
Vote Count: 0
Problem Description:
This applies to both CF10 and CF11 as they include the same version of the Postgresql driver.
The postgres JDBC driver is from Postgres 8.3 and was released 6 years ago in 2008. Since then, Postgres has released numerous major revisions and are currently at 9.3 and about to release 9.4. There have been many enhancements to Postgres during this time, in particular, with their support of more exotic datatypes such as arrays, uuids, hstore, json, xml and more.
The current driver cannot be upgraded to anything beyond postgres-8.3-607 JDBC3 without every single query returning an error about a "RETURNING" at the end of the statement.
We need to a more modern version of the driver in order to fully leverage our database.
Steps to Reproduce:
Download any newer version of the library from jdbc.postgresql.org, install into cfusion\lib and remove the 8.3 version.
Restart.
Run a "select * from table" query and witness the error.
Actual Result:
ERROR: syntax error at or near "RETURNING" Position: 27
Expected Result:
A query result.
Any Workarounds:
Use the ancient driver which has no support for any Postgres enhancements in the last 6 years.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3780222
External Customer Info:
External Company:
External Customer Name: brianatvfive
External Customer Email:
External Test Config: My Hardware and Environment details:
Windows 7 / CF 10 (but same driver exists in CF11)Attachments:
Comments: