Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » SQL Query changes take long
SQL Query changes take long [message #629409] Tue, 28 September 2010 03:48 Go to next message
No real name is currently offline No real name
Messages: 11
Registered: August 2010
Junior Member
Hi!

Everytime I change the SQL-query of a DataSet and then go to another tab (for example "Preview Results" or "Propertys") or create a new DataSet, BIRT freezes for several minutes.
It doesn't matter if the query causes an error or not, it always freezes.

The querys themselfes are not very complex. Just nvl, decode, joins, order by.

What does BIRT do after a query is changed? Can I somehow disable it?

Database: Oracle 10g 64bit
Driver Class: oracle.jdbc.OracleDriver (v11.2)
BIRT Version: 2.6.0 (also with 2.5.2)

Peter

Report message to a moderator

Re: SQL Query changes take long [message #629777 is a reply to message #629409] Wed, 29 September 2010 10:22 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member
Peter,

I have not seen this problem. When you modify the query data engine
re-executes the query and updates the metadata in the design. If you do
a simple select * from table do you get the issue?

Jason

On 9/28/2010 3:48 AM, peter@pilgerstorfer.at wrote:
> Hi!
>
> Everytime I change the SQL-query of a DataSet and then go to another tab
> (for example "Preview Results" or "Propertys") or create a new DataSet,
> BIRT freezes for several minutes. It doesn't matter if the query causes
> an error or not, it always freezes.
>
> The querys themselfes are not very complex. Just nvl, decode, joins,
> order by.
>
> What does BIRT do after a query is changed? Can I somehow disable it?
>
> Database: Oracle 10g 64bit
> Driver Class: oracle.jdbc.OracleDriver (v11.2)
> BIRT Version: 2.6.0 (also with 2.5.2)
>
> Peter

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: SQL Query changes take long [message #685466 is a reply to message #629777] Fri, 17 June 2011 10:58 Go to previous messageGo to next message
Tomas is currently offline Tomas
Messages: 1
Registered: June 2011
Junior Member
This behaviour is really annoying, I think the design assumption that you can execute the query at "any time" is flawed (executing some of my queries takes several (dozen) minutes).

Is there a way to avoid this? I tried breaking the connection to the DB server, but then BIRT Report Designer tends to freeze/crash.

Report message to a moderator

Re: SQL Query changes take long [message #685604 is a reply to message #685466] Fri, 17 June 2011 16:53 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member
Tomas,

Can you open a bug for this?

Jason

On 6/17/2011 10:58 AM, Tomas wrote:
> This behaviour is really annoying, I think the design assumption that
> you can execute the query at "any time" is flawed (executing some of my
> queries takes several (dozen) minutes).
> Is there a way to avoid this? I tried breaking the connection to the DB
> server, but then BIRT Report Designer tends to freeze/crash.

Jason Weathersby

BIRT Exchange

Report message to a moderator

Previous Topic:Drill-Through
Next Topic:Create pie chart programatically?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 24 13:34:25 EDT 2013

Powered by FUDForum. Page generated in 0.10492 seconds