Eclipse Community Forums: BIRT » Logging to dump SQL queries

Home » Archived » BIRT » Logging to dump SQL queries

Logging to dump SQL queries [message #244990]

Tue, 26 June 2007 23: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

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

Wed, 27 June 2007 22:28

Eclipse User

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

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

Thu, 28 June 2007 13:52

Eclipse User

Originally posted by: rodionos.gmail.com

Thanks, that worked.

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

Goto Forum:

-=] Back to Top [=-

Current Time: Sun May 11 04:02:13 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter