Eclipse Community Forums: BIRT » Where do jars with db drivers need to go for BIRT viewer in Tomcat

Home » Archived » BIRT » Where do jars with db drivers need to go for BIRT viewer in Tomcat

Where do jars with db drivers need to go for BIRT viewer in Tomcat [message #138028]

Thu, 02 March 2006 08:16

Eclipse User

Originally posted by: mslists.lexi.com

I have the BRT view installed as a web app in Tomcat and the parameter
dialog comes up ok, but no data is returned in the report. I'm assuming
that it cannot connect to the database. Where should the jar files
containing the jdbc drivers go?

--<

Re: Where do jars with db drivers need to go for BIRT viewer in Tomcat [message #138161 is a reply to message #138028]

Thu, 02 March 2006 10:23

Eclipse User

Originally posted by: vladperl.semanticprogrammer.org

>I have the BRT view installed as a web app in Tomcat and the parameter
>dialog comes up ok, but no data is returned in the report. I'm assuming
>that it cannot connect to the database. Where should the jar files
>containing the jdbc drivers go?

C:\Program Files\Apache Software Foundation\Tomcat
5.5\webapps\birt\plugins\org.eclipse.birt.report.data.oda.jd bc\drivers

Re: Where do jars with db drivers need to go for BIRT viewer in Tomcat [message #138361 is a reply to message #138161]

Thu, 02 March 2006 12:37

Eclipse User

Originally posted by: mslists.lexi.com

Running on unix, and I have put the jar everywhere I can think of:

tomcat/common/lib
tomcat/shared/lib
tomcat/webapps/birt-viewer/WEB-INF/lib
tomcat/webapps/birt-viewer/plugins/org.eclipse.birt.report.d ata.oda.jdbc/drivers
tomcat/webapps/birt-viewer/plugins/org.eclipse.birt.report.d ata.oda.jdbc/lib
tpmcat/webapps/birt-viewer/plugins/org.eclipse.birt.report.d ata.oda.jdbc

still no data appearing in the report...

Vladimir wrote:
>>I have the BRT view installed as a web app in Tomcat and the parameter
>>dialog comes up ok, but no data is returned in the report. I'm assuming
>>that it cannot connect to the database. Where should the jar files
>>containing the jdbc drivers go?
>
>
> C:\Program Files\Apache Software Foundation\Tomcat
> 5.5\webapps\birt\plugins\org.eclipse.birt.report.data.oda.jd bc\drivers
>
>

Re: Where do jars with db drivers need to go for BIRT viewer in Tomcat [message #138373 is a reply to message #138361]

Thu, 02 March 2006 13:04

Eclipse User

Originally posted by: vladperl.semanticprogrammer.org

> tomcat/common/lib
> tomcat/shared/lib
> tomcat/webapps/birt-viewer/WEB-INF/lib
> tomcat/webapps/birt-viewer/plugins/org.eclipse.birt.report.d ata.oda.jdbc/drivers
> tomcat/webapps/birt-viewer/plugins/org.eclipse.birt.report.d ata.oda.jdbc/lib
> tpmcat/webapps/birt-viewer/plugins/org.eclipse.birt.report.d ata.oda.jdbc
>
>
> still no data appearing in the report...

Probably you didn't bind report parameters to dataset parameters.

Re: Where do jars with db drivers need to go for BIRT viewer in Tomcat [message #138813 is a reply to message #138373]

Fri, 03 March 2006 06:50

Eclipse User

Originally posted by: mslists.lexi.com

Vladimir wrote:
>>tomcat/common/lib
>>tomcat/shared/lib
>>tomcat/webapps/birt-viewer/WEB-INF/lib
>> tomcat/webapps/birt-viewer/plugins/org.eclipse.birt.report.d ata.oda.jdbc/drivers
>> tomcat/webapps/birt-viewer/plugins/org.eclipse.birt.report.d ata.oda.jdbc/lib
>> tpmcat/webapps/birt-viewer/plugins/org.eclipse.birt.report.d ata.oda.jdbc
>>
>>
>>still no data appearing in the report...
>
>
> Probably you didn't bind report parameters to dataset parameters.
>
>

Nope; forgot to say that the report runs fine inside eclipse. The params are getting bound there...

Re: Where do jars with db drivers need to go for BIRT viewer in Tomcat [message #138931 is a reply to message #138813]

Fri, 03 March 2006 10:57

Eclipse User

Originally posted by: vladperl.semanticprogrammer.org

> Nope; forgot to say that the report runs fine inside eclipse. The params
> are getting bound there...
I know one more situation when it happen.
If you use firefox 1.5 and birt 2.0 release.
Newer version of the birt fixed problem with Firefox.
Anyway good idea to check out log file.
Location of the log file defined in web.xml

Re: Where do jars with db drivers need to go for BIRT viewer in Tomcat [message #139574 is a reply to message #138931]

Mon, 06 March 2006 08:57

Eclipse User

Originally posted by: mslists.lexi.com

Vladimir wrote:
>>Nope; forgot to say that the report runs fine inside eclipse. The params
>>are getting bound there...
>
> I know one more situation when it happen.
> If you use firefox 1.5 and birt 2.0 release.
> Newer version of the birt fixed problem with Firefox.
> Anyway good idea to check out log file.
> Location of the log file defined in web.xml
>
>
I'm using 2.0.0 or the report framework and 2.0.1 of the runtime with firefox; guess i need newer...

Re: Where do jars with db drivers need to go for BIRT viewer in Tomcat [message #139673 is a reply to message #138361]

Mon, 06 March 2006 10:39

Eclipse User

Michael Stacey wrote:
> Running on unix, and I have put the jar everywhere I can think of:
>
> tomcat/common/lib
> tomcat/shared/lib
> tomcat/webapps/birt-viewer/WEB-INF/lib
> tomcat/webapps/birt-viewer/plugins/org.eclipse.birt.report.d ata.oda.jdbc/drivers
> tomcat/webapps/birt-viewer/plugins/org.eclipse.birt.report.d ata.oda.jdbc/lib
> tpmcat/webapps/birt-viewer/plugins/org.eclipse.birt.report.d ata.oda.jdbc
>
> still no data appearing in the report...

Running on Windows 2000 / Tomcat 4.1 I am experiencing this exact same
problem. Everything works fine inside of Eclipse, but I cannot seem to
get the JDBC driver to fire up in the web viewer. I copied the driver
in to 'plugins/org.eclipse.birt.report.data.oda.jdbc/drivers' also. The
test.rptdesign and SalesInvoice.rptdesign both work fine. Here is the
error I am getting:

There are errors on the report page:
- There are error(s) in report : report

Error0 : odaconsumer.CannotOpenConnection ( 1 time(s) )
detail : org.eclipse.birt.data.engine.core.DataException: Cannot open
the connection for the driver: org.eclipse.birt.report.data.oda.jdbc
Failed to get connection.
No suitable driver
at
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:136)
at
org.eclipse.birt.data.engine.executor.DataSource.newConnecti on(DataSource.java:154)
at
org.eclipse.birt.data.engine.executor.DataSource.open(DataSo urce.java:147)
at
org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiD ataSource(DataSourceRuntime.java:150)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.ope nDataSource(PreparedQuery.java:838)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.pre pareExecution(PreparedQuery.java:661)
at
org.eclipse.birt.data.engine.impl.PreparedQuery$Executor.acc ess$000(PreparedQuery.java:498)
at
org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(Pr eparedQuery.java:225)
at
org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.ex ecute(PreparedDataSourceQuery.java:145)
at
org.eclipse.birt.report.engine.data.dte.DteDataEngine.execut e(DteDataEngine.java:205)
at
org.eclipse.birt.report.engine.executor.QueryItemExecutor.op enResultSet(QueryItemExecutor.java:62)
at
org.eclipse.birt.report.engine.executor.TableItemExecutor.ex ecute(TableItemExecutor.java:122)
at
org.eclipse.birt.report.engine.executor.ReportExecutorVisito r.visitTableItem(ReportExecutorVisitor.java:187)
at
org.eclipse.birt.report.engine.ir.TableItemDesign.accept(Tab leItemDesign.java:69)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:125)
at
org.eclipse.birt.report.engine.executor.ReportExecutor.execu te(ReportExecutor.java:89)
at
org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run (RunAndRenderTask.java:175)
at
org.eclipse.birt.report.services.ReportEngineService.runAndR enderReport(Unknown
Source)
at
org.eclipse.birt.report.viewer.aggregation.layout.EngineFrag ment.doService(Unknown
Source)
at
org.eclipse.birt.report.viewer.aggregation.BaseFragment.serv ice(Unknown
Source)
at org.eclipse.birt.report.viewer.servlet.ViewerServlet.doGet(U nknown
Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:696)
at
org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:200)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:146)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:209)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:596)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:948)
at
org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:144)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:596)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:948)
at
org.apache.catalina.core.StandardContext.invoke(StandardCont ext.java:2358)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:133)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:596)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(Error DispatcherValve.java:118)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:594)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:116)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:594)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:948)
at
org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:127)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineVa lveContext.invokeNext(StandardPipeline.java:596)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPip eline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase. java:948)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapte r.java:152)
at
org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:799)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHand ler.processConnection(Http11Protocol.java:705)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndp oint.java:577)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)
Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: Failed
to get connection.
No suitable driver
at
org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr l(Connection.java:155)
at
org.eclipse.birt.report.data.oda.jdbc.Connection.open(Connec tion.java:111)
at
org.eclipse.datatools.connectivity.oda.consumer.helper.OdaCo nnection.open(OdaConnection.java:239)
at
org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.o penConnection(ConnectionManager.java:124)
... 52 more
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doCo nnect(JDBCDriverManager.java:148)
at
org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getC onnection(JDBCDriverManager.java:94)
at
org.eclipse.birt.report.data.oda.jdbc.Connection.connectByUr l(Connection.java:150)
... 55 more

Re: Where do jars with db drivers need to go for BIRT viewer in Tomcat [message #152105 is a reply to message #139673]

Sat, 08 April 2006 12:00

Eclipse User

Originally posted by: David.Peterson.mtvnmix.com

The instructions are updated.
http://www.eclipse.org/birt/phoenix/deploy/viewerSetup.php

Previous Topic:	RE: Birt Viewer (Tomcat 4.1) Displays No Records
Next Topic:	Order form in the "Installing BIRT Viewer in Tomcat" tutorial?

Goto Forum:

-=] Back to Top [=-

Current Time: Fri May 02 13:08:45 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter