commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alfredo Ledezma Melendez <alfredo.melen...@mail.telcel.com>
Subject RE: DBCP: Native SSPI library not loaded
Date Fri, 05 May 2006 22:01:12 GMT


Two questions....

What kind of application are you running (standalone, webapp, swing...)? If
using a webapp server, what server are you using?
> -----Original Message-----
> From: Daniel Lipofsky [mailto:Daniel.Lipofsky@bricsnet.com]
> Sent: Viernes, 05 de Mayo de 2006 04:32 p.m.
> To: Jakarta Commons Users List
> Subject: RE: DBCP: Native SSPI library not loaded
> Get it out from server/lib and put into $JAVA_HOME/jre/lib/ext or
$JAVA_HOME/jre/lib/ and restart your application
>
> 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
>


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: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message