Would steps for how to do this be a good thing to add to the doc? Or is
this more of a blog topic?
June
Adam Bien wrote On 08/16/06 10:39,:
> 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
>>>>>>
>>>>>>
>>>>
>>>
>>>
>>
>
>