Skip to main content


Eclipse Community Forums

      Home
Home » Archived » BIRT » How to set up trusted connection in BIRT?
How to set up trusted connection in BIRT? [message #502960] Thu, 10 December 2009 07:59 Go to next message
Eclipse UserFriend
Hi all.

I've tried to set up a trusted connection from BIRT to MSSQL but with no success.
I'm using BIRT ReportEngine in my java application which runs as a Windows service under a certain ActiveDirectory user. This user is permitted to trusted connectivity to MSSQL database. When application starts generating report it throws an exception that it could not establish a trusted connection because it could not find a ntlmauth.dll (I use jTDS driver to connect to MSSQL) in its library path (java.library.path) though it is there. The exact exception is:

2009/12/09 16:48:48 | INFO | jvm 1 | org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property..
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo nnect(JDBCDriverManager.java:262)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC onnection(JDBCDriverManager.java:212)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr l(Connection.java:234)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connec tion.java:160)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo nnection.open(OdaConnection.java:238)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:180)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.data.engine.executor.DataSource.newConnecti on(DataSource.java:193)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.data.engine.executor.DataSource.open(DataSo urce.java:181)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD ataSource(DataSourceRuntime.java:209)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSour ce(QueryExecutor.java:396)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecu tion(QueryExecutor.java:315)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:448)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.pr oduceQueryResults(PreparedDataSourceQuery.java:190)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:178)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute (PreparedOdaDSQuery.java:144)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.data.adapter.impl.DataRequestSession Impl.execute(DataRequestSessionImpl.java:511)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExec uteQuery(DteDataEngine.java:139)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:254)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1818)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.executor.QueryItemExecutor.ex ecuteQuery(QueryItemExecutor.java:80)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.executor.DataItemExecutor.exe cute(DataItemExecutor.java:75)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.internal.executor.dup.Suppres sDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor .java:43)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.execute(WrappedReportItemExecutor.java:4 6)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.internal.executor.l18n.Locali zedReportItemExecutor.execute(LocalizedReportItemExecutor.ja va:34)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:65)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.la youtChildren(HTMLStackingLM.java:26)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:137)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.resumeLayout(HTMLInlineStackingLM.java:111)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.layoutNodes(HTMLInlineStackingLM.java:160)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.la youtChildren(HTMLStackingLM.java:26)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:137)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:70)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.la youtChildren(HTMLStackingLM.java:26)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layou tChildren(HTMLTableLM.java:132)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:137)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:70)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:90)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:99)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doR un(RunAndRenderTask.java:170)
2009/12/09 16:48:48 | INFO | jvm 1 | at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:75)
2009/12/09 16:48:48 | INFO | jvm 1 | at com....server.AutoReportUtil.genReport(AutoReportUtil.java:4 04)
2009/12/09 16:48:48 | INFO | jvm 1 | at com....server.AutoReportUtil.generateReports(AutoReportUtil. java:156)
2009/12/09 16:48:48 | INFO | jvm 1 | at com...common.utils.Scheduler$execTask.run(Scheduler.java:133 )
2009/12/09 16:48:48 | INFO | jvm 1 | at java.util.TimerThread.mainLoop(Timer.java:512)
2009/12/09 16:48:48 | INFO | jvm 1 | at java.util.TimerThread.run(Timer.java:462)


Could someone help?
Re: How to set up trusted connection in BIRT? [message #502961 is a reply to message #502960] Thu, 10 December 2009 08:01 Go to previous messageGo to next message
Eclipse UserFriend
BIRT v.2.5.1
Java v.1.6.0_17
jTDS v.1.2.4
Re: How to set up trusted connection in BIRT? [message #503208 is a reply to message #502961] Fri, 11 December 2009 01:54 Go to previous messageGo to next message
Eclipse UserFriend
Problem is solved.
I used wrong driver (net.sourceforge.jtds.jdbc.Driver instead of net.sourceforge.jtds.jdbcx.JtdsDataSource).
Re: How to set up trusted connection in BIRT? [message #503716 is a reply to message #503208] Tue, 15 December 2009 03:32 Go to previous messageGo to next message
Eclipse UserFriend
It was premature to close this question.

I still have problems with trusted connection. BIRT could not use the JtdsDataSource class as it is not a decendant of java.sql.Driver class.
Re: How to set up trusted connection in BIRT? [message #503814 is a reply to message #503716] Tue, 15 December 2009 16:46 Go to previous message
Eclipse UserFriend
Vasiliy,

You may need to log a bug on this. The only bug I found in the system was:
https://bugs.eclipse.org/bugs/show_bug.cgi?id=261963

Jason

Vasiliy wrote:
> It was premature to close this question.
>
> I still have problems with trusted connection. BIRT could not use the
> JtdsDataSource class as it is not a decendant of java.sql.Driver class.
>
Previous Topic:How to display HTML in a Table Column?
Next Topic:How to set the xml data source in java
Goto Forum:
  


Current Time: Sun Nov 09 02:36:29 EST 2025

Powered by FUDForum. Page generated in 0.03884 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly