New version of Posgres jdbc JDBC 1210 is out
https://www.postgresql.org/about/news/1694/
fix: support cases when user-provided queries have ‘returning’ PR#488
tested with Lucee 4.5 and beta 5.1 and no errors with query result
parameter.
New version of Posgres jdbc JDBC 1210 is out
https://www.postgresql.org/about/news/1694/
fix: support cases when user-provided queries have ‘returning’ PR#488
tested with Lucee 4.5 and beta 5.1 and no errors with query result
parameter.
Thank you, this is great news - this has really been bugging us for years
with ACF, Railo and Lucee and it seems like the latter has created enough
leverage to finally get things fixed - that’s another feather in the cap
for the Lucee project
Kind regards
Markus
Good news!
One question: if I’m on Lucee 5 with Postgresql installed via the
extension, how do I update to the new driver? Will the extension be
updated soon?
An easier way would be to set it in your Application.cfc
MANIFEST.MF
file, etc.Fortunately, the pgjdbc drivers are already “OSGi bundles”, so all you have to do is download the jar file from https://jdbc.postgresql.org/download.html and save it to your {lucee-server}/bundles
directory.
Go to the Lucee Admin and click on Bundle (jar) to verify that Lucee “sees” the new bundle:
this.datasources["pgjdbc"] = {
class: 'org.postgresql.Driver'
, bundleName: 'org.lucee.postgresql'
, bundleVersion: '8.3.0.jdbc4'
, connectionString: 'jdbc:postgresql://localhost:5432/<DATABASE-NAME>'
, username: '<USERNAME>
, password: "<PASSWORD>"
};
, bundleName: 'org.postgresql.jdbc42'
, bundleVersion: '9.4.1210'
<cfdbinfo name="qDbInfo" type="version">
<cfdump eval="qDbInfo">
It should look something like this:
Igal
MODERATOR: Hmm… for some reason this didn’t quite make it across in the migration from https://groups.google.com/forum/#!topic/lucee/5cEQsNPUHJw