先说下我的开发环境是Myeclipse5.5
我在用JTDS做驱动的时候出现如下问题:
!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2008-02-22 23:45:27.281
!MESSAGE Error while performing database login with the JTDS driver
!STACK 0
java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:614)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2. <init> (ConnectionJDBC2.java:344)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3. <init> (ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:182)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99)
at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:43)
at java.lang.Thread.run(Unknown Source)
Caused by: java.io.IOException: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
at net.sourceforge.jtds.jdbc.TdsCore.sendMSLoginPkt(TdsCore.java:1889)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:587)
... 6 more
产生这一错误的原因有多种,上网搜了一下才发现忽略了一个很变态的不是原因的原因
原来在设置数据库登陆方式时要设为双验证(Windows和SQL)