Error when updgrading/downgrading MSSQL JDBC driver

Description

Backdrop: I started a new Lucee server in a new project with CommandBox which gave version 5.2.9.31. I tried upgrading the MSSQL JDBC driver to 7.2.1 and received the error below.

I then upgraded Lucee to 5.3.1.95 and tried to upgrade the MSSQL JDC driver again and got the error again. I then tried 'installing' different versions, all with the same error.

When attempting to upgrade or downgrade the MSSQL JDBC driver to any version I receive the following error:

This then prevents me from making a datasource with the following:

Environment

CommandBox 4.5.0 on Win10

Activity

Michael Offner 7 June 2019 at 16:00

added a patch to fix this for all 5.2.9 version bigger or equal to 5.2.9.41-SNAPSHOT

Michael Offner 7 June 2019 at 14:37

added support for version ranges

version ranges can be defined as follows

1.0.0.0-1.0.0.1,2.0.0.0 - fine from version 1.0.0.0 to version 1.0.0.1 and all version bigger or equal to 2.0.0.0

-2.0.0.0 - fine all versions smaller or equal to 2.0.0.0

i’m aware that this does actually bot solve this ticket at all. But is still kind of address it for the future.

we will make a patch in 5.2.9 for this ticket

 

 

Samuel W. Knowlton 5 June 2019 at 16:02

Leon Miller-Out 16 May 2019 at 14:02

Thanks, !

I agree that removing the minimum version isn’t a good option. I think that having two versions might be the best option for now. Perhaps we can do it only for mssql-jdbc v7.0.0, and not ever support newer versions on Lucee 5.2. I do think it’s important to at least offer v7.0.0 because the performance problems in the v6 series are dramatic.

(In the future, we could have a more robust “compatible versions” property in the extension manifest, where we could list compatible Lucee version ranges. For this case, we would have something like “>= 5.2.9.40-SNAPSHOT, < 5.3”, “>= 5.3.2.63”. I assume that would be a lot more work, though. Inspirations: https://docs.npmjs.com/misc/semver, https://guides.rubygems.org/patterns/#semantic-versioning)

Michael Offner 15 May 2019 at 17:39

yeah, i see the problem, we cannot set 5.2.9.40-SNAPSHOT as minimal version. because all older 5.3 version will still not work. sure we can remove the minimal version, but that will for sure force a new ticket. i also don’t like to create additional versions. i have to think about it …

 

Fixed

Details

Assignee

Reporter

Priority

Labels

Fix versions

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

Sprint

Affects versions

Created 22 March 2019 at 17:37
Updated 6 May 2021 at 06:59
Resolved 14 June 2019 at 12:31