sql server - JDBC / IntelliJ Failed to load the sqljdbc_auth.dll -


i trying run small test program in intellij. code:

string driverclass = "com.microsoft.sqlserver.jdbc.sqlserverdriver";     string url = "jdbc:sqlserver://test.test.com;integratedsecurity=true";     string username = "test";     string password = "test";     class.forname(driverclass);     try (connection con = drivermanager.getconnection(url, username, password);          statement st1 = con.createstatement();          statement st2 = con.createstatement();     ) {       string sql1 = "exec  [dbo].[cleanup]";       string sql2 = "exec  [dbo].[detailsall] \"detailsall.csv\" ";       st1.execute(sql1);       st2.execute(sql2);      }catch(exception e){      system.out.println(e.getmessage());     }

i have added following vm options:

-djava.library.path="\users\sgupta\ideaprojects\todos\sqljdbc_4.0\enu\auth\x86\" enter image description here

running program results in:

apr 05, 2013 5:43:20 pm com.microsoft.sqlserver.jdbc.authenticationjni warning: failed load sqljdbc_auth.dll cause : no sqljdbc_auth in java.library.path driver not configured integrated authentication. clientconnectionid:db8a3aa3-d84b-49d2-a7eb-64c4187a8303

i have double checked path have specified in vm option. other suggestions? thanks.

it looks have bad news you. straight sqljdbc documentation included .tar.gz file. after upack file, go webpage: sqljdbc_4.0/enu/help/default.htm

under contents >>> connecting sql server jdbc driver >>> building connection url, go section: "connecting integrated authentication"

at bottom of section has following quote, says can't use dll approach non-windows systems.

the jdbc driver not support integrated authentication when driver runs on non-windows operating systems. driver not provide functionality supply windows authentication credentials, such user name , password, when connecting sql server non-windows operating systems. in such cases, applications must use sql server authentication instead.

however, same file's equivalent msdn documentation seems suggest non-windows operating systems, can work kerberos. http://msdn.microsoft.com/en-us/library/ms378428.aspx

this msdn link gives overview of the kerberos process, falls short on detailed setup non-windows machines. http://msdn.microsoft.com/en-us/library/gg558122.aspx

if has figured out details getting kerberos working connect sql server non-windows machine, i'd love hear them.


Comments

Post a Comment

Popular posts from this blog

ios - iPhone/iPad different view orientations in different views , and apple approval process -

i force app's home screen portrait , other views landscape. apple rejects app if this? if not , how force first screen launch in portrait mode? , force other screens launch in landscape. this not duplicate question search every possible answer in website. i force app's home screen portrait , other views landscape. apple rejects app if this? no apple not reject app this. have lot of apps doesn't support orientation. forcing on 1 screen won't cause app reject. if not , how force first screen launch in portrait mode? , force other screens launch in landscape. can on write : -(nsuinteger)supportedinterfaceorientations; function.
Read more

java Extracting Zip file -

i'm looking way extract zip file. far have tried java.util.zip , org.apache.commons.compress, both gave corrupted output. basically, input zip file contain 1 single .doc file. java.util.zip: output corrupted. org.apache.commons.compress: output blank file, 2 mb size. so far commercial software winrar work perfectly. there java library make use of this? this method using java.util library: public void extractzipnative(file filezip) { zipinputstream zis; stringbuilder sb; try { zis = new zipinputstream(new fileinputstream(filezip)); zipentry ze = zis.getnextentry(); byte[] buffer = new byte[(int) ze.getsize()]; fileoutputstream fos = new fileoutputstream(this.tempfolderpath+ze.getname()); int len; while ((len=zis.read(buffer))>0) { fos.write(buffer); } fos.flush(); fos.close(); } catch (filenotfoundexception e) { // todo auto-generated catch block ...
Read more

C# WinForm - loading screen -

i ask how make loading screen (just picture or something) appears while program being loaded, , disappears when program has finished loading. in fancier versions, have seen process bar (%) displayed. how can have that, , how calculate % show on it? i know there form_load() event, not see form_loaded() event, or % property / attribute anywhere. all need create 1 form splash screen , show before main start showing landing page , close splash once landing page loaded. class splashform { //delegate cross thread call close private delegate void closedelegate(); //the type of form displayed splash screen. private static splashform splashform; static public void showsplashscreen() { // make sure launched once. if (splashform != null) return; thread thread = new thread(new threadstart(splashform.showform)); thread.isbackground = true; thread.setapartmentstate(apartmentstate.sta); thread....
Read more