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]
