Marina,
you are right. But you have also to "redirect" the JDBC,URL. Setup the
configuration file etc.
It is absolut o.k. for me, but not so convenient for
production/pre-production (load test) environment,
regards,
adam
Marina Vatkina schrieb:
> Adam,
>
> What kind of installation? Looking at their website, it should be as
> simple as dropping the files, and changing the driver name in 2 places
> (domain.xml and their property file). Anything else?
>
> thanks,
> -marina
>
> Adam Bien wrote:
>> Marina,
>>
>> P6Spy will work. But the installation is an additional effort. I'm
>> looking for a build-in feature,
>>
>> greetings,
>>
>> adam
>> Marina Vatkina schrieb:
>>
>>> Tom,
>>>
>>> FINE logging gives you too many messages that you need to parse to
>>> get to
>>> the actual SQL. In CMP we added a special sublogger to log generated
>>> SQL
>>> only (both, the users and our SQEs were asking for it).
>>>
>>> Adam,
>>>
>>> I don't see a reason for p6spy not to work with glassfish. Can you
>>> try and
>>> let us know (blog?) how well does it work? If you encounter any
>>> issues that
>>> you think are glassfish bugs, file the corresponding issue. Glassfish
>>> connection pooling wraps the actual database connections, but it
>>> shouldn't
>>> cause any problems.
>>>
>>> Thanks,
>>> -marina
>>>
>>>
>>> Tom Ware wrote:
>>>
>>>> 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.