Skip to main content


Eclipse Community Forums

      Home
Home » Archived » 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
Eclipse UserFriend

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
Eclipse UserFriend
Can you expand the error by clicking on the '+' and post the error stack?
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
Eclipse UserFriend
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
Eclipse UserFriend
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.
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
Eclipse UserFriend
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
Eclipse UserFriend
Great! Glad to help! Let us know whenever you have questions! Smile
Previous Topic:populate textbox when radio button selected
Next Topic:how to crab series value in report
Goto Forum:
  


Current Time: Thu Mar 20 06:51:41 EDT 2025

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly