MSSQL OSGI driver bundle

[crich2784]

This is another request for help with MSSQL driver bundle.  Microsoft's 6.2 driver is officially out of support for MSSQL 2019.  It's the only driver that seems to work without modification - it's already bundled in OSGI.  

We've installed the latest driver and 7.4 without success.  We've tried to create our own bundle without success.  The general problem is below:

As much as I like the old proverb - 

“If you give a man a fish, you feed him for a day. If you teach a man to fish, you feed him for a lifetime.” 

I'd just like to eat today.  Can anybody share a current MSSQL driver that works without error in AEM?  My customer cannot go to production with an unsupported driver.

[Mayank_Gandhi]

@crich2784  checking internally

[crich2784]

@Mayank_Gandhi it would be awesome if you could find one laying around.  Thank you for looking.

[sharoon23]

@crich2784 What is the use case that you are working? What feature of AEM Forms you are trying to use?

[crich2784]

I'm not sure what you mean . . . we're trying to use the MSSQL JDBC driver to assess Microsoft SQL Server from AEM.  Did I make it sound too complicated?  It's just database access with supported drivers.

[meet · Accepted solution]

@crich2784 from the bundle status it seems dependency org.osgi.service.jdbc bundle is missing.

can you please try installing this bundle jar [1] along with mssql driver. 

[1] https://mvnrepository.com/artifact/org.osgi/org.osgi.service.jdbc/1.0.0 

[Mayank_Gandhi]

@crich2784 use the eclipse plugin development feature to get rid of not required dependency, for whatever is left you can download the jar and upload it on the bundle's page directly.

https://www.eclipse.org/virgo/documentation/virgo-documentation-3.7.2.RELEASE/docs/virgo-tooling-gui...