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
An easier way would be to set it in your Application.cfc
First, you need to install the OSGi bundle (an exciting feature of Lucee 5). You do that by adding a bundle (which is a jar file with specific conventions, like the 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:
Create a PostgreSQL Datasource with the the current driver, and go to Edit Datasource and scroll all the way to the bottom, where you can find a snippet that you can use in Application.cfc; It will look something like this (with your settings of database name, username, and password:
Update the snippet to reflect the new bundle’s name and version (I’m using the jdbc42 edition for Java 1.8, if you use a different one then check the bundle symbolic name inside the Jar in META-INF/MANIFEST.MF: