MSSQL OSGI driver bundle | Community
Skip to main content
crich2784
Level 6
August 10, 2022
Solved

MSSQL OSGI driver bundle

  • August 10, 2022
  • 4 replies
  • 1689 views

 

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.
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Meet1

@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 

4 replies

Mayank_Gandhi
Adobe Employee
Adobe Employee
August 10, 2022

@crich2784  checking internally

crich2784
crich2784Author
Level 6
August 11, 2022

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

Adobe Employee
August 11, 2022

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

crich2784
crich2784Author
Level 6
August 11, 2022

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.

Meet1Adobe EmployeeAccepted solution
Adobe Employee
August 11, 2022

@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
Adobe Employee
Adobe Employee
August 12, 2022

@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-guide/html/ch07.html