[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[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:

 

  1. Inside the plugin root
  2. In a lib folder in the plugin
  3. 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