Open Script is calling java class multiple times

Hi, 
 
I have cretaed a BIRT template with scripted data source. 
 
PFB the open script.. 
count = 0; 
gsh = new Packages.com.mm.gip.dao.CoverPageParticipantDataDAO_scripteddatasource(); 
stock = gsh.getCoverPageDynamicText(); 
 
PFB the fetch script. 
if (count < stock.size()) 
{ 
row["FirstName"] = stock.get(count).getFirstName(); 
row["LastName"] = stock.get(count).getLastName(); 
row["CoverV2T1"] = stock.get(count).getCoverV2T1(); 
row["CoverV1T1"] = stock.get(count).getCoverV1T1(); 
row["CoverV1T2"] = stock.get(count).getCoverV1T2(); 
row["CoverV3T1"] = stock.get(count).getCoverV3T1(); 
row["CoverV4T1"] = stock.get(count).getCoverV4T1(); 
row["CoName"]=stock.get(count).getCoName(); 
row["CoverV3T2"]=stock.get(count).getCoverV3T2(); 
row["CoverV4T2"]=stock.get(count).getCoverV4T2(); 
row["CoverV4T3"]=stock.get(count).getCoverV4T3(); 
row["CoverV4T4"]=stock.get(count).getCoverV4T4(); 
row["CoNameCoverLetter"]=stock.get(count).getCoNameCoverLetter(); 
row["CoverV4T5"]=stock.get(count).getCoverV4T5(); 
row["CoverV4T6"]=stock.get(count).getCoverV4T6(); 
row["CoverV5T1"]=stock.get(count).getCoverV5T1(); 
row["CoverV5T2"]=stock.get(count).getCoverV5T2(); 
row["EPBenefitConsultantPhone"]=stock.get(count).getEpBenefitConsultantPhone(); 
row["CoverV5T3"]=stock.get(count).getCoverV5T3(); 
row["EPBenefitConsultantExtn"]=stock.get(count).getEpBenefitConsultantExtn(); 
row["CaseID"]=stock.get(count).getCaseID(); 
row["PartNum"]=stock.get(count).getPartNum(); 
row["CoverV5T4"]=stock.get(count).getCoverV5T4(); 
count++; 
return true; 
} 
return false; 
 
While checking the performnace tunning I came to know that my script is calling java class CoverPageParticipantDataDAO_scripteddatasource multiple times instaed of calling single time. 
 
PFA the java class. 
 
PFB the logs on console. 
 
16:00:04,958 INFO [STDOUT] Total time taken by Cover page scripted data source 292ms 
16:00:04,958 INFO [STDOUT] List size 1 
16:00:13,015 INFO [STDOUT] Total time taken by Cover page scripted data source 12ms 
16:00:13,015 INFO [STDOUT] List size 1 
16:00:13,032 INFO [STDOUT] Total time taken by Cover page scripted data source 12ms 
16:00:13,032 INFO [STDOUT] List size 1 
16:00:13,075 INFO [STDOUT] Total time taken by Cover page scripted data source 25ms 
16:00:13,075 INFO [STDOUT] List size 1 
16:00:13,097 INFO [STDOUT] Total time taken by Cover page scripted data source 18ms 
16:00:13,098 INFO [STDOUT] List size 1 
16:00:13,114 INFO [STDOUT] Total time taken by Cover page scripted data source 13ms 
16:00:13,114 INFO [STDOUT] List size 1 
16:00:13,153 INFO [STDOUT] Total time taken by Cover page scripted data source 33ms 
16:00:13,153 INFO [STDOUT] List size 1 
16:00:13,169 INFO [STDOUT] Total time taken by Cover page scripted data source 12ms 
16:00:13,169 INFO [STDOUT] List size 1 
16:00:13,208 INFO [STDOUT] Total time taken by Cover page scripted data source 33ms 
16:00:13,208 INFO [STDOUT] List size 1 
16:00:13,231 INFO [STDOUT] Total time taken by Cover page scripted data source 18ms 
16:00:13,231 INFO [STDOUT] List size 1 
16:00:13,330 INFO [STDOUT] Total time taken by Cover page scripted data source 93ms 
16:00:13,331 INFO [STDOUT] List size 1 
16:00:13,349 INFO [STDOUT] Total time taken by Cover page scripted data source 11ms 
16:00:13,349 INFO [STDOUT] List size 1 
16:00:13,390 INFO [STDOUT] Total time taken by Cover page scripted data source 37ms 
16:00:13,390 INFO [STDOUT] List size 1 
16:00:13,421 INFO [STDOUT] Total time taken by Cover page scripted data source 28ms 
16:00:13,422 INFO [STDOUT] List size 1 
16:00:13,441 INFO [STDOUT] Total time taken by Cover page scripted data source 15ms 
16:00:13,441 INFO [STDOUT] List size 1 
16:00:13,557 INFO [STDOUT] Total time taken by Cover page scripted data source 112ms 
16:00:13,557 INFO [STDOUT] List size 1 
16:00:13,591 INFO [STDOUT] Total time taken by Cover page scripted data source 30ms 
16:00:13,591 INFO [STDOUT] List size 1 
16:00:13,608 INFO [STDOUT] Total time taken by Cover page scripted data source 13ms 
16:00:13,608 INFO [STDOUT] List size 1 
 
Please suggest some way to do away this problem. 
Thanks in adavnce.

Find more posts tagged with

Comments

jakoby84

I discover the same problem when using scripted datasource. It seems that every report element (table, chart, ...) initializes the dataset all over again. Somewhere else I read that this is due to scripted datasources not being cached. It is quite odd because for my scripted datasource I do some preprocessing on the java side.

A solution would be to use a Java Singleton Class. This would help as the Java Bean would not be created over and over again. Nevertheless the dataset would still be filled again and again.

So me as well is hoping for an expert to come up with a better solution.

prince87

Thanks jakoby,

I am very new to java also.
I have java class attached in my previous post.

Can you just give me example how we can create singleton class with my existing java class or if you have any dummy java clas which you can shared than it would be of great help.

Thanks in advance!

Jenkinsj5

You may want to watch <a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/topic/28767-redundant-query/page__pid__113971__st__0&#entry113971'>Redundant query</a> it is currently discusses similar concerns apparently from a SQL DB call.

jakoby84

<blockquote class='ipsBlockquote' data-author="'prince87'" data-cid="113970" data-time="1360168847" data-date="06 February 2013 - 09:40 AM">
Can you just give me example how we can create singleton class with my existing java class or if you have any dummy java clas which you can shared than it would be of great help. </blockquote>
 
This is how I instantiate the BIRT engine for example as singleton. The 'static' declarations cause that an object is the same for all instances of that class. I copy-pasted this code from another BIRT post. Don't know if there is a more elegant way to implement a singleton. Although I can do some decent programming I'm not an expert... At least it works and the BIRT engine (in this case is only initialized once. 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
import javax.servlet.ServletContext;

import org.eclipse.birt.core.exception.BirtException;
import org.eclipse.birt.core.framework.Platform;
import org.eclipse.birt.report.engine.api.EngineConfig;
import org.eclipse.birt.report.engine.api.IReportEngine;
import org.eclipse.birt.report.engine.api.IReportEngineFactory;

public class BirtEngine {

private static IReportEngine birtEngine = null;

private BirtEngine() {

}

public static synchronized IReportEngine getBirtEngine(ServletContext sc) {
if (birtEngine == null) {

EngineConfig config = new EngineConfig( );
System.out.println(sc.getRealPath("/"));
config.setResourcePath(sc.getRealPath("/WEB-INF/reports") + "/library_elements");
try {
Platform.startup();
} catch (BirtException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
IReportEngineFactory factory = (IReportEngineFactory)Platform.createFactoryObject
(IReportEngineFactory.EXTENSION_REPORT_ENGINE_FACTORY);
birtEngine = factory.createReportEngine(config);
}
return birtEngine;

}
}</pre>
 
In your case you could do something like 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
public class CoverPageParticipantDataDAO_scripteddatasource {
private static CoverPageParticipantData participantModel = null;
public static synchronized ArrayList<CoverPageParticipantData> getCoverPageDynamicText() throws Exception
{
if (CoverPageParticipantData == null){
// fill it with data
} else {
return CoverPageParticipantData;
}
}
}
</pre>

prince87

Thanks jakoby,

I have cretaed singleton class and time is reduced to some extent , but still time is high.
Can you suggest me few ways to perform performnace tunning with BIRT?

I am using scripted data source.
BIRT version 4.2

Is their any other data source type which I can use which is more optimised than scripted data source.

Thanks in advance!

jakoby84

Actually I don't really know either. I am also facing the problem of reports not running as quickly as I would like them to run... Maybe mwilliams or one of the other BIRT Gurus

have an idea?

Just an idea without knowing if it helps: I saw that for a scripted data source one can use a "Java Event Handler" (Data Source -> Property Editor -> Event Handler). I mean instead of scripting inside the beforeOpen() and onFetch() methods. But as I said, I don't know if it helps.

Any advice from the gurus would be very much appreciated!