Skip to main content



      Home
Home » Archived » BIRT » Query being run twice
icon4.gif  Query being run twice [message #549635] Tue, 27 July 2010 08:28 Go to next message
Eclipse UserFriend
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 08:36] by Moderator

Re: Query being run twice [message #549688 is a reply to message #549635] Tue, 27 July 2010 10:45 Go to previous messageGo to next message
Eclipse UserFriend
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?
Re: Query being run twice [message #549696 is a reply to message #549688] Tue, 27 July 2010 10:59 Go to previous messageGo to next message
Eclipse UserFriend
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?
Re: Query being run twice [message #549841 is a reply to message #549635] Wed, 28 July 2010 04:20 Go to previous message
Eclipse UserFriend
Posted https://bugs.eclipse.org/bugs/show_bug.cgi?id=321095
Previous Topic:problems with installation of birt rcp report designer
Next Topic:Dynamic hyperlink not via drill down?
Goto Forum:
  


Current Time: Sun Jul 06 14:18:19 EDT 2025

Powered by FUDForum. Page generated in 0.24530 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top