You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Koon Sang <ko...@igine.com> on 2010/09/01 09:33:19 UTC
Show SQL Statements in Log
Hello,
I would like to know how I can configure OFBIZ to show the SQL statements
for all DB query in the log. I tried starting OFBIZ in debug mode but no
SQL statements are displayed. Anyone can advise?
Thank you.
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Show-SQL-Statements-in-Log-tp2402732p2402732.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Show SQL Statements in Log
Posted by sakthi vadivel <sa...@gmail.com>.
excellent, thank you for your information. I'll take it forward....
with regards and thanks
sakthi
On Wed, Sep 1, 2010 at 11:38 PM, David E Jones <de...@me.com> wrote:
>
> Take a look at GenericDAO.java, line 755. There is code there to log the SQL if the query takes longer than 150ms to run. When I'm working on the Entity Engine I usually modify this to log all queries.
>
> -David
>
>
> On Sep 1, 2010, at 11:51 AM, sakthi vadivel wrote:
>
>> Hi,
>>
>> I'm eager to see the queries generated by ofbiz, what if i use
>> different database than derby. I have checked mysql.properties that
>> doesn't has any specific properties to display the queries in log.
>>
>> Please guide me to view all the queries from console or write it to
>> some log files.
>>
>> with thanks and regards
>> sakthi
>>
>> On Wed, Sep 1, 2010 at 1:07 PM, Scott Gray <sc...@hotwaxmedia.com> wrote:
>>> If you're using derby then you can turn it on via derby.properties
>>> Typically it is left to the database to do this type of logging simply because the bulk of them already support it in one form or another.
>>>
>>> Regards
>>> Scott
>>>
>>> HotWax Media
>>> http://www.hotwaxmedia.com
>>>
>>> On 1/09/2010, at 7:33 PM, Koon Sang wrote:
>>>
>>>>
>>>> Hello,
>>>>
>>>> I would like to know how I can configure OFBIZ to show the SQL statements
>>>> for all DB query in the log. I tried starting OFBIZ in debug mode but no
>>>> SQL statements are displayed. Anyone can advise?
>>>>
>>>> Thank you.
>>>>
>>>>
>>>>
>>>> --
>>>> View this message in context: http://ofbiz.135035.n4.nabble.com/Show-SQL-Statements-in-Log-tp2402732p2402732.html
>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>>
>>
>>
>>
>> --
>> sakthi
>
>
--
sakthi
Re: Show SQL Statements in Log
Posted by David E Jones <de...@me.com>.
Take a look at GenericDAO.java, line 755. There is code there to log the SQL if the query takes longer than 150ms to run. When I'm working on the Entity Engine I usually modify this to log all queries.
-David
On Sep 1, 2010, at 11:51 AM, sakthi vadivel wrote:
> Hi,
>
> I'm eager to see the queries generated by ofbiz, what if i use
> different database than derby. I have checked mysql.properties that
> doesn't has any specific properties to display the queries in log.
>
> Please guide me to view all the queries from console or write it to
> some log files.
>
> with thanks and regards
> sakthi
>
> On Wed, Sep 1, 2010 at 1:07 PM, Scott Gray <sc...@hotwaxmedia.com> wrote:
>> If you're using derby then you can turn it on via derby.properties
>> Typically it is left to the database to do this type of logging simply because the bulk of them already support it in one form or another.
>>
>> Regards
>> Scott
>>
>> HotWax Media
>> http://www.hotwaxmedia.com
>>
>> On 1/09/2010, at 7:33 PM, Koon Sang wrote:
>>
>>>
>>> Hello,
>>>
>>> I would like to know how I can configure OFBIZ to show the SQL statements
>>> for all DB query in the log. I tried starting OFBIZ in debug mode but no
>>> SQL statements are displayed. Anyone can advise?
>>>
>>> Thank you.
>>>
>>>
>>>
>>> --
>>> View this message in context: http://ofbiz.135035.n4.nabble.com/Show-SQL-Statements-in-Log-tp2402732p2402732.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
>
>
>
> --
> sakthi
Re: Show SQL Statements in Log
Posted by sakthi vadivel <sa...@gmail.com>.
Hi,
I'm eager to see the queries generated by ofbiz, what if i use
different database than derby. I have checked mysql.properties that
doesn't has any specific properties to display the queries in log.
Please guide me to view all the queries from console or write it to
some log files.
with thanks and regards
sakthi
On Wed, Sep 1, 2010 at 1:07 PM, Scott Gray <sc...@hotwaxmedia.com> wrote:
> If you're using derby then you can turn it on via derby.properties
> Typically it is left to the database to do this type of logging simply because the bulk of them already support it in one form or another.
>
> Regards
> Scott
>
> HotWax Media
> http://www.hotwaxmedia.com
>
> On 1/09/2010, at 7:33 PM, Koon Sang wrote:
>
>>
>> Hello,
>>
>> I would like to know how I can configure OFBIZ to show the SQL statements
>> for all DB query in the log. I tried starting OFBIZ in debug mode but no
>> SQL statements are displayed. Anyone can advise?
>>
>> Thank you.
>>
>>
>>
>> --
>> View this message in context: http://ofbiz.135035.n4.nabble.com/Show-SQL-Statements-in-Log-tp2402732p2402732.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>
--
sakthi
Re: Show SQL Statements in Log
Posted by Scott Gray <sc...@hotwaxmedia.com>.
If you're using derby then you can turn it on via derby.properties
Typically it is left to the database to do this type of logging simply because the bulk of them already support it in one form or another.
Regards
Scott
HotWax Media
http://www.hotwaxmedia.com
On 1/09/2010, at 7:33 PM, Koon Sang wrote:
>
> Hello,
>
> I would like to know how I can configure OFBIZ to show the SQL statements
> for all DB query in the log. I tried starting OFBIZ in debug mode but no
> SQL statements are displayed. Anyone can advise?
>
> Thank you.
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Show-SQL-Statements-in-Log-tp2402732p2402732.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.