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 [mailto:[EMAIL PROTECTED] > Sent: Viernes, 05 de Mayo de 2006 01:51 p.m. > To: [email protected] > Subject: DBCP: Native SSPI library not loaded > > > 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? > > Below is my JOCL file and a partial stack trace. > > Thanks, > Dan > > <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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Este mensaje es exclusivamente para el uso de la persona o entidad a quien esta dirigido; contiene informacion estrictamente confidencial y legalmente protegida, cuya divulgacion es sancionada por la ley. Si el lector de este mensaje no es a quien esta dirigido, ni se trata del empleado o agente responsable de esta informacion, se le notifica por medio del presente, que su reproduccion y distribucion, esta estrictamente prohibida. Si Usted recibio este comunicado por error, favor de notificarlo inmediatamente al remitente y destruir el mensaje. Todas las opiniones contenidas en este mail son propias del autor del mensaje y no necesariamente coinciden con las de Radiomovil Dipsa, S.A. de C.V. o alguna de sus empresas controladas, controladoras, afiliadas y subsidiarias. Este mensaje intencionalmente no contiene acentos. This message is for the sole use of the person or entity to whom it is being sent. Therefore, it contains strictly confidential and legally protected material whose disclosure is subject to penalty by law. If the person reading this message is not the one to whom it is being sent and/or is not an employee or the responsible agent for this information, this person is herein notified that any unauthorized dissemination, distribution or copying of the materials included in this facsimile is strictly prohibited. If you received this document by mistake please notify immediately to the subscriber and destroy the message. Any opinions contained in this e-mail are those of the author of the message and do not necessarily coincide with those of Radiomovil Dipsa, S.A. de C.V. or any of its control, controlled, affiliates and subsidiaries companies. No part of this message or attachments may be used or reproduced in any manner whatsoever. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
