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 01:40 Go to next message
Beryl Yellow is currently offline Beryl Yellow
Messages: 23
Registered: June 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 01:53 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1424
Registered: July 2009
Senior Member

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

Michael
Actuate – The BIRT Company™

BIRT Developer Center
Check out the new, free BIRT Viewer Toolkit
Re: Can't load the Query [message #1066940 is a reply to message #1066897] Fri, 05 July 2013 04:22 Go to previous messageGo to next message
Beryl Yellow is currently offline Beryl Yellow
Messages: 23
Registered: June 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 19:44 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1424
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
Actuate – The BIRT Company™

BIRT Developer Center
Check out the new, free BIRT Viewer Toolkit
Re: Can't load the Query [message #1067691 is a reply to message #1067114] Wed, 10 July 2013 03:08 Go to previous messageGo to next message
Beryl Yellow is currently offline Beryl Yellow
Messages: 23
Registered: June 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 12:24 Go to previous message
Michael Williams is currently offline Michael Williams
Messages: 1424
Registered: July 2009
Senior Member

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

Michael
Actuate – The BIRT Company™

BIRT Developer Center
Check out the new, free BIRT Viewer Toolkit
Previous Topic:populate textbox when radio button selected
Next Topic:how to crab series value in report
Goto Forum:
  


Current Time: Wed Apr 16 19:01:15 EDT 2014

Powered by FUDForum. Page generated in 0.02636 seconds