Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Query being run twice
icon4.gif  Query being run twice [message #549635] Tue, 27 July 2010 12:28 Go to next message
john mcteague is currently offline 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 #549688 is a reply to message #549635] Tue, 27 July 2010 14:45 Go to previous messageGo to next message
john mcteague is currently offline john mcteague
Messages: 15
Registered: July 2009
Junior Member
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 14:59 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 08:20 Go to previous message
john mcteague is currently offline john mcteague
Messages: 15
Registered: July 2009
Junior Member
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: Sat Oct 25 13:00:19 GMT 2014

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

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