Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

MSSQL version 9.3.1 shows the error in application page.

Description

While trying to update(or install) 9.3.1, remove MSSQL extension from installed extension and shows the error like Unable to resolve com.microsoft.sqlserver.mssql-jdbc [ 60 ](R 60.0): missing requirement [com.microsoft.sqlserver.mssql-jdbc [ 60 ](R 60.0)] osgi.wiring.package;. Seems the same error shows for all the version above the 7.2.2 jre 8. Afterthat try to install version the 7.2.2 jre 8 randomly Shows the error like C:/..../..../lucee-express-5.3.7.48_2\lucee-server\context\extensions\installed\13caj0tnzdgsa.lex: The process cannot access the file because it is being used by another process.

Stacktrace :

"ERROR","ajp-nio-8009-exec-10","05/06/2021","11:07:41","","Unable to resolve com.microsoft.sqlserver.mssql-jdbc [105](R 105.0): missing requirement [com.microsoft.sqlserver.mssql-jdbc [105](R 105.0)] osgi.wiring.package; (&(osgi.wiring.package=org.osgi.framework)(version>=1.8.0)(!(version>=2.0.0))) Unresolved requirements: [[com.microsoft.sqlserver.mssql-jdbc [105](R 105.0)] osgi.wiring.package; (&(osgi.wiring.package=org.osgi.framework)(version>=1.8.0)(!(version>=2.0.0)))] at org.apache.felix.framework.Felix.resolveBundleRevision(Felix.java:4368) at org.apache.felix.framework.Felix.startBundle(Felix.java:2281) at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:998) at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:984) at lucee.loader.osgi.BundleUtil.start(BundleUtil.java:112) at lucee.loader.osgi.BundleUtil.start(BundleUtil.java:108) at lucee.runtime.osgi.OSGiUtil._start(OSGiUtil.java:1171) at lucee.runtime.osgi.OSGiUtil._startIfNecessary(OSGiUtil.java:1124) at lucee.runtime.osgi.OSGiUtil.startIfNecessary(OSGiUtil.java:1119) at lucee.runtime.osgi.OSGiUtil._loadBundle(OSGiUtil.java:520) at lucee.runtime.osgi.OSGiUtil.loadBundle(OSGiUtil.java:472) at lucee.commons.lang.ClassUtil.loadClassByBundle(ClassUtil.java:155) at lucee.transformer.library.ClassDefinitionImpl.getClazz(ClassDefinitionImpl.java:109) at lucee.runtime.config.XMLConfigAdmin.setClass(XMLConfigAdmin.java:6613) at lucee.runtime.config.XMLConfigAdmin._updateJDBCDriver(XMLConfigAdmin.java:1795) at lucee.runtime.config.XMLConfigAdmin.updateRHExtension(XMLConfigAdmin.java:4990) at lucee.runtime.config.XMLConfigAdmin.updateRHExtension(XMLConfigAdmin.java:4685) at lucee.runtime.config.XMLConfigAdmin._updateRHExtension(XMLConfigAdmin.java:4667) at lucee.runtime.tag.Admin.doUpdateRHExtension(Admin.java:4264) at lucee.runtime.tag.Admin._doStartTag(Admin.java:740) at lucee.runtime.tag.Admin.doStartTag(Admin.java:353) at ext_applications_cfm184$cf.call(/admin/ext.applications.cfm:81) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)
"ERROR","ajp-nio-8009-exec-5","05/06/2021","11:07:55","","C:\portables\lucee-express-5.3.7.48_2\lucee-server\context\extensions\installed\13caj0tnzdgsa.lex: The process cannot access the file because it is being used by another process. at sun.nio.fs.WindowsException.translateToIOException(Unknown Source) at sun.nio.fs.WindowsException.rethrowAsIOException(Unknown Source) at sun.nio.fs.WindowsException.rethrowAsIOException(Unknown Source) at sun.nio.fs.WindowsFileCopy.copy(Unknown Source) at sun.nio.fs.WindowsFileSystemProvider.copy(Unknown Source) at java.nio.file.Files.copy(Unknown Source) at lucee.commons.io.res.type.file.FileResource.copyTo(FileResource.java:102) at lucee.commons.io.IOUtil.copy(IOUtil.java:126) at lucee.commons.io.res.util.ResourceUtil.moveTo(ResourceUtil.java:1106) at lucee.runtime.extension.RHExtension.move(RHExtension.java:252) at lucee.runtime.extension.RHExtension.init(RHExtension.java:239) at lucee.runtime.extension.RHExtension.<init>(RHExtension.java:225) at lucee.runtime.config.XMLConfigAdmin.updateRHExtension(XMLConfigAdmin.java:4677) at lucee.runtime.config.XMLConfigAdmin._updateRHExtension(XMLConfigAdmin.java:4667) at lucee.runtime.tag.Admin.doUpdateRHExtension(Admin.java:4264) at lucee.runtime.tag.Admin._doStartTag(Admin.java:740) at lucee.runtime.tag.Admin.doStartTag(Admin.java:353) at ext_applications_cfm184$cf.call(/admin/ext.applications.cfm:81) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:945)

Restart the admin solve the problem and able install the version 7.2.2 jre 8

Environment

None

Activity

Show:

dan.switzer@givainc.com 10 November 2021 at 21:54

I’ve forked the osgi-bundle-mssql and created a version which creates a working JAR with the mssql-jdbc v9.4.0 drivers. My fork is here:

https://github.com/dswitzer/osgi-bundle-mssql

I’ve also added a pull request with my changes in case anyone is interested.

My fork has a readme.md file which documents how you can actually build a new version of the driver manually and create the Lucee extension.

Pothys - MitrahSoft 13 July 2021 at 13:26

Now MSSQL extension versions up to 8.4.1.jre8 were available in admin and also there is no error with the upgrade and downgrade versions. So I closed this ticket.

Zac Spitzer 4 June 2021 at 14:43

Zac Spitzer 31 May 2021 at 07:13

we pulled the broken versions down, 7.22 shouldn’t have been affected, I have raised this with stay tuned, sorry for the problems, the mssql jdbc driver is a strange beast

Kai Koenig 30 May 2021 at 23:44
Edited

It seems that newer versions have been pulled now.

That’s including 7.2.2.jre8 - which was actually working fine on Java 8 and it missing all of a sudden started to break our automatic server setup from Lucee Light.

Could that maybe please be put back, unless there’s another reason for it to be removed?

The OP said:

Seems the same error shows for all the version above the 7.2.2 jre 8. Afterthat try to install version the 7.2.2 jre 8 randomly Shows the error like C:/..../..../lucee-express-5.3.7.48_2\lucee-server\context\extensions\installed\13caj0tnzdgsa.lex: The process cannot access the file because it is being used by another process.

So, 7.2.2 installed for them, and I believe whatever the access from another process issue is, it’s unrelated to 7.2.2 but to some other setup issue on their end.

Fixed

Details

Assignee

Reporter

Priority

Labels

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

Affects versions

Created 6 May 2021 at 06:59
Updated 11 November 2021 at 07:14
Resolved 13 July 2021 at 13:26

Flag notifications