I will try it out in case it works blog about this :-),
greetings,
adam
Tom Ware schrieb:
> Hi Adam,
>
> Alot of this information can be made visible when using the
> persistence API just by increasing the logging level.
>
> When using the Java Persistence API, you can just provide the
> "toplink.logging.level" property in your persistence unit and set the
> value to FINE and you should be able to see all the SQL including the
> binding variables. I am not sure if that will completely satisfy your
> requirement, but perhaps it will help.
>
> -Tom
>
> Adam Bien wrote:
>
>> In the past a used p6spy to log all SQL statements to a file for
>> debugging purposes. P6spy even writes the value of binding variables
>> (the ? in prepared statements)
>> Is it possible to do the same with glassfish? -> this would be a
>> great feature and help to monitor caching behavior and monitoring,
>>
>> cheers,
>>
>> adam bien
>>
>>
>
--
Dipl. Inf. adam bien
BEA Technical Director
Sun Certified Java Programmer
Sun Certified Enterprise Java Architect
Sun Enterprise Java Trainer
Mobile: 0049(0)170 280 3144
eMail: abien_at_adam-bien.com
Homepage: www.adam-bien.com
Weblog: http://www.adam-bien.com/roller/page/abien
----------
Book author:
Enterprise Architekturen
entwickler.press 2006
ISBN: 393504299X
and Enterprise Java Frameworks,
J2EE Patterns, J2EE HotSpots and Struts.