You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by X Gylee <x....@gmail.com> on 2007/07/05 04:24:20 UTC
How to debug SQL
Hello all,
I just started using OFBiz for my work, and I need help to debug a findByAnd
problem.
Is there a way in OFBiz to see the generated SQL statement during an entity
operation?
This way, I can debug my application should a problem appear.
Re: How to debug SQL
Posted by Gautam Deb <ga...@in2m.com>.
Yes, as Brett suggested, setting the '/print.verbose=true/' in
debug.properties will solve the problem. The location of this file is
$OFBIZ_HOME/framework/base/config/debug.properties.
Regards,
Gautam Deb
Rodrigo Souza wrote:
> Restart or clear cache.
>
> 2007/7/5, Brett Palmer <br...@gmail.com>:
>> Change the debug.properties to use verbose. I think this file is on
>> the base/config directory but that is from memory.
>>
>> Brett
>>
>> On 7/4/07, X Gylee <x....@gmail.com> wrote:
>> > Hello all,
>> > I just started using OFBiz for my work, and I need help to debug a
>> findByAnd
>> > problem.
>> > Is there a way in OFBiz to see the generated SQL statement during
>> an entity
>> > operation?
>> > This way, I can debug my application should a problem appear.
>> >
>>
>
Re: How to debug SQL
Posted by Rodrigo Souza <ac...@gmail.com>.
Restart or clear cache.
2007/7/5, Brett Palmer <br...@gmail.com>:
> Change the debug.properties to use verbose. I think this file is on
> the base/config directory but that is from memory.
>
> Brett
>
> On 7/4/07, X Gylee <x....@gmail.com> wrote:
> > Hello all,
> > I just started using OFBiz for my work, and I need help to debug a findByAnd
> > problem.
> > Is there a way in OFBiz to see the generated SQL statement during an entity
> > operation?
> > This way, I can debug my application should a problem appear.
> >
>
Re: How to debug SQL
Posted by Brett Palmer <br...@gmail.com>.
Change the debug.properties to use verbose. I think this file is on
the base/config directory but that is from memory.
Brett
On 7/4/07, X Gylee <x....@gmail.com> wrote:
> Hello all,
> I just started using OFBiz for my work, and I need help to debug a findByAnd
> problem.
> Is there a way in OFBiz to see the generated SQL statement during an entity
> operation?
> This way, I can debug my application should a problem appear.
>
Re: How to debug SQL
Posted by Rodrigo Souza <ac...@gmail.com>.
Change Log Level in webtools application.
2007/7/4, X Gylee <x....@gmail.com>:
> Hello all,
> I just started using OFBiz for my work, and I need help to debug a findByAnd
> problem.
> Is there a way in OFBiz to see the generated SQL statement during an entity
> operation?
> This way, I can debug my application should a problem appear.
>