|
(no subject) [message #690468 is a reply to message #690333] |
Wed, 29 June 2011 14:53 |
|
This is an issue in the designer.
https://bugs.eclipse.org/bugs/show_bug.cgi?id=280851
You may want to look at the following post as an alternative:
http://birtworld.blogspot.com/2010/01/quick-and-dirty-logging.html
Jason
On 6/29/2011 7:50 AM, parasu wrote:
> Hi All,
>
> I am creating BIRT reports using the BIRT report designer in Eclipse.
>
> I want to know where can i get (BIRT Logs)SQL queries which are
> internally executed.
>
> I have tried configuring the Level of logging to in the web.xml as
> specified in the eclipse birt wiki.
>
> The location of the eclipse id as follows :
>
> D:\eclipse\plugins\org.eclipse.birt.report.viewer_2.6.2.r262_v20110214\birt\WEB-INF
>
>
>
> Any help would be highly appreciated.
>
>
>
>
> Thanks
> Parasuram
|
|
|
|
Re: (no subject) [message #691045 is a reply to message #690850] |
Thu, 30 June 2011 15:15 |
|
Entering script is pretty easy. Can you try clicking on your dataset
then hit the script tab on the report canvas and entering a beforeOpen
script, something like:
importPackage( Packages.java.io );
out = new PrintWriter( new FileWriter( "c:/temp/myquery.txt", true ) );
out.println( "My Query: " + this.queryText);
out.close();
Jason
On 6/30/2011 6:25 AM, Praveen Jain wrote:
> Hi Jason,
>
> Even i am facing similar kind of problem, i am unable to see the sql
> queries fired by BIRT to generate the report output.
>
> I am developing a simple report without any java classes or even
> javascript.
>
> I am a newbie to BIRT your help regarding using java script or any other
> alternate means to get the logs would be highly appreciated.
>
> Thanks
>
>
|
|
|
Re: Where can I find logs? [message #692856 is a reply to message #690333] |
Tue, 05 July 2011 11:01 |
parasu Messages: 13 Registered: May 2011 |
Junior Member |
|
|
Thanks Jason,
Using the provided script i am able to see the sql queries executed while report generation.But i am not able to see the parameters passed.
could you please also suggest how to check the parameter for null value in the script. a simple example would be greatly helpfull.
[Updated on: Tue, 05 July 2011 11:26] Report message to a moderator
|
|
|
(no subject) [message #692987 is a reply to message #692856] |
Tue, 05 July 2011 14:34 |
|
Are these dataset parameters or report parameters? To check a report
parameter do something like:
if( params["NewParameter"].value == null ){
}
Jason
On 7/5/2011 7:01 AM, parasu wrote:
> Thanks Jason,
>
> Using the provided script i am able to see the sql queries executed
> while report generation.But i am not able to see the parameters passed.
> Also when i preview the report once the query is logged in the file
> multiple times(12times)
>
> could you please also suggest how to check the parameter for null value
> in the script. a simple example would be greatly helpfull.
>
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.03381 seconds