Update Microsoft SQL Server Extension to make official JDBC Driver 8.2.2 available

Description

Official Microsoft JDBC Driver for SQL Server version 8.2.2 was released on March. 24, 2020. (https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15)

Latest Lucee extension version currently currently showing as available on https://download.lucee.org/ is 7.2.2.jre8.

Would it be possible to make 8.2.2 available as a lucee extension?

Attachments

1
  • 06 Nov 2020, 03:22 pm

Activity

Show:

Brad Wood 31 January 2022 at 19:09

No, sorry. If I recall, I did this

  • Downloaded Lucee’s latest OSGI bundled JDBC driver jar

  • Downloaded the official Microsoft OSGI bundle JDBC jar of the SAME VERSION

  • Opened each of their META-INF/MANIFEST.MF files in a text/diff (I use WinMerge) and noted all of the changes Micha had made

  • Downloaded the latest official MS OSGI bundled JDBC jar and made roughly the same changes to that one to match.

I don’t recall what the changes all were any longer without looking, but those were the basic steps.

Kai Koenig 31 January 2022 at 02:11

Just found this ticket looking for a way to repackage a modern MS SQL driver from MSFT (the jre11 builds) as a lex file.

Any chance you have a bullet point list of steps to take to do that?

Brad Wood 6 November 2020 at 17:28

I have a client using that lex file in production right now. Sadly, it didn't fix the specific connection drop out issues there were having on MS Azure, but it does seem to work fine otherwise. I just took the jar directly from Microsoft's website and did the same OSGI changes in the jar's manifest that Micha did to the 7.x drivers and repackaged it.

Samuel W. Knowlton 6 November 2020 at 15:22

cobbled together a LEX of 8.4.1. We haven’t tested it yet locally but I think he has. I’ve attached it here.

 

Details

Assignee

Reporter

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

Priority

Created 8 June 2020 at 13:39
Updated 31 January 2022 at 19:09

Flag notifications