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:
- Inside the plugin root
- In a lib folder in the plugin
- I also tried to put the dll in
the Eclipse plugin - org.eclipse.birt.report.data.oda.jdbc_2.1.1.v20070205-1728
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