no sqljdbc auth in java library path

Question

I have a Java EE Web Application which connects to a SQL Server 2008 instance  I don t have any problem connecting and retrieving to all my tables  except for one of them  The error in the Tomcat log is      WARNING  Failed to load the sqljdbc auth dll cause  - no sqljdbc auth in java library path

User · Answer

Here are the steps if you want to do this from Eclipse :

1) Create a folder 'sqlauth' in your C: drive, and copy the dll file sqljdbc_auth.dll to the folder

1) Go to Run> Run Configurations

2) Choose the 'Arguments' tab for your class

3) Add the below code in VM arguments:

-Djava.library.path="C:\\sqlauth"

4) Hit 'Apply' and click 'Run'

Feel free to try other methods .

User · Answer

The error is clear  isn t it    You ve not added the path where sqljdbc auth dll is present  Find out in the system where the DLL is and add that to your classpath   And if that also doesn t work  add the folder where the DLL is present  I m assuming  Microsoft SQL Server JDBC Driver 3 0 sqljdbc 3 0 enu auth x86  to your PATH variable   Again if you re going via ant or cmd you have to explicitly mention the path using -Djava library path  path to MS SQL AUTH DLL

User · Answer

For easy fix follow these steps    goto  https   docs microsoft com en-us sql connect jdbc building-the-connection-url Connectingintegrated Download the JDBC file and extract to your preferred location open the auth folder matching your OS x64 or x86 copy sqljdbc auth dll file  paste in  C  Program Files Java jdk version bin restart either eclipse or netbeans

User · Answer

I ve just encountered the same problem but within my own application  I didn t like the solution with copying the dll since it s not very convenient so I did some research and came up with the following programmatic solution    Basically  before doing any connections to SQL server  you have to add the sqljdbc auth dll to path   which is easy to say   PathHelper appendToPath  C   sqljdbc 6 2  enu  auth  x64     once you know how to do it   import java lang reflect Field   public class PathHelper       public static void appendToPath String dir            String path   System getProperty  java library path            path   dir         path          System setProperty  java library path   path            try                final Field sysPathsField   ClassLoader class getDeclaredField  sys paths                sysPathsField setAccessible true               sysPathsField set null  null                      catch  Exception ex               throw new RuntimeException ex                         Now integration authentication works like a charm      Credits to https   stackoverflow com a 21730111 1734640 for letting me figure this out

User · Answer

1  Download the JDBC Driver here   2  unzip the file and go to sqljdbc version fra auth x86 or  x64   3  copy the sqljdbc auth dll to C  Program Files Java jre Version bin  4  Finally restart eclipse

User · Answer

To resolve I did the following    Copied sqljdbc auth dll into dir  C  Windows System32 Restarted my application

[java] no sqljdbc_auth in java.library.path

Examples related to java

Examples related to sql-server

Examples related to sql-server-2008

Examples related to jakarta-ee