How to see SQL as it is executing?

[Michael McCutcheon <mi...@frontiernet.net>]

When using the derby network server (or embedded for that matter), is  
there any way to see the SQL that is executing?

Can I turn on some property and see the SQL's the database is running?

You can do this with toplink, but I want to know if there is anything  
at the derby level that can do this.

Thanks,

Mike

Re: How to see SQL as it is executing?

[Stanley Bradbury <St...@gmail.com>]

Bryan Pendleton wrote:
> Michael McCutcheon wrote:
>>> Can I turn on some property and see the SQL's the database is running?
>
> See if this helps: 
> http://db.apache.org/derby/docs/dev/tuning/rtunproper43517.html
>
> thanks,
>
> bryan
The Hints and Tips section of the Derby Wiki has a writeup that 
introduces the format of the entries logged when logStatementText is 
enabled.  It might be helpful:

http://wiki.apache.org/db-derby/LogStamentTextMsgs

Re: How to see SQL as it is executing?

[Bryan Pendleton <bp...@amberpoint.com>]

Michael McCutcheon wrote:
>> Can I turn on some property and see the SQL's the database is running?

See if this helps: http://db.apache.org/derby/docs/dev/tuning/rtunproper43517.html

thanks,

bryan

Re: How to see SQL as it is executing?

[Michael McCutcheon <mi...@frontiernet.net>]

What I mean is can derby spew the SQL it is executing to the console?



On Sep 10, 2006, at 12:02 PM, Michael McCutcheon wrote:

> When using the derby network server (or embedded for that matter),  
> is there any way to see the SQL that is executing?
>
> Can I turn on some property and see the SQL's the database is running?
>
> You can do this with toplink, but I want to know if there is  
> anything at the derby level that can do this.
>
> Thanks,
>
> Mike
>
>