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

Timeout setting for DB calls and Report Generation

Vishnupriya · 2014-11-11T08:52:40+00:00

hi, I use birt report engine 4.3.2 to create my reports large number of reports.. Would like to know, how the following can be achieved. 1. Query Timeout : If a query is taking more than designated time, I want to timeout the query and redirect user to error page. Database type is…

Vishnupriya

hi,
I use birt report engine 4.3.2 to create my reports large number of reports.. Would like to know, how the following can be achieved.

1. Query Timeout: If a query is taking more than designated time, I want to timeout the query and redirect user to error page. 
Database type is oracle and I use JNDI with connection pool. In Dataset properties, under Advanced tab, I have set value for'&Query Time Out'. Still the query is not timingout
 
2. Report Timeout: If the Report generation is taking more than 5 minutes, i want to quit generation and redirect user to error page. Does BIRT Report Engine provide such a setting ? I don't use BIRT Viewer. I have my own web application and a java application that call BIRT API to generate reports..
 
Thanks, 
Vishnupriya

Find more posts tagged with

Comments

mwilliams

1. This should work. What are you setting the query timeout to? 2. There is a cancel() method on an engine task. I've not tried using it before, but you could try it. There isn't a timeout setting, so you'd have to run your own timer.