How to configure the database to run this java program

<div>Hi Everyone, </div><div> </div><div>I was trying to run the below mentioned program, but i was not aware on how to configure the database used in this program and the drivers </div><div>could you please help me in doing this .</div><div> </div><div>I was trying this program in eclipse, but no impact </div><div>firstly i need to know how i need to configure the database or how i should connect to the database</div><div> </div><div>Please hellp me out.</div><div> </div><div>import java.io.IOException;</div><div>import java.util.ArrayList; </div><div> </div><div>import org.eclipse.birt.core.framework.Platform;</div><div>import org.eclipse.birt.report.model.api.CellHandle;</div><div>import org.eclipse.birt.report.model.api.DataItemHandle;</div><div>import org.eclipse.birt.report.model.api.DesignConfig; </div><div>import org.eclipse.birt.report.model.api.ElementFactory;</div><div>import org.eclipse.birt.report.model.api.IDesignEngine;</div><div>import org.eclipse.birt.report.model.api.IDesignEngineFactory;</div><div>import org.eclipse.birt.report.model.api.LabelHandle;</div><div>import org.eclipse.birt.report.model.api.OdaDataSetHandle;</div><div>import org.eclipse.birt.report.model.api.OdaDataSourceHandle;</div><div>import org.eclipse.birt.report.model.api.PropertyHandle;</div><div>import org.eclipse.birt.report.model.api.ReportDesignHandle;</div><div>import org.eclipse.birt.report.model.api.RowHandle;</div><div>import org.eclipse.birt.report.model.api.SessionHandle;</div><div>import org.eclipse.birt.report.model.api.SlotHandle;</div><div>import org.eclipse.birt.report.model.api.StructureFactory;</div><div>import org.eclipse.birt.report.model.api.TextItemHandle;</div><div>import org.eclipse.birt.report.model.api.TableHandle;</div><div>import org.eclipse.birt.report.model.api.ListHandle;</div><div>import org.eclipse.birt.report.model.api.SharedStyleHandle;</div><div>import org.eclipse.birt.report.model.api.activity.SemanticException;</div><div>import org.eclipse.birt.report.model.api.elements.structures.ComputedColumn;</div><div>import org.eclipse.birt.report.model.api.StyleHandle;</div><div>import org.eclipse.birt.report.model.api.elements.structures.HighlightRule;</div><div> </div><div>import com.ibm.icu.util.ULocale;</div><div> </div><div>import org.eclipse.birt.report.model.api.elements.DesignChoiceConstants;</div><div> </div><div>/**</div><div> * Use the Design Engine API (model api) to design a report instead of the </div><div> * BIRT designer. This class will generate a similar report as </div><div> * derby_sample.rptdesign that was created using the Eclipse BIRT designer.</div><div> */</div><div>public class DerbySampleDE</div><div>{</div><div>ReportDesignHandle designHandle = null;</div><div>ElementFactory designFactory = null;</div><div>StructureFactory structFactory = null;<span> </span></div><div> </div><div>public static SessionHandle setup()</div><div>{</div><div> </div><div>//Configure the Engine and start the Platform</div><div>DesignConfig config = new DesignConfig( );</div><div>config.setProperty("BIRT_HOME", System.getProperty("BIRT_HOME"));</div><div>IDesignEngine engine = null;</div><div>try{</div><div>Platform.startup( config );</div><div>IDesignEngineFactory factory = (IDesignEngineFactory) Platform</div><div>.createFactoryObject( IDesignEngineFactory.EXTENSION_DESIGN_ENGINE_FACTORY );</div><div>engine = factory.createDesignEngine( config );</div><div> </div><div>}catch( Exception ex){</div><div>ex.printStackTrace();</div><div>}<span> </span></div><div>SessionHandle session = engine.newSessionHandle( ULocale.ENGLISH ) ;</div><div>return session;</div><div>}</div><div> </div><div>public static ReportDesignHandle createReport(SessionHandle session)</div><div>{</div><div>// create a design or a template</div><div>ReportDesignHandle reportDesignHandle = session.createDesign();</div><div> </div><div>return reportDesignHandle;</div><div>}</div><div> </div><div> </div><div> </div><div>public static void main( String[] args )</div><div>{</div><div>try</div><div>{</div><div>String qry = "select SAMP.DEPARTMENT.DEPTNAME,SAMP.EMPLOYEE.FIRSTNME,SAMP.EMPLOYEE.LASTNAME,SAMP.EMPLOYEE.JOB,CHAR(SAMP.EMPLOYEE.HIREDATE) as Hiredate,SAMP.EMPLOYEE.SALARY,SAMP.EMPLOYEE.BONUS,SAMP.EMPLOYEE.COMM"+</div><div>" from SAMP.EMPLOYEE, SAMP.DEPARTMENT where SAMP.DEPARTMENT.DEPTNO = SAMP.EMPLOYEE.WORKDEPT order by SAMP.DEPARTMENT.DEPTNAME";</div><div>String dataSourceName = "Sample Derby";</div><div>String dataSetName ="Sample Derby Data Set";</div><div> </div><div>SessionHandle session = setup();</div><div>ReportDesignHandle reportDesignHandle = createReport(session);</div><div> </div><div>addDataSource(reportDesignHandle,dataSourceName,"org.apache.derby.jdbc.EmbeddedDriver","jdbc:derby:C:/birt/demo/sample","APP","PWD");</div><div>buildDataSet(reportDesignHandle,dataSetName,dataSourceName,qry);</div><div> </div><div>ElementFactory elementFactory = reportDesignHandle.getElementFactory();</div><div> </div><div>// Create Styles.</div><div>StyleHandle labelStyle = elementFactory.newStyle( "headerLabel" );</div><div>labelStyle.setProperty( StyleHandle.FONT_WEIGHT_PROP,</div><div>DesignChoiceConstants.FONT_WEIGHT_BOLD );</div><div>labelStyle.setProperty( StyleHandle.FONT_FAMILY_PROP, "Andalus" );</div><div>labelStyle.setProperty( StyleHandle.COLOR_PROP, "red" );</div><div>labelStyle.setProperty( StyleHandle.BACKGROUND_COLOR_PROP,"aqua");</div><div>labelStyle.setProperty( StyleHandle.FONT_SIZE_PROP,"larger" );</div><div>labelStyle.setProperty( StyleHandle.COLOR_PROP, "red" );//$NON-NLS-1$</div><div>reportDesignHandle.getStyles( ).add( labelStyle );</div><div> </div><div> </div><div>StyleHandle detailStyle = elementFactory.newStyle( "detailStyle" );</div><div>detailStyle.setProperty( StyleHandle.FONT_WEIGHT_PROP,</div><div>DesignChoiceConstants.FONT_WEIGHT_BOLD );</div><div>detailStyle.setProperty( StyleHandle.BACKGROUND_COLOR_PROP,"#C0C0C0");</div><div>detailStyle.setProperty( StyleHandle.TEXT_ALIGN_PROP,"center");</div><div>PropertyHandle highlightRules = detailStyle.getPropertyHandle("highlightRules");</div><div> </div><div> </div><div>HighlightRule rules = StructureFactory.createHighlightRule();</div><div>rules.setOperator("eq");</div><div>rules.setProperty("backgroundColor","#80FFFF");</div><div>rules.setTestExpression("Total.runningCount() % 2");</div><div>rules.setValue1("0");</div><div>highlightRules.addItem(rules);</div><div>reportDesignHandle.getStyles( ).add( detailStyle );</div><div>StyleHandle dateStyle = elementFactory.newStyle( "dateStyle" );</div><div>dateStyle.setDateTimeFormat("DD_MM_YYYY");</div><div>dateStyle.setDateTimeFormatCategory("Medium Date");</div><div>//dateStyle.setD</div><div>reportDesignHandle.getStyles( ).add( dateStyle );</div><div> </div><div> </div><div>TextItemHandle text = elementFactory.newTextItem("text");</div><div>text.setContent("Employee Report");</div><div>reportDesignHandle.getComponents().add(text);</div><div> </div><div>// create a new table in the report with 5 columns</div><div>TableHandle table = elementFactory.newTableItem( "table", 5 );</div><div>table.setWidth( "100%" );</div><div> </div><div>// associate the dataset for this table</div><div>table.setDataSet( reportDesignHandle.findDataSet(dataSetName ) );</div><div> </div><div>// columns that are retrieved as part of the query in dataset</div><div>String[] cols ={</div><div>"DEPTNAME",</div><div>"FIRSTNME",</div><div>"LASTNAME",</div><div>"JOB",</div><div>"HIREDATE",</div><div>"SALARY",</div><div>"BONUS",</div><div>"COMM"</div><div>};</div><div> </div><div>// columns that are used in the report</div><div>String[][] reportCols ={</div><div>{"DEPTNAME","Dept Name"},</div><div>{"LASTNAME","Last Name"},</div><div>{"JOB","Job"},</div><div>{"HIREDATE","Hire Date"},</div><div>{"Total Income","Total Income"}</div><div>};</div><div> </div><div>// Set Column Bindings</div><div>PropertyHandle computedSet = table.getColumnBindings( ); </div><div>ComputedColumn cs1 = null;</div><div> </div><div>// DEPTNAME expression.</div><div>cs1 = StructureFactory.createComputedColumn();</div><div>cs1.setName(reportCols[0][0]);</div><div>cs1.setExpression("var newOutput = dataSetRow["DEPTNAME"].substr(0,1);"+</div><div>"var input = dataSetRow["DEPTNAME"].substr(1).toLowerCase();"+</div><div>"var j;"+</div><div>"for(i = 0;i<=input.length; i++) {"+</div><div>"if(input.charAt(i)==" ") {"+</div><div>"newOutput = newOutput + input.charAt(i) + input.charAt(i+1).toUpperCase();"+</div><div>"j = i + 1;"+</div><div>"}else {if(i!=j) {newOutput = newOutput + input.charAt(i);}}}newOutput;");</div><div>computedSet.addItem(cs1);</div><div> </div><div>for( int i=1; i < cols.length; i++){</div><div>cs1 = StructureFactory.createComputedColumn();</div><div>cs1.setName(cols);</div><div>cs1.setExpression("dataSetRow["" + cols[i] + ""]");</div><div>computedSet.addItem(cs1);</div><div>}</div><div> </div><div>// Computed Column</div><div>cs1 = StructureFactory.createComputedColumn();</div><div>cs1.setName("Total Income");</div><div>cs1.setExpression("row["SALARY"]+row["BONUS"]+row["COMM"]");</div><div>computedSet.addItem(cs1);</div><div> </div><div>// get the table header</div><div>RowHandle tableheader = (RowHandle) table.getHeader( ).get( 0 );</div><div> </div><div>// associate the columns in the header row.</div><div>for( int i=0; i < reportCols.length; i++){</div><div>LabelHandle label1 = elementFactory.newLabel( reportCols[1]);</div><div>label1.setStyleName("headerLabel");</div><div>label1.setText(reportCols[1]);</div><div>CellHandle cell = (CellHandle) tableheader.getCells( ).get( i );</div><div>cell.getContent( ).add( label1 );</div><div>}</div><div> </div><div>// HighlightRules</div><div>HighlightRule incomeRule = StructureFactory.createHighlightRule();</div><div>incomeRule.setOperator("le");</div><div>incomeRule.setProperty("backgroundColor","#FF0000");</div><div>incomeRule.setProperty("fontStyle","italic");</div><div> </div><div>incomeRule.setTestExpression("row["Total Income"]");</div><div>incomeRule.setValue1("25000");</div><div> </div><div>// table detail</div><div>RowHandle tabledetail = (RowHandle) table.getDetail( ).get( 0 );</div><div>for( int i=0; i < reportCols.length; i++){</div><div>CellHandle cell = (CellHandle) tabledetail.getCells( ).get( i );</div><div>DataItemHandle data = elementFactory.newDataItem( "data_"+reportCols[0] );</div><div>data.setResultSetColumn(reportCols[0]);</div><div>if(reportCols[0].equalsIgnoreCase("LASTNAME") ||</div><div>reportCols[0].equalsIgnoreCase("Total Income")<span> </span>)</div><div>{</div><div>cell.getPropertyHandle("highlightRules").addItem(incomeRule);</div><div> </div><div>}</div><div>if(reportCols[0].equalsIgnoreCase("HIREDATE"))</div><div>{</div><div>data.setStyleName("dateStyle");</div><div>cell.setStyleName("dateStyle");</div><div>}</div><div> </div><div>cell.getContent( ).add( data );</div><div>}</div><div> </div><div>tabledetail.setStyleName("detailStyle");</div><div> </div><div> </div><div>// format the date element , ie the fourth column.</div><div> </div><div>// Create a label</div><div>LabelHandle label = reportDesignHandle.getElementFactory().newLabel(null);</div><div> </div><div>// Set the properties for the heading</div><div>label.setStringProperty("fontSize", "24pt");</div><div>label.setStringProperty("fontWeight", "bold");</div><div>label.setStringProperty("marginTop", "2pt");</div><div>label.setStringProperty("marginBottom", "5pt");</div><div>label.setStringProperty("textAlign", "center");</div><div>label.setStringProperty("color","blue");</div><div>// The text property</div><div>label.setText("Employee Report 2");</div><div> </div><div>// get the body of the report</div><div>SlotHandle body = reportDesignHandle.getBody();</div><div> </div><div>// add the report caption label to the body of the report</div><div>body.add(label);</div><div> </div><div>// add the table </div><div>reportDesignHandle.getBody( ).add( table );</div><div>reportDesignHandle.saveAs( "E:BITS WSPCEBIRT RESULTSderbysamplede.rptdesign" ); //$NON-NLS-1$</div><div>reportDesignHandle.close( );</div><div> </div><div>}</div><div>catch ( IOException e )</div><div>{</div><div>e.printStackTrace();</div><div>}</div><div>catch ( SemanticException e )</div><div>{</div><div>e.printStackTrace();</div><div>}</div><div>}</div><div> </div><div>/**</div><div>* Build data source. </div><div>* @throws SemanticException</div><div>*/</div><div>public static void addDataSource(ReportDesignHandle hdl,String dsName,String driver,String url,String user, String pwd) </div><div>throws SemanticException</div><div>{</div><div>OdaDataSourceHandle dsHdl = (OdaDataSourceHandle)hdl.findDataSource(dsName);</div><div>if (dsHdl == null )</div><div>{</div><div>dsHdl = hdl.getElementFactory().newOdaDataSource(</div><div>dsName, "org.eclipse.birt.report.data.oda.jdbc" );</div><div>// add the newly created data source</div><div>hdl.getDataSources().add(dsHdl);</div><div>}</div><div> </div><div>// update the properties of the datasource</div><div>dsHdl.setProperty( "odaDriverClass",driver);</div><div>dsHdl.setProperty( "odaURL", url);</div><div>dsHdl.setProperty( "odaUser", user);</div><div>dsHdl.setProperty( "odaPassword", pwd );</div><div> </div><div>}</div><div> </div><div>void print(String msg)</div><div>{</div><div>System.out.println(msg);</div><div>}</div><div> </div><div>/**</div><div>* Build the query ( data set to use in the report).</div><div>*/</div><div>static void buildDataSet(ReportDesignHandle hdl,String dataSetName,String dataSourceName,String qry) </div><div>throws SemanticException</div><div>{</div><div>OdaDataSetHandle dataSetHandle = hdl.getElementFactory().newOdaDataSet( dataSetName,"org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" );</div><div>dataSetHandle.setDataSource( dataSourceName );</div><div>dataSetHandle.setQueryText( qry );</div><div> </div><div>PropertyHandle computedSet = dataSetHandle.getPropertyHandle( OdaDataSetHandle.COMPUTED_COLUMNS_PROP );</div><div>// Structure of the computed Column.</div><div>ComputedColumn computedCol = StructureFactory.createComputedColumn();//"ComputedColumns");</div><div>computedCol.setName("Total Income");</div><div>computedCol.setExpression("row["SALARY"]+row["BONUS"]+row["COMM"]");</div><div>computedCol.setDataType("decimal");</div><div>computedSet.addItem( computedCol );</div><div> </div><div>hdl.getDataSets( ).add( dataSetHandle );</div><div>}</div><div> </div><div>}</div><div> </div>

Find more posts tagged with

Comments

kclark

<p>Does it run with no result or are you getting a stack trace?</p>

Mknhere

<p>Hi Clark, </p><p> </p><p>I can able to execute the program without any error. </p><p>However, when i tried to view the created repotdesign in report viewer i get the following error. </p><p> </p> <div style="font-weight:bold;font-size:24pt;color:#0000FF;text-align:center;">Employee Report 2</div> <div style="font-family:Andalus;font-size:larger;color:#FF0000;background-color:#00FFFF;">Dept Name</div> <div style="font-family:Andalus;font-size:larger;color:#FF0000;background-color:#00FFFF;">Last Name</div> <div style="font-family:Andalus;font-size:larger;color:#FF0000;background-color:#00FFFF;">Job</div> <div style="font-family:Andalus;font-size:larger;color:#FF0000;background-color:#00FFFF;">Hire Date</div> <div style="font-family:Andalus;font-size:larger;color:#FF0000;background-color:#00FFFF;">Total Income</div> <div style="font-family:serif;font-size:13px;color:#FF0000;"><div>The following items have errors:</div>
<div><div>Table table:</div><div><span>+ </span>Can not load the report query: 11. Errors occurred when generating the report document for the report element with ID 11. (Element ID:11)</div><div> </div><div> </div><div> </div><div> </div><div>[color=#000000;]Could you please let me know how i can fix this error ? [/color]</div><div>[color=#000000;]How to set tup the database with my java program to make this query running. [/color]</div><div> </div><div> </div><div>[color=#000000;]Thanks,[/color]</div><div>[color=#000000;]Muthu [/color]</div></div></div>

kclark

<p>Running your code this is what I had to pass to addDataSource assuming you're trying to build this from the ClassicModels db.</p><pre class="_prettyXprint _lang-">addDataSource(reportDesignHandle,dataSourceName,"org.eclipse.birt.report.data.oda.sampledb.Driver","jdbc:classicmodels:sampledb","ClassicModels","");</pre><p>Can you explain the query? Are you trying to build this from the example db?</p>

Mknhere

<p>Hi Kclark, </p><p> </p><p>I did not know much about this query. </p><p>yes i am trying to generate the birt repot by using any example db, i.e , ClassicModels</p><p>I just wanted to inform you that i got this program from eclipse forum and i am trying to execute this program very badly. </p><p>Please help me out </p><p>My requirement is very simple, i want to generate the report based on the database </p><p>can you please provide me any java program reference to do this or please help me in solving this query error in the above mentioned derby java program. </p>

kclark

<p>Take a look at the example I posted <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/31170-migration-from-jasper-to-birt/'>here</a>. It should be pretty straight forward to copy over to your application. Let me know if you have any questions.</p>

Mknhere

<p>Hi Clark , </p><p> </p><p>Thanks for this java program,</p><p>I can able to generate the report without any java exception</p><p>But when i view the generated report design in tomcact-birt viewer i get the following exception</p><p> </p><p>I am using birt runtime 3.7.1 and also i am not sure of what jars to be included in my tomcat-lib please let me know as soon as possible.</p><p> </p><p> </p> <div style="background-color:#808080;"> <div style="background-color:rgb(78,109,164);"> <div> xception </div> <div> Close <div style="background-color:#808080;"> </div> </div> </div> <div style="background-color:rgb(236,233,216);"> <div style="margin-left:10px;"> <div> <img src='http://localhost:8080/birt-viewer/webcontent/birt/images/Error.gif' alt='Posted Image' class='bbc_img' /> <div style="font-size:9pt;"><strong class='bbc'><span>org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.</span></strong></div> <div style="font-size:8pt;color:#808080;font-weight:bold;">Hide Exception Stack Trace</div> <div> Stack Trace: <div style="font-size:8pt;"> <div>[font="monospace;"]org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.<br />
at org.eclipse.birt.report.engine.api.impl.EngineTask.handleFatalExceptions(EngineTask.java:2248)<br />
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:270)<br />
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:86)<br />
at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1317)<br />
at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:158)<br />
at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)<br />
at org.eclipse.birt.report.service.actionhandler.BirtGetPageActionHandler.__checkDocumentExists(BirtGetPageActionHandler.java:58)<br />
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.prepareParameters(AbstractGetPageActionHandler.java:119)<br />
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:104)<br />
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)<br />
at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)<br />
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)<br />
at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPage(BirtDocumentProcessor.java:87)<br />
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br />
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br />
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br />
at java.lang.reflect.Method.invoke(Method.java:597)<br />
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)<br />
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)<br />
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br />
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br />
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br />
at java.lang.reflect.Method.invoke(Method.java:597)<br />
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)<br />
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)<br />
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)<br />
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)<br />
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)<br />
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)<br />
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)<br />
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)<br />
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)<br />
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)<br />
at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)<br />
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)<br />
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)<br />
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)<br />
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<br />
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br />
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)<br />
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br />
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br />
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<br />
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<br />
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<br />
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)<br />
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<br />
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)<br />
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)<br />
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)<br />
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)<br />
at java.lang.Thread.run(Thread.java:662)<br />
Caused by: org.mozilla.javascript.EvaluatorException: illegal character (#1)<br />
at org.mozilla.javascript.DefaultErrorReporter.runtimeError(DefaultErrorReporter.java:109)<br />
at org.mozilla.javascript.DefaultErrorReporter.error(DefaultErrorReporter.java:96)<br />
at org.mozilla.javascript.Parser.addError(Parser.java:146)<br />
at org.mozilla.javascript.TokenStream.getToken(TokenStream.java:825)<br />
at org.mozilla.javascript.Parser.peekToken(Parser.java:172)<br />
at org.mozilla.javascript.Parser.statementHelper(Parser.java:735)<br />
at org.mozilla.javascript.Parser.statementHelper(Parser.java:1232)<br />
at org.mozilla.javascript.Parser.statement(Parser.java:707)<br />
at org.mozilla.javascript.Parser.parse(Parser.java:401)<br />
at org.mozilla.javascript.Parser.parse(Parser.java:338)<br />
at org.mozilla.javascript.Context.compileImpl(Context.java:2368)<br />
at org.mozilla.javascript.Context.compileString(Context.java:1359)<br />
at org.mozilla.javascript.Context.compileString(Context.java:1348)<br />
at org.eclipse.birt.report.engine.javascript.JavascriptEngine$3.run(JavascriptEngine.java:240)<br />
at org.eclipse.birt.report.engine.javascript.JavascriptEngine$3.run(JavascriptEngine.java:1)<br />
at java.security.AccessController.doPrivileged(Native Method)<br />
at org.eclipse.birt.report.engine.javascript.JavascriptEngine.compile(JavascriptEngine.java:236)<br />
at org.eclipse.birt.report.engine.javascript.JavascriptEngine.compile(JavascriptEngine.java:1)<br />
at org.eclipse.birt.core.script.ScriptContext.compile(ScriptContext.java:148)<br />
at org.eclipse.birt.report.engine.executor.ExecutionContext.compile(ExecutionContext.java:771)<br />
at org.eclipse.birt.report.engine.executor.ExecutionContext.evaluate(ExecutionContext.java:705)<br />
at org.eclipse.birt.report.engine.executor.ReportItemExecutor.evaluateString(ReportItemExecutor.java:297)<br />
at org.eclipse.birt.report.engine.executor.ImageItemExecutor.handleURIImage(ImageItemExecutor.java:261)<br />
at org.eclipse.birt.report.engine.executor.ImageItemExecutor.handleImage(ImageItemExecutor.java:214)<br />
at org.eclipse.birt.report.engine.executor.ImageItemExecutor.execute(ImageItemExecutor.java:111)<br />
at org.eclipse.birt.report.engine.executor.ReportExecutorUtil.executeAll(ReportExecutorUtil.java:87)<br />
at org.eclipse.birt.report.engine.executor.ReportExecutorUtil.executeAll(ReportExecutorUtil.java:92)<br />
at org.eclipse.birt.report.engine.executor.ReportExecutor.createPageExecutor(ReportExecutor.java:229)<br />
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.createPageExecutor(WrappedReportExecutor.java:49)<br />
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.createPageExecutor(SuppressDuplciateReportExecutor.java:61)<br />
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.createPageExecutor(WrappedReportExecutor.java:49)<br />
at org.eclipse.birt.report.engine.executor.ReportExecutorUtil.executeMasterPage(ReportExecutorUtil.java:63)<br />
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.start(HTMLPageLM.java:147)<br />
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:91)<br />
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)<br />
at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:249)<br />
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:262)<br />
... 50 more[/font]</div> </div> </div> </div> <div style="text-align:center;"> <div> <div style="background-color:#808080;"> </div> <div style="background-color:rgb(254,254,254);"> </div> </div> <div style="text-align:right;"> <div style="margin:6px 0px 7px auto;"> <div> <div style="background-color:rgb(156,156,156);"> </div> <div style="background-color:rgb(156,156,156);"> </div> </div> <div> </div> <div> <div style="background-color:rgb(156,156,156);"> </div> <div style="background-color:rgb(156,156,156);"> </div> </div> </div> </div> </div> </div> </div> </div> <div> <strong class='bbc'>Showing page <span>1</span> of </strong> <strong class='bbc'>Go to page:</strong> </div> <div> </div>

Mknhere

<p>Hi Clark, </p><p> </p><p>I fixed the above mentioned issue. </p><p>however i was able to see only the image , when i view the repot in the web report viewer. </p><p>I did not see any data related to " Select * from customers " </p><p> </p><p>Please let me know how to set up the drivers, database/datasource in my windows/eclipse to view these data</p><p> </p><p>This generated report has 4 pages, but in all the 4 pages i can see only the image not the data </p><p>please help me out. </p>

kclark

<p>Can you post the rptdesign that was generated and your code in a zip file?</p>