Underlying Query for View-entity

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
su2
Reply | Threaded
Open this post in threaded view
|

Underlying Query for View-entity

su2
Hello All,

Is it possible to see underlying queries for view-entity? I tried checking checkbox for verbose in Adjust Debugging Level. And tried to see in runtime/log but was not able to see any SQL query there.

Am I looking at the right file? Is there any other way?

I really appreciate all your help.

Thank you.
Su-
Reply | Threaded
Open this post in threaded view
|

Re: Underlying Query for View-entity

Yoke Power
Hi Su,

I believe the query is not printed even in the Verbose, But if you
have a capability to debug, the query is constructed in the
org.ofbiz.entity.datasource.GenericDAO class; there are multiple
select methods in there where the query is constructed. You could
modify the code to add a print statement or do a debug using tools
like eclipse, Hope this helps

- YOKEPOWER


On 9/23/09, su2 <[hidden email]> wrote:

>
> Hello All,
>
> Is it possible to see underlying queries for view-entity? I tried checking
> checkbox for verbose in Adjust Debugging Level. And tried to see in
> runtime/log but was not able to see any SQL query there.
>
> Am I looking at the right file? Is there any other way?
>
> I really appreciate all your help.
>
> Thank you.
> Su-
> --
> View this message in context:
> http://www.nabble.com/Underlying-Query-for-View-entity-tp25531126p25531126.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Underlying Query for View-entity

Scott Gray-2
It is also normally possible to adjust your database settings to have  
it log all SQL statements.

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 24/09/2009, at 1:24 PM, Yoke Power wrote:

> Hi Su,
>
> I believe the query is not printed even in the Verbose, But if you
> have a capability to debug, the query is constructed in the
> org.ofbiz.entity.datasource.GenericDAO class; there are multiple
> select methods in there where the query is constructed. You could
> modify the code to add a print statement or do a debug using tools
> like eclipse, Hope this helps
>
> - YOKEPOWER
>
>
> On 9/23/09, su2 <[hidden email]> wrote:
>>
>> Hello All,
>>
>> Is it possible to see underlying queries for view-entity? I tried  
>> checking
>> checkbox for verbose in Adjust Debugging Level. And tried to see in
>> runtime/log but was not able to see any SQL query there.
>>
>> Am I looking at the right file? Is there any other way?
>>
>> I really appreciate all your help.
>>
>> Thank you.
>> Su-
>> --
>> View this message in context:
>> http://www.nabble.com/Underlying-Query-for-View-entity-tp25531126p25531126.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>


smime.p7s (3K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Underlying Query for View-entity

Jacques Le Roux
Administrator
In reply to this post by Yoke Power
https://issues.apache.org/jira/browse/OFBIZ-1030

Jacques

From: "Yoke Power" <[hidden email]>

> Hi Su,
>
> I believe the query is not printed even in the Verbose, But if you
> have a capability to debug, the query is constructed in the
> org.ofbiz.entity.datasource.GenericDAO class; there are multiple
> select methods in there where the query is constructed. You could
> modify the code to add a print statement or do a debug using tools
> like eclipse, Hope this helps
>
> - YOKEPOWER
>
>
> On 9/23/09, su2 <[hidden email]> wrote:
>>
>> Hello All,
>>
>> Is it possible to see underlying queries for view-entity? I tried checking
>> checkbox for verbose in Adjust Debugging Level. And tried to see in
>> runtime/log but was not able to see any SQL query there.
>>
>> Am I looking at the right file? Is there any other way?
>>
>> I really appreciate all your help.
>>
>> Thank you.
>> Su-
>> --
>> View this message in context:
>> http://www.nabble.com/Underlying-Query-for-View-entity-tp25531126p25531126.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
>