| [birt-news] Using dll (JTDS Single Sign On) with BIRT Report |
|
Hi, I am not sure if this is the right place for this message.
If not, I apologize and would
appreciate if some one can refer me to the appropriate place. I am trying to use JTDS JDBC driver’s Single Sign On feature
to access a SQL Server database from BIRT. But I am getting exceptions. I am using these examples,
‘org.eclipse.birt.examples.rcpengine’ and
‘org.eclipse.birt.examples.rcpviewer’. Note that I tried changing the Data
Source properties for my report to use a user name / password (SQL Server
authentication) and that works. I am getting the below exception when I set the
user name / pwd to null, so as to use windows authentication. Also I have been using ntlmauth.dll
for my other RCP Apps without any problems. For RCP (without BIRT), I had put
the dll in my plugin root. For the BIRT examples, I tried putting
‘ntlmauth.dll’ in the following places:
None of the above worked. I would very much appreciate if any one can help me with
this. Regards, Venkat. org.eclipse.birt.report.data.oda.jdbc.JDBCException: Failed to get connection. SQL error #1: I/O Error: SSO Failed: Native SSPI library not loaded.
Check the java.library.path system property. ; java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the
java.library.path system property. at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:154) at
org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:111) at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:235) at
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:140) at
org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:133) at org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:121) at
org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:206) at
org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:248) at
org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:202) at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:396) at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:145) at
org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:134) at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:125) at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:119) at
org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:210) at
org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1641) at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:62) at
org.eclipse.birt.report.engine.executor.DataItemExecutor.execute(DataItemExecutor.java:81) at
org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:35) at
org.eclipse.birt.report.engine.layout.content.BlockStackingExecutor.getNextChild(BlockStackingExecutor.java:47) at
org.eclipse.birt.report.engine.layout.pdf.PDFBlockStackingLM.traverseChildren(PDFBlockStackingLM.java:69) at
org.eclipse.birt.report.engine.layout.pdf.PDFStackingLM.layoutChildren(PDFStackingLM.java:120) at
org.eclipse.birt.report.engine.layout.pdf.PDFAbstractLM.layout(PDFAbstractLM.java:132) at
org.eclipse.birt.report.engine.layout.pdf.PDFRowLM.traverseChildren(PDFRowLM.java:115) at
org.eclipse.birt.report.engine.layout.pdf.PDFStackingLM.layoutChildren(PDFStackingLM.java:120) at
org.eclipse.birt.report.engine.layout.pdf.PDFAbstractLM.layout(PDFAbstractLM.java:132) at
org.eclipse.birt.report.engine.layout.pdf.PDFRowLM.layout(PDFRowLM.java:49) at org.eclipse.birt.report.engine.layout.pdf.PDFBlockStackingLM.layoutChildNode(PDFBlockStackingLM.java:92) at
org.eclipse.birt.report.engine.layout.pdf.PDFBlockStackingLM.traverseChildren(PDFBlockStackingLM.java:72) at org.eclipse.birt.report.engine.layout.pdf.PDFTableLM.traverseChildren(PDFTableLM.java:152) at
org.eclipse.birt.report.engine.layout.pdf.PDFStackingLM.layoutChildren(PDFStackingLM.java:120) at
org.eclipse.birt.report.engine.layout.pdf.PDFAbstractLM.layout(PDFAbstractLM.java:132) at
org.eclipse.birt.report.engine.layout.pdf.PDFBlockStackingLM.layoutChildNode(PDFBlockStackingLM.java:92) at
org.eclipse.birt.report.engine.layout.pdf.PDFBlockStackingLM.traverseChildren(PDFBlockStackingLM.java:72) at org.eclipse.birt.report.engine.layout.pdf.PDFStackingLM.layoutChildren(PDFStackingLM.java:120) at
org.eclipse.birt.report.engine.layout.pdf.PDFPageLM.layout(PDFPageLM.java:210) at org.eclipse.birt.report.engine.layout.pdf.PDFReportLayoutEngine.layoutReport(PDFReportLayoutEngine.java:60) at
org.eclipse.birt.report.engine.layout.pdf.PDFReportLayoutEngine.layout(PDFReportLayoutEngine.java:97) at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:205) at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:142) at
org.eclipse.birt.examples.rcpengine.View.previewReport(View.java:258) at org.eclipse.birt.examples.rcpengine.View.access$1(View.java:206) at
org.eclipse.birt.examples.rcpengine.View$3.widgetSelected(View.java:180) at
org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:90) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at
org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928) at
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348) at
org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968) at
org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1930) at
org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1894) at
org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:422) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at
org.eclipse.birt.examples.rcpengine.Application.run(Application.java:18) at
org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:78) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92) at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68) at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400) at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:177) at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at
java.lang.reflect.Method.invoke(Unknown Source) at
org.eclipse.core.launcher.Main.invokeFramework(Main.java:336) at
org.eclipse.core.launcher.Main.basicRun(Main.java:280) at
org.eclipse.core.launcher.Main.run(Main.java:977) at
org.eclipse.core.launcher.Main.main(Main.java:952) Caused by: 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:331) at
net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50) at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178) at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$WrappedDriver.connect(JDBCDriverManager.java:787) at
java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown
Source) at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:185) at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:146) at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection.java:149) ... 65 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) ... 74 more |