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 YellowFriend
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 WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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

Michael

Developer Evangelist, Silanis
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 YellowFriend
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 WilliamsFriend
Messages: 1925
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

Developer Evangelist, Silanis
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 YellowFriend
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 WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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

Michael

Developer Evangelist, Silanis
Previous Topic:populate textbox when radio button selected
Next Topic:how to crab series value in report
Goto Forum:
  


Current Time: Wed Jul 29 22:21:27 GMT 2015

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

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