Need POM.xml for mssql jdbc driver wrapper

[adobecq-venkat]

Hi,

I am using AEM 6.1 and need to connect MSSQL Database. I downloaded driver from Microsoft site and uploaded in OSGI console and setup data source and it works fine.

But I wanted to move this JDBC driver as part of my code build so all the users will get it in their build automatically.

I tried to use embed tag in pom.xml and used "*" , some how it doesn't work.

Does any one has working POM.xml for MSSQL JDBC driver?

Thanks for your help.

Venkat

[Ankur_Khare]

look at this one-

https://stackoverflow.com/questions/6942407/setting-up-maven-dependency-for-sql-server

[arunpatidar]

you need to update apps POM.XML to copy sql bundle in apps/yourapp/install folder same as your project bundle.

[shelly-goel · Accepted solution]

@adobecq-venkat  You would also have to export that dependency under <export-package> section of the pom.xml

A similar issue with a different 3rd party jar/ bundle inclusion is mentioned here: https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-maven-build-cannot-res...