PostgreSQL doesn't work with jdbc-Drivers 8.4 and later

Description

This appears to be the same issue as RAILO-2019.

Using the postgreSQL driver provided with Lucee, adding the "result" attribute to a cfquery — and any query in cfscript — causes a "syntax error at or near 'RETURNING' Position: 26" error.

Apparently, cfscript uses the "result" attribute for all queries (Base.cfc, line 156).

Downgrading to the 8.3-607_JDBC_4 jar resolves the issue.

Environment

None

Activity

Igal Sapir 
7 November 2016 at 02:01

This was an issue with the JDBC driver. It is resolved since driver version 9.4.1211

See https://github.com/pgjdbc/pgjdbc/issues/488 for details

Brad Wood 
31 August 2015 at 14:15

Is this fixed by LDEV-501?

Fixed

Details

Assignee

Reporter

Priority

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Affects versions

Created 27 March 2015 at 15:34
Updated 7 November 2016 at 02:01
Resolved 7 November 2016 at 02:01