Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Can't load the Query(can preview ,but got error by deployed in tomcat6.0 )
Can't load the Query [message #1066120] Mon, 01 July 2013 05:40 Go to next message
Beryl Yellow is currently offline Beryl Yellow
Messages: 23
Registered: July 2013
Junior Member

The following items have errors:


Table (id = 512):
+ Can not load the report query: 512. Errors occurred when generating the report document for the report element with ID 512. (Element ID:512)
Re: Can't load the Query [message #1066897 is a reply to message #1066120] Fri, 05 July 2013 05:53 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1595
Registered: July 2009
Senior Member

Can you expand the error by clicking on the '+' and post the error stack?

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Can't load the Query [message #1066940 is a reply to message #1066897] Fri, 05 July 2013 08:22 Go to previous messageGo to next message
Beryl Yellow is currently offline Beryl Yellow
Messages: 23
Registered: July 2013
Junior Member
I just remove the update sentence from the Query, then it runs ok...
Then it means Birt can't execute update sentence before select ?
Re: Can't load the Query [message #1067114 is a reply to message #1066940] Fri, 05 July 2013 23:44 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1595
Registered: July 2009
Senior Member

Correct. Not through the jdbc dataSet. However, BIRT does have script methods where you can execute javascript or Java where you could create a connection to your database and do the update sentence before your select statement is executed.

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: Can't load the Query [message #1067691 is a reply to message #1067114] Wed, 10 July 2013 07:08 Go to previous messageGo to next message
Beryl Yellow is currently offline Beryl Yellow
Messages: 23
Registered: July 2013
Junior Member
Michael Williams wrote on Fri, 05 July 2013 19:44
Correct. Not through the jdbc dataSet. However, BIRT does have script methods where you can execute javascript or Java where you could create a connection to your database and do the update sentence before your select statement is executed.



Laughing

thanks very much! I just use Java to resolve this issue.
Re: Can't load the Query [message #1071243 is a reply to message #1067691] Fri, 19 July 2013 16:24 Go to previous message
Michael Williams is currently offline Michael Williams
Messages: 1595
Registered: July 2009
Senior Member

Great! Glad to help! Let us know whenever you have questions! Smile

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Previous Topic:populate textbox when radio button selected
Next Topic:how to crab series value in report
Goto Forum:
  


Current Time: Thu Sep 18 20:02:18 GMT 2014

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

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