database logging

[Rees Watkins]

Hi
 
I would like to log database calls to see calls after a user submits an order. How does one do this? I am aware of debug.properties file and properties verbose, timing , info, important, warning, error and fatal. Are there anymore flags?
 
Thank you
Rees


      __________________________________________________________
Sent from Yahoo! Mail.
A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html

[Ashish Vijaywargiya]

Debug.properties is the main file that is used to handle all the log levels.
The directory that is of your use will be /runtime/logs to see the details
of recent log and its level.

log4j.xml is another file to set the number of files and that should be
maintained with reference to each level.
Other settings are also present in log4j.xml like Format of generated log
files.

I hope you know about log4j (That is mostly used Java based api for logging
purpose).

--
Ashish

On Sat, Jun 14, 2008 at 9:15 PM, Rees Watkins <[hidden email]> wrote:

> Hi
>
> I would like to log database calls to see calls after a user submits an
> order. How does one do this? I am aware of debug.properties file and
> properties verbose, timing , info, important, warning, error and fatal. Are
> there anymore flags?
>
> Thank you
> Rees
>
>
>      __________________________________________________________
> Sent from Yahoo! Mail.
> A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html
>

[Rees Watkins]

Hi Ashish
 
Are there any specific entries to log SQL sent to the database?
 
Thank you
Rees


      __________________________________________________________
Sent from Yahoo! Mail.
A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html

[Scott Gray]

Hi Rees

Couldn't you just do the logging at the database end?

Regards
Scott

2008/6/15 Rees Watkins <[hidden email]>:

> Hi Ashish
>
> Are there any specific entries to log SQL sent to the database?
>
> Thank you
> Rees
>
>
>      __________________________________________________________
> Sent from Yahoo! Mail.
> A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html
>

[Rees Watkins]

Hi Scott
 
I am running OfBiz on my laptop at home. I am using the embedded db. Is it possible to log SQL with the embedded db?

Regards
Rees


      __________________________________________________________
Sent from Yahoo! Mail.
A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html

[Jacques Le Roux]

http://docs.ofbiz.org/display/OFBIZ/Key-Work+Ofbiz+Contribution+Proposal?focusedCommentId=2154

Jacques

From: "Rees Watkins" <[hidden email]>
Hi

I would like to log database calls to see calls after a user submits an order. How does one do this? I am aware of debug.properties
file and properties verbose, timing , info, important, warning, error and fatal. Are there anymore flags?

Thank you
Rees


      __________________________________________________________
Sent from Yahoo! Mail.
A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html