Query being run twice [message #549635] |
Tue, 27 July 2010 12:28 |
john mcteague Messages: 15 Registered: July 2009 |
Junior Member |
|
|
Using Birt 2.5.1, I have a simple datasource pointing to a sybase database with a single datasource doing the following as a simple test:
insert into RUNS (NAME, DATE_RUN) values ('TEST Report',getdate())
select name, id, uid from sysobjects
RUNS is a simple table that simply shows me when the query is executed.
Every time I run the report, either from the designer or via the birt runtime which is embedded in my application, the query is run twice.
For reports with much more complex queries and take a while to run, this double execution is not acceptable.
What causes the query to be executed twice and how do I stop it?
[Updated on: Tue, 27 July 2010 12:36] Report message to a moderator
|
|
|
|
Re: Query being run twice [message #549696 is a reply to message #549688] |
Tue, 27 July 2010 14:59 |
|
John,
I believe this is to create the column types in BIRT. Can you open a
bugzilla entry to look at this?
Jason
On 7/27/2010 10:45 AM, john mcteague wrote:
> I have resolved this by changing config.xml in oda-jdbc.jar to use
> policy 1 for the jConnect driver.
>
> Policy 2 executes the query with a maxrows of 1, gets the metadata then
> executes the query again with the desired number of rows.
> Does anyone know why jConnect was set to policy 2 in the first place?
|
|
|
|
Powered by
FUDForum. Page generated in 0.02528 seconds