nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Please help !

Mathematic

Hi, I have a major problem.

I have a jsp page like this

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ taglib uri="/birt.tld" prefix="birt" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<birt:viewer id="birtViewer" reportDesign="royalty_details.rptdesign" pattern="frameset" height="450" width="700" format="html" ></birt:viewer>
</body>
</html>

But when I startup the tomcat or jetty server it say's gives me this error
which is from my database connection.

However I am selecting a DataSource Driver com.mysql.jdbc.Driver
and I copied the mysql-connector-java-3.0.14-production-bin.jar
to the lib folder in Tomcat.

But I get this

Table (id = 12):
- Can't load the report query: 12.
Error.ReportQueryLoadingError ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Can't load the report query: 12. at org.eclipse.birt.report.engine.data.dte.DataPresentationEngine.doExecuteQuery(DataPresentationEngine.java:140) at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:248) at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1676) at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.executeQuery(ReportItemExecutor.java:409) at org.eclipse.birt.report.engine.internal.document.v4.TableItemExecutor.doExecute(TableItemExecutor.java:72) at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.execute(ReportItemExecutor.java:294) at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.prepareChildExecutor(ContainerExecutor.java:227) at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.hasNextChild(ContainerExecutor.java:110) at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:85) at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:85) at org.eclipse.birt.report.engine.api.impl.RenderTask$ReportExecutorWrapper.hasNextChild(RenderTask.java:648) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM$1.hasNextChild(HTMLPageLM.java:68) at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:60) at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90) at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:101) at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRangeRender.render(RenderTask.java:508) at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:221) at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1303) at org.eclipse.birt.report.service.BirtViewerReportService.getPage(BirtViewerReportService.java:178) at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.doExecution(AbstractGetPageActionHandler.java:236) at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:105) at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:89) at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47) at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:159) at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPage(BirtDocumentProcessor.java:87) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:111) at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186) at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java: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:454) 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(BirtSoapMessageDispatcherServlet.java:225) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619)

All I want to do is beable to view my report it works fine if I don't do query's.
So I know it must be a database connection issue. However when I view the report in the eclipse enviorment it works fine?

Find more posts tagged with

Comments

JasonW

Either copy the driver to
WEB-INFplatformpluginsorg.eclipse.birt.report.data.oda.jdbc_2.3.0.v20080610drivers
diretory of web app or set the OdaJDBCDriverClassPath app context variable before the data source is used. For example in the ds beforeOpen method:
reportContext.getAppContext().put("OdaJDBCDriverClassPath", "C:/apps/apache-tomcat-5.5.20/webapps/2.3/WEB-INF/lib");

JasonW

Also if you use this method:
For example in the ds beforeOpen method:
reportContext.getAppContext().put("OdaJDBCDriverClassPath", "C:/apps/apache-tomcat-5.5.20/webapps/2.3/WEB-INF/lib");

It is better to set it in the appcontext prior to running reports, because a change will require a restart of the app server.

Mathematic

Thanks but my problem is still happening. Probably partly because I don't know what the is for the com.mysql.jdbc.Driver .

I selected this when creating my datasource thru eclipse.
Tested the connection (said connection successful and then previewed it)
Worked fine in eclipse then I tried moving the WebViewerExample into the
webapp folder of tomcat. Then moved some .rptdesign files into the folder.

They ran fine if they didn't have query's in them (defeating the whole point of reports)

When I used a default datasource like their sample birts datasource.
It worked fine.

I.E select CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER,CLASSICMODELS.CUSTOMERS.PHONE
from CLASSICMODELS.CUSTOMERS

It worked fine.

But I want to use a mysql database. So I selected the com.mysql.jdbc.Driver
filled out the info and it worked fine in the eclipse enviorment.

But when I moved it to the tomcat server I get those db errors.

Is this the right jar file for that connector mysql-connector-java-3.0.14-production-bin.jar

I have put in the BeforeOpen textfield

reportContext.getAppContext().put("OdaJDBCDriverClassPath", "C:Tomcatapache-tomcat-5.5.26apache-tomcat-5.5.26webappsWebViewerExampleWEB-INFlib");

Directory of C:Tomcatapache-tomcat-5.5.26apache-tomcat-5.5.26webappsWebVie
werExampleWEB-INFlib

10/22/2008 11:08 AM <DIR> .
10/22/2008 11:08 AM <DIR> ..
08/22/2008 03:47 PM 37,380 axis-ant.jar
08/22/2008 03:47 PM 1,640,780 axis.jar
08/22/2008 03:47 PM 1,206,409 chartengineapi.jar
08/22/2008 03:47 PM 4,467,363 com.ibm.icu_3.8.1.v20080530.jar
08/22/2008 03:47 PM 30,117 commons-cli-1.0.jar
08/22/2008 03:47 PM 78,107 commons-discovery-0.2.jar
08/22/2008 03:47 PM 295,094 coreapi.jar
08/22/2008 03:47 PM 91,162 crosstabcoreapi.jar
08/22/2008 03:47 PM 34,951 dataadapterapi.jar
08/22/2008 03:47 PM 1,931 dataaggregationapi.jar
08/22/2008 03:47 PM 102,053 dteapi.jar
08/22/2008 03:47 PM 106,523 engineapi.jar
08/22/2008 03:47 PM 71,513 flute.jar
08/22/2008 03:47 PM 144,058 javax.wsdl_1.5.1.v200806030408.jar
08/22/2008 03:47 PM 38,515 jaxrpc.jar
08/22/2008 03:47 PM 801,465 js.jar
08/22/2008 03:47 PM 2,018,444 modelapi.jar
08/22/2008 03:47 PM 9,775 modelodaapi.jar
03/15/2007 06:20 PM 236,956 mysql-connector-java-3.0.14-production-bi
n.jar
08/22/2008 03:47 PM 35,778 odadesignapi.jar
08/22/2008 03:47 PM 53,759 org.apache.commons.codec_1.3.0.v20080530-
1600.jar
08/22/2008 03:47 PM 4,389 org.eclipse.birt.report.engine.dataextrac
tion_2.3.0.v20080611.jar
08/22/2008 03:47 PM 187,370 org.eclipse.emf.common_2.4.0.v20080609123
4.jar
08/22/2008 03:47 PM 216,638 org.eclipse.emf.ecore.xmi_2.4.0.v20080609
1234.jar
08/22/2008 03:47 PM 1,034,902 org.eclipse.emf.ecore_2.4.0.v200806091234
.jar
08/22/2008 03:47 PM 29,603 org.w3c.css.sac_1.3.0.v200805290154.jar
08/22/2008 03:47 PM 23,958 saaj.jar
08/22/2008 03:47 PM 55,255 scriptapi.jar
08/22/2008 03:47 PM 511,567 viewservlets.jar
29 File(s) 13,565,815 bytes
2 Dir(s) 171,805,577,216 bytes free

C:Tomcatapache-tomcat-5.5.26apache-tomcat-5.5.26webappsWebViewerExampleWEB
-INFlib>

WHERE IS THE CORRECT DRIVER CONNECTOR JARS LOCATED?
AM I for getting something.

I am using birt-runtime-2_3_0 ---> just copied the WebViewerExample
over to the webapps folder is their anything I need to do more!

The eclipse IDE is eclipse-reporting-ganymede-win32.

I am also wondering if their is away to deploy the birt stuff thru the eclipse enviorment?

Thanks for any help

JasonW

I am using the 
mysql-connector-java-5.0.4-bin.jar 
 
Instead of using the appcontext remove the the jar from the web-inf/lib and copy it to 
 
C:Tomcatapache-tomcat-5.5.26apache-tomcat-5.5.26webappsWebVie 
werExampleplatformpluginsorg.eclipse.birt.report.data.oda.jdbc_2.3.0.v20080610drivers 
 
If you download the WTP integration package 
<a class='bbc_url' href='http://www.eclipse.org/downloads/download.php?file=/birt/downloads/drops/R-R1-2_3_1-200809221151/birt-wtp-integration-sdk-2_3_1.zip'>Eclipse downloads - mirror selection</a> 
 
It has project types for deploying the webviewerexample. I am not certain the drivers get deployed though.