commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Lipofsky" <Daniel.Lipof...@bricsnet.com>
Subject RE: DBCP: Native SSPI library not loaded
Date Fri, 05 May 2006 21:31:32 GMT
I didn't have it in WEB-INF/lib (just server/lib).
I tried adding it to WEB-INF/lib but that didn't help.
Does anyone have any other ideas?
Thanks,
Dan

> -----Original Message-----
> From: Alfredo Ledezma Melendez 
> 
> Try putting jtds jar in common/lib and not into WEB-INF/lib, 
> i. e. get it
> out from your web application.
> 
> Regards
> ... just guessing ...
> 
> > -----Original Message-----
> > From: Daniel Lipofsky
> >
> > I am trying to setup database connection pooling with BIRT 2.0.
> > I have been using jTDS and I believe I can use commons-dbcp-1.2.1
> > on top of jTDS to achieve this.  I got past many obstacles on
> > my own but now I getting the following error:
> >
> > SQLException: I/O Error: SSO Failed: Native SSPI library not loaded.
> > Check the java.library.path system property.
> >
> > I don't know what the native SSPI library would be, so I
> > am not sure what to look for in the path.
> >
> > Any references to this error message I find in newgroups seem to
> > reference windows authentication, but I am using SQL Server
> > authentication, or at least I was with jTDS - if I am somehow
> > using windows auth how would I switch back?

My JOCL and stack trace

<object class="org.apache.commons.dbcp.PoolableConnectionFactory"
        xmlns="http://apache.org/xml/xmlns/jakarta/commons/jocl">
   <!-- the first argument is the ConnectionFactory -->
   <object
class="org.apache.commons.dbcp.DriverManagerConnectionFactory">
      <string
value="jdbc:jtds:sqlserver://localhost:1433/dlipofsky_head_Biz"/>
      <object class="java.util.Properties" null="true"/>
   </object>
   <!-- the next argument is the ObjectPool -->
   <object class="org.apache.commons.pool.impl.GenericObjectPool">
      <object class="org.apache.commons.pool.PoolableObjectFactory"
null="true"/>
      <int value="10"/> <!-- max active -->
      <byte value="1"/> <!-- when exhausted action, 0 = fail, 1 = block,
2 = grow -->
      <long value="2000"/> <!-- max wait -->
      <int value="10"/> <!-- max idle -->
      <boolean value="false"/> <!-- test on borrow -->
      <boolean value="false"/> <!-- test on return -->
      <long value="10000"/> <!-- time between eviction runs -->
      <int value="5"/> <!-- number of connections to test per eviction
run -->
      <long value="5000"/> <!-- min evictable idle time -->
      <boolean value="true"/> <!-- test while idle -->
   </object>
   <!-- the next argument is the KeyedObjectPoolFactory -->
   <object
class="org.apache.commons.pool.impl.StackKeyedObjectPoolFactory">
      <int value="5"/> <!-- max idle -->
   </object>
   <string value="SELECT COUNT(*) FROM DUAL"/> <!-- validation query -->
   <boolean value="false"/> <!-- default read only -->
   <boolean value="true"/> <!-- default auto commit -->
</object>

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:611)
 at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:33
1)
 at
net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50
)
 at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
 at java.sql.DriverManager.getConnection(DriverManager.java:512)
 at java.sql.DriverManager.getConnection(DriverManager.java:193)
 at
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(
DriverManagerConnectionFactory.java:46)
 at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableCon
nectionFactory.java:290)
 at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjec
tPool.java:840)
 at
org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:175)
 at java.sql.DriverManager.getConnection(DriverManager.java:512)
 at java.sql.DriverManager.getConnection(DriverManager.java:140)
 at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDr
iverManager.java:148)
 at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JD
BCDriverManager.java:94)
 at
org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection
.java:150)
 ... 34 more
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:1894)
 at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:584)
 ... 48 more

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message