Eclipse Community Forums: BIRT » Logging to dump SQL queries

Help

Home

Home » Archived » BIRT » Logging to dump SQL queries

Show: Today's Messages :: Show Polls :: Message Navigator

Logging to dump SQL queries [message #244990]

Wed, 27 June 2007 03:06

Eclipse User

Originally posted by: rodionos.gmail.com

My environment:
- birt 2.1.2
- jdk 1.4.2
- stand-along java application

I have a requirement to log SQL queries that are executed by various
viewer and report engine tasks.

Config logger doesn't seem to have any effect:
config.setLogConfig(null, Level.FINEST);

I also tried package and class loggers, to no avail:

Logger.getLogger("org.eclipse.birt.data.engine").setLevel(Level.FINEST);
Logger.getLogger("org.eclipse.birt.data.engine.odaconsumer.Driver ").setLevel(Level.FINEST);

Is there a trick to configuring BIRT logging for stand-along applications?
No matter what I do, I still get a warning at the data engine startup:

26.06.2007 20:03:20 org.eclipse.birt.data.engine.odaconsumer.Driver
setLogConfiguration
INFO: ODA driver does not have valid trace logging defined in the plug-in
options or plugin.xml file.

Thanks

Report message to a moderator

Re: Logging to dump SQL queries [message #245277 is a reply to message #244990]

Thu, 28 June 2007 02:28

Linda Chan

Messages: 845
Registered: July 2009

Senior Member

If you want to log the SQL query text, set logging on the
org.eclipse.birt.report.data.oda.jdbc.Statement , which is responsible for
preparing the SQL queries.

"Sergei" <rodionos@gmail.com> wrote in message
news:2745e7108754110ff7903d7865c73763$1@www.eclipse.org...
> My environment:
> - birt 2.1.2
> - jdk 1.4.2
> - stand-along java application
>
> I have a requirement to log SQL queries that are executed by various
> viewer and report engine tasks.
> Config logger doesn't seem to have any effect:
> config.setLogConfig(null, Level.FINEST);
>
> I also tried package and class loggers, to no avail:
>
> Logger.getLogger("org.eclipse.birt.data.engine").setLevel(Level.FINEST);
> Logger.getLogger("org.eclipse.birt.data.engine.odaconsumer.Driver ").setLevel(Level.FINEST);
>
> Is there a trick to configuring BIRT logging for stand-along applications?
> No matter what I do, I still get a warning at the data engine startup:
>
> 26.06.2007 20:03:20 org.eclipse.birt.data.engine.odaconsumer.Driver
> setLogConfiguration
> INFO: ODA driver does not have valid trace logging defined in the plug-in
> options or plugin.xml file.
>
> Thanks
>
>
>

Report message to a moderator

Re: Logging to dump SQL queries [message #245448 is a reply to message #245277]

Thu, 28 June 2007 17:52

Eclipse User

Originally posted by: rodionos.gmail.com

Thanks, that worked.

Report message to a moderator

Previous Topic:	DrillDown in a new window - resize window?
Next Topic:	Modifying memoryCacheRowCount at runtime

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Oct 10 23:28:36 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter