Re: Where to see the generated sql when retrieving result from view entity?

[Jacques Le Roux]

http://markmail.org/message/s57f7znzczb6us6h

Jacques

From: "arini.rusda" <[hidden email]>

> Hi,
> I want to see the generated sql when i'm trying to retrieve data from view
> entities, because my view entity didn't show the result i expected when i
> want to do some grouping. Someone could tell me how to view the generated
> sql? Because i couldn't find it in the ofbiz.log
>
> Thanks in advance
>
>
> -----
> Best Regards,
> Arini Rusda
> Informatics Department, Sepuluh Nopember Institute of Technology
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Where-to-see-the-generated-sql-when-retrieving-result-from-view-entity-tp3414553p3414553.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

[Varun Bhansaly]

If you are using MySQL, they you may append
&amp;profileSQL=true&amp;maxQuerySizeToLog=4096
to the jdbc-uri for MySQL in entityengine.xml

On Tue, Mar 29, 2011 at 6:05 PM, Jacques Le Roux <
[hidden email]> wrote:

> http://markmail.org/message/s57f7znzczb6us6h
>
> Jacques
>
> From: "arini.rusda" <[hidden email]>
>
>  Hi,
>> I want to see the generated sql when i'm trying to retrieve data from view
>> entities, because my view entity didn't show the result i expected when i
>> want to do some grouping. Someone could tell me how to view the generated
>> sql? Because i couldn't find it in the ofbiz.log
>>
>> Thanks in advance
>>
>>
>> -----
>> Best Regards,
>> Arini Rusda
>> Informatics Department, Sepuluh Nopember Institute of Technology
>> --
>> View this message in context:
>> http://ofbiz.135035.n4.nabble.com/Where-to-see-the-generated-sql-when-retrieving-result-from-view-entity-tp3414553p3414553.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>
>
>

--
Regards,
Varun Bhansaly