Why doesn't Lucee bundle the latest version of PostgreSQL JDBCDriver?

wafflook · January 26, 2022, 3:43am

Hi
Had to manually replace the driver to support authorization type 10.
I’ve been using lucee for a year now. Is there a reason why the new drivers are not bundled?
I have replaced lucee-express-5.3.8.206 lucee-server/bundles/org.postgresql.jdbc42-9.4.1212.jar with postgresql-42.3.1.jar to support PostgresDB 14.1 (latest) .

Thank you.

Zackster · January 26, 2022, 7:57am

5.3.9 already does bundle 42.2.20, RC1 is coming out this week.

we can update that to the latest bundle too

github.com

lucee/Lucee/blob/5.3/core/src/main/java/META-INF/MANIFEST.MF#L367

    
      
          tagsoup;bundle-version=1.2.1.0002L,
          w3c.dom;bundle-version=1.1.0,
          org.lucee.commons.email;bundle-version=1.2.0,
          org.lucee.jsch;bundle-version=0.1.53,
          org.lucee.jzlib;bundle-version=1.1.3,
          xmpcore;bundle-version=5.1.2.0002L,
          org.lucee.argon2;bundle-version=2.7.0,
          com.sun.jna;bundle-version=5.5.0
          Require-Extension: 7E673D15-D87C-41A6-8B5F1956528C605F;name=MySQL;label=MySQL;version=8.0.19,
          99A4EF8D-F2FD-40C8-8FB8C2E67A4EEEB6;name=MSSQL;label=MS SQL Server;version=7.2.2.jre8,
          671B01B8-B3B3-42B9-AC055A356BED5281;name=PostgreSQL;label=PostgreSQL;version=42.2.20,
          2BCD080F-4E1E-48F5-BEFE794232A21AF6;name=JDTsSQL;label=jTDS (MSSQL);version=1.3.1,
          CED6227E-0F49-6367-A68D21AACA6B07E8;name=Admin;label=Lucee Administrator;version=1.0.0.3,
          D46D49C3-EB85-8D97-30BEC2F38561E985;name=Doc;label=Lucee Documentation;version=1.0.0.2,
          17AB52DE-B300-A94B-E058BD978511E39E;name=S3;label=S3;version=0.9.4.145-SNAPSHOT,
          87FE44E5-179C-43A3-A87B3D38BEF4652E;name=EHCache;label=EHCache;version=2.10.0.31,
          D46B46A9-A0E3-44E1-D972A04AC3A8DC10;name=Chart;label=CFChart;version=1.0.19.24,
          FAD1E8CB-4F45-4184-86359145767C29DE;name=Hibernate;label=Hibernate;version=3.5.5.77,
          EFDEB172-F52E-4D84-9CD1A1F561B3DFC8;name=Lucene;label=Lucene;version=2.4.2.3-SNAPSHOT,
          66E312DD-D083-27C0-64189D16753FD6F0;name=PDF;label=PDF;version=1.0.0.98-SNAPSHOT,
          FAD67145-E3AE-30F8-1C11A6CCF544F0B7;name=Form;label=Form tags;version=1.0.0.10;since=5.1.0.21,

wafflook · January 26, 2022, 8:29am

oh… I forgot to check the snapshot version. thank you.

Zackster · January 26, 2022, 8:38am

latest 5.3.8.212 also bundles that

github.com

lucee/Lucee/blob/5.3.8/core/src/main/java/META-INF/MANIFEST.MF#L369

    
      
          tagsoup;bundle-version=1.2.1.0002L,
          w3c.dom;bundle-version=1.1.0,
          org.lucee.commons.email;bundle-version=1.2.0,
          org.lucee.jsch;bundle-version=0.1.53,
          org.lucee.jzlib;bundle-version=1.1.3,
          xmpcore;bundle-version=5.1.2.0002L,
          org.lucee.argon2;bundle-version=2.7.0,
          com.sun.jna;bundle-version=5.5.0
          Require-Extension: 7E673D15-D87C-41A6-8B5F1956528C605F;name=MySQL;label=MySQL;version=8.0.19,
          99A4EF8D-F2FD-40C8-8FB8C2E67A4EEEB6;name=MSSQL;label=MS SQL Server;version=7.2.2.jre8,
          671B01B8-B3B3-42B9-AC055A356BED5281;name=PostgreSQL;label=PostgreSQL;version=42.2.20,
          2BCD080F-4E1E-48F5-BEFE794232A21AF6;name=JDTsSQL;label=jTDS (MSSQL);version=1.3.1,
          CED6227E-0F49-6367-A68D21AACA6B07E8;name=Admin;label=Lucee Administrator;version=1.0.0.3,
          D46D49C3-EB85-8D97-30BEC2F38561E985;name=Doc;label=Lucee Documentation;version=1.0.0.2,
          17AB52DE-B300-A94B-E058BD978511E39E;name=S3;label=S3;version=0.9.4.135,
          87FE44E5-179C-43A3-A87B3D38BEF4652E;name=EHCache;label=EHCache;version=2.10.0.31,
          D46B46A9-A0E3-44E1-D972A04AC3A8DC10;name=Chart;label=CFChart;version=1.0.19.24,
          FAD1E8CB-4F45-4184-86359145767C29DE;name=Hibernate;label=Hibernate;version=3.5.5.77,
          EFDEB172-F52E-4D84-9CD1A1F561B3DFC8;name=Lucene;label=Lucene;version=2.4.1.33,
          66E312DD-D083-27C0-64189D16753FD6F0;name=PDF;label=PDF;version=1.0.0.97-RC,
          FAD67145-E3AE-30F8-1C11A6CCF544F0B7;name=Form;label=Form tags;version=1.0.0.10;since=5.1.0.21,

wafflook · January 26, 2022, 10:49am

5.3.8.206 was the latest stable version of https://download.lucee.org/.
I just downloaded 5.3.9.56 and confirmed that the jdbc driver is updated.
5.3.8.206 has a recent release date (09/25/2021),so I couldn’t resist asking. I’ll be careful from now on