Cannot open the connection for the JDBCdriver

Betor
edited February 11, 2022 in Analytics #1
Hi, im new to birt, and im doing a web application, i have make the data
> set
> correctly, i have the property binding correctly, but when i run my
> application from eclipse ide, run on server tomcat server, display the report but cant load the data from the
> database,
my report works when i run it from preview mode or when i run the .rpt design uploaded in the web apps in tomcat server
> i have the following stack trace:
>
>
>
> Nov 12, 2007 9:37:01 AM
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager findDriver
> WARNING: Failed to load JDBC driver class:
> com.microsoft.jdbc.sqlserver.SQLServerDriver
> Nov 12, 2007 9:37:01 AM
> org.eclipse.birt.data.engine.odaconsumer.ConnectionManager
> openConnection
> SEVERE: Cannot open connection.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC
> Driver
> class: com.microsoft.jdbc.sqlserver.SQLServerDriver
> at
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.findDriver(JDBCD
> riverManager.java:623)
> at
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.loadAndRegisterD
> river(JDBCDriverManager.java:731)
> at
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDr
> iverManager.java:192)
> at
> org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JD
> BCDriverManager.java:158)
> at
> org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUrl(Connection
> .java:158)
> at
> org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connection.java:11
> 5)
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.ope
> n(OdaConnection.java:235)
> at
> org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnectio
> n(ConnectionManager.java:145)
> at
> org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSourc
> e.java:134)
> at
> org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:12
> 1)
> at
> org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(Da
> taSourceRuntime.java:214)
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExec
> utor.java:265)
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryEx
> ecutor.java:210)
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.
> java:500)
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(Prepar
> edDataSourceQuery.java:161)
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOda
> DSQuery.java:142)
> at
> org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute
> (DataRequestSessionImpl.java:438)
> at
> org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQu
> ery(DataGenerationEngine.java:149)
> at
> org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQu
> ery(DataGenerationEngine.java:111)
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(Abstr
> actDataEngine.java:182)
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(Ex
> ecutionContext.java:1683)
> at
> org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(Q
> ueryItemExecutor.java:76)
> at
> org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableI
> temExecutor.java:61)
> at
> org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemE
> xecutor.execute(WrappedReportItemExecutor.java:45)
> at
> org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitt
> erExecutor.execute(ReportItemEmitterExecutor.java:45)
> at
> org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateIt
> emExecutor.execute(SuppressDuplicateItemExecutor.java:42)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNod
> es(HTMLBlockStackingLM.java:63)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.
> java:85)
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout
> (HTMLReportLayoutEngine.java:106)
> at
> org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(
> ReportDocumentBuilder.java:189)
> at
> org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:224)
> at
> org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:89)
> at
> org.eclipse.birt.report.service.ReportEngineService.runReport(Unknown
> Source)
> at
> org.eclipse.birt.report.service.BirtViewerReportService.runReport(Unknow
> n
> Source)
> at
> org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler
> .__execute(Unknown
> Source)
> at
> org.eclipse.birt.report.service.actionhandler.BirtGetPageActionHandler._
> _checkDocumentExists(Unknown
> Source)
> at
> org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandl
> er.prepareParameters(Unknown
> Source)
> at
> org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandl
> er.__execute(Unknown
> Source)
> at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.
> execute(Unknown
> Source)
> at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcess
> or.__executeAction(Unknown
> Source)
> at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProces
> sor.executeAction(Unknown
> Source)
> at
> org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handl
> eGetPage(Unknown
> Source)
> 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.birt.report.soapengine.processor.AbstractBaseComponentProces
> sor.process(Unknown
> Source)
> at
> org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdat
> edObjects(Unknown
> Source)
> 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.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java
> :397)
> at
> org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.ja
> va:186)
> at
> org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323
> )
> at
> org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.j
> ava:32)
> at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
> at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
> at
> org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453)
> at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
> at
> org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
> at
> org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(
> Unknown
> Source)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> at
> org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.j
> ava:327)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:252)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:173)
> at org.eclipse.birt.report.filter.ViewerFilter.doFilter(Unknown
> Source)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
> tionFilterChain.java:202)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
> erChain.java:173)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
> e.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
> e.java:178)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
> :126)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
> :105)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
> java:107)
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
> 48)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86
> 9)
> at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc
> essConnection(Http11BaseProtocol.java:664)
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
> .java:527)
> at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
> erWorkerThread.java:80)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
> .java:684)
> at java.lang.Thread.run(Unknown Source)
> Nov 12, 2007 9:37:02 AM
> org.eclipse.birt.report.engine.data.dte.DataGenerationEngine
> doExecuteQuery
> SEVERE: Cannot open the connection for the driver:
> org.eclipse.birt.report.data.oda.jdbc
> Cannot load JDBC Driver class:
> com.microsoft.jdbc.sqlserver.SQLServerDriver
> Nov 12, 2007 9:37:03 AM
> org.eclipse.birt.report.engine.data.dte.DataPresentationEngine
> doExecuteQuery
> SEVERE: Can't load the report query
>
> i have put my 3 jar files of the driver in the web apps of tomcat but i
> dont
> know if im ok, i will apreciate your replies thanks