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 -
added sqljdbc4.jar file $tomcat_home/lib folder
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 -
removed dll file $tomcat_home/bin folder , added same windows/system32
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
Post a Comment