Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Where can I find logs? (Where can I find logs? )
Where can I find logs? [message #690333] Wed, 29 June 2011 11:50 Go to next message
parasu  is currently offline parasu Friend
Messages: 13
Registered: May 2011
Junior Member
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 14:53 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

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 10:25 Go to previous messageGo to next message
Praveen Jain is currently offline Praveen JainFriend
Messages: 1
Registered: June 2011
Junior Member
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 15:15 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

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 Go to previous messageGo to next message
parasu  is currently offline parasu Friend
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 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

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:
  


Current Time: Fri Dec 19 08:43:54 GMT 2014

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

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