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