doc +blog :-) (I will also write a blog entry about this),
adam
Rebecca Parks schrieb:
> 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
>>>>>>>
>>>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>>
>