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 07: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
Re: SQL Query changes take long [message #629777 is a reply to message #629409] Wed, 29 September 2010 14: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
Re: SQL Query changes take long [message #685466 is a reply to message #629777] Fri, 17 June 2011 14: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.
Re: SQL Query changes take long [message #685604 is a reply to message #685466] Fri, 17 June 2011 20: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.
Previous Topic:Drill-Through
Next Topic:Create pie chart programatically?
Goto Forum:
  


Current Time: Sat Oct 25 22:23:59 GMT 2014

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

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