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; } } }

BIRT Stops after Loading JDBC Driver

Veerendra

<p>Hi,</p>
<p> </p>
<p>We have been using BIRT and implemented the Viewer in Java.</p>
<p> </p>
<p>On executing the Data Set Query for 1000 Rows Birt finishes within 295 ms.</p>
<p> </p>
<p>But while for larger no of rows say 75000.. Birt stops responding. When checked with Log BIRT Log is stopped after </p>
<div>org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager findDriver</div>
<div>INFO: Loaded JDBC driver class in class path: com.mysql.jdbc.Driver</div>
<div> </div>
<div>where as Query Execution on Mysql is nearly 1 Secs.</div>
<div>Please help this has been critical issue for us.</div>

Find more posts tagged with

Comments

Veerendra

<p>My Runtime Version is org.eclipse.birt.runtime_4.4.1.v20140916-1320</p>
<p> </p>
<p>And Designer Version (using Eclipse) is 4.4.1.v201408290142 Build <4.4.1.v20140916-1320</p>
<p> </p>
<p> </p>
<p>BIRT Runtime has been implemented in Java and integrated into your web application deployed in Tomcat.</p>
<p> </p>
<p>Tomcat Memory is 6 GB.</p>
<p> </p>
<p>Please help..</p>

Veerendra

<p>I am initiating Birt Engine once and using the same for other reports.</p>
<p>Below is the code snippet:</p>
<p>static IReportEngine engine = null;</p>
<p> </p>
<div>if(engine != null){</div>
<div> return engine;</div>
<div> } else {</div>
<div> EngineConfig config = new EngineConfig();</div>
<div> config.setEngineHome( "\\WEB-INF" );</div>
<div> String folder = "/home/BIRT";</div>
<div> config.setLogConfig(folder+"/Logs", Level.FINE);</div>
<div> Platform.startup(config);</div>
<div> IReportEngineFactory factory = (IReportEngineFactory) Platform.createFactoryObject(IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY);</div>
<div> engine = factory.createReportEngine(config);</div>
<div> engine.changeLogLevel(Level.WARNING);</div>
<div> return engine;</div>
<div> }</div>
<div> </div>
<div>BIRT Report generation hangs at the line task.run() in iRunAndRenderTask Method;</div>

JFreeman

<p>If you run the same report in the BIRT designer, do you get the same performance issue?</p>

Veerendra

<p>No, There is no issue while running from the BIRT Designer.</p>
<p> </p>
<p>I have given a fix which is working but don't know if that was reason for no response.</p>
<p> </p>
<p>While generating for various Date Range, report was generated successfully all the time when the Query execution time was below 1 Sec. As soon as it crosses 1 Sec there was no response.</p>
<p> </p>
<p>In the Mysql configuration file the variable long_query_time was set to 1 sec. So on wild guess changed this value to 10 secs. Now the reports are working fine.</p>
<p> </p>
<p>But I need to know is there any connection between BIRT and MySQL Variable long_query_time.</p>
<p> </p>
<p>Please let us know.</p>
<p> </p>
<p>Thanks.</p>

Veerendra

<p>BIRT Designer was installed in My System.</p>
<p> </p>
<p>The same report with same amount of data was working fine in the Ubuntu Testing Server where this long_query_time was not set. So this made me to think. </p>
<p> </p>
<p>But dont know what is connection so kindly clarify.</p>
<p> </p>
<p>One more question will BIRT Report generation depends on Operating System (as mentioned earlier Report was working fine in Ubuntu but the issue was in Red Hat) and is there any sample configuration with respect to Tomcat Memory and Temporary Disk space for caching and processing the data.</p>
<p> </p>
<p>Thanks.</p>
<p> </p>

JFreeman

<p>The operating system should be transparent to the BIRT report generation as it is all Java based.</p>
<p>What could vary between system is the JVM, JDBC drivers, etc.</p>
<p> </p>
<p>Regarding the long_query_time, this will be dependent on the JDBC driver you are using and the database configuration. BIRT itself is not a direct factor in the communication.</p>