Sharing sqljdbc_auth.dll among multiple war files in Tomcat server running at the same time -


following use-case:

i have started using camunda platform , accessing camunda process engine using custom application written in java. there 2 applications or war files in tomcat server. using inbuilt h2 database camunda application , sql server database custom application , using integrated authentication mechanism worked fine. have replicated h2 database sql server database , again using integrated authentication process engine connect sql server.

problem: after deploying 2 wars, when restart tomcat server, sqljdbc_auth.dll present in tomcat bin folder gets loaded camunda application , process engine accepts requests, accesses database , gives correct responses on camunda web applications(cockpit,tasklist,admin) when try login on custom application following error: " null.null failed load sqljdbc_auth.dll cause : native library c:\users\aakanksha\desktop\backup\$camunda_home\server\apache-tomcat-8.0.24\bin\sqljdbc_auth.dll loaded in classloader "

i understand why happening , have followed following solutions already:

sol.1 -

  1. added sqljdbc4.jar file $tomcat_home/lib folder

  2. added sqljdbc_auth.dll file $tomcat_home/bin folder

sol.2 - added sqljdbc4.jar , sqljdbc_auth.dll file separate war files i.e. webinf/lib folders.

sol.3 -

  1. removed dll file $tomcat_home/bin folder , added same windows/system32

  2. added path path environment variable

sol.4 - added dll file java/jdk/bin folder.

sol.1, sol.3 , sol.4 - dll files loaded , used 1 war not other same error. sol.2 - lead error " com.microsoft.sqlserver.jdbc.authenticationjni. failed load sqljdbc_auth.dll cause : no sqljdbc_auth in java.library.path "

both of applications running @ same time , have different sql server databases make connections to. possible 2 wars running @ same instant use shared dll making connection different databases?

kindly share suggestions , ideas.


Comments

Popular posts from this blog

angular - Ionic slides - dynamically add slides before and after -

minify - Minimizing css files -

Add a dynamic header in angular 2 http provider -