Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » java.lang.UnsatisfiedLinkError: no sqljdbc_auth in java.library.path(java.lang.UnsatisfiedLinkError: no sqljdbc_auth in java.library.path)
java.lang.UnsatisfiedLinkError: no sqljdbc_auth in java.library.path [message #1344987] Sat, 10 May 2014 01:14 Go to next message
Vishal Singla is currently offline Vishal SinglaFriend
Messages: 1
Registered: May 2014
Junior Member
Embarrassed

I am kinda frustrated to do some simple thing in java it take you many crazy time.

I am trying to do a simple thing, setting up connectivity b/w eclipse and sql 2008 but keep getting an error mentioned below. I have already tried copying in every possible location suggested on every blog i have gone through e.g. JRE\bin, adding to class path, setting the native path to sqljdbc_auth but none of them worked for me..

It would be a great help if someone can help me getting through this crazy error.

com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:d81068e7-3292-4a53-b0a7-f548722abfa6
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1667)
at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<init>(AuthenticationJNI.java:60)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2229)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:328)
at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)
at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)
at org.eclipse.datatools.enablement.msft.internal.sqlserver.connection.JDBCSQLServerConnectionFactory.createConnection(JDBCSQLServerConnectionFactory.java:27)
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)
Caused by: java.lang.UnsatisfiedLinkError: no sqljdbc_auth in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1860)
at java.lang.Runtime.loadLibrary0(Runtime.java:845)
at java.lang.System.loadLibrary(System.java:1084)
at com.microsoft.sqlserver.jdbc.AuthenticationJNI.<clinit>(AuthenticationJNI.java:35)
... 19 more
Re: java.lang.UnsatisfiedLinkError: no sqljdbc_auth in java.library.path [message #1349450 is a reply to message #1344987] Mon, 12 May 2014 07:44 Go to previous message
Sylvain EVEILLARD is currently offline Sylvain EVEILLARDFriend
Messages: 530
Registered: July 2009
Senior Member
I managed to make it work by placing the jdbc jar in a folder and the dll (sqljdbc_auth.dll) in auth/x64 or auth/x86 of the same folder depending on your platform.

folder
- sqljdbc4.jar
- auth
 - x64
  - sqljdbc_auth.dll
 - x86
  - sqljdbc_auth.dll
Previous Topic:Hive and Kerberos support in DTP
Next Topic:Getting parser for JDBC queries
Goto Forum:
  


Current Time: Wed Jul 01 23:31:57 GMT 2015

Powered by FUDForum. Page generated in 0.01910 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software