Eclipse Community Forums: BIRT » Where can I find logs?

Home » Archived » BIRT » Where can I find logs? (Where can I find logs? )

Where can I find logs? [message #690333]

Wed, 29 June 2011 07:50

Eclipse User

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

(no subject) [message #690468 is a reply to message #690333]

Wed, 29 June 2011 10:53

Eclipse User

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 #690850 is a reply to message #690468]

Thu, 30 June 2011 06:25

Eclipse User

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: (no subject) [message #691045 is a reply to message #690850]

Thu, 30 June 2011 11:15

Eclipse User

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 07:01

Eclipse User

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 07:26] by Moderator

(no subject) [message #692987 is a reply to message #692856]

Tue, 05 July 2011 10:34

Eclipse User

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.
>
>
>

Previous Topic:	Problems loading org.eclipse.birt.report.data.oda.jdbc with BIRT 3.7
Next Topic:	Report parameters

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 12:54:46 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter