debugging queries in mysql

[rajesh <ra...@gmail.com>]

hi,

how to track the queries in mysql

how should i know which table<entity> is updated when perform some action in
ofbiz?

is there any log files to see queries (or) how can i set to see the log
files to see queries?

but i can see the xml s through the flow of execution
thanku 
-- 
View this message in context: http://www.nabble.com/debugging-queries-in-mysql-tf2870055.html#a8021760
Sent from the OFBiz - Dev mailing list archive at Nabble.com.

Re: debugging queries in mysql

[Ashish Vijaywargiya <as...@adititechlabs.com>]

Rajesh,

>> is there any log files to see queries (or) how can i set to see the log
>> files to see queries?

Open the SQLProcessor.java.

Comment out the following line :
 //if (Debug.verboseOn()) Debug.logVerbose("[SQLProcessor.prepareStatement]
sql=" + sql, module);
and write down this line below commented line :
System.err.println("[SQLProcessor.prepareStatement] sql=" + sql);

Rajesh, it would be nice if you will post this type of question on the
ofbiz-user mailing list.
Because this list is used for the core development related to ofbiz project.


On 12/22/06, rajesh <ra...@gmail.com> wrote:
>
>
> hi,
>
> how to track the queries in mysql
>
> how should i know which table<entity> is updated when perform some action
> in
> ofbiz?
>
> is there any log files to see queries (or) how can i set to see the log
> files to see queries?
>
> but i can see the xml s through the flow of execution
> thanku
> --
> View this message in context:
> http://www.nabble.com/debugging-queries-in-mysql-tf2870055.html#a8021760
> Sent from the OFBiz - Dev mailing list archive at Nabble.com.
>
>
-- 
Regards
Ashish Vijaywargiya
Aditisoft Technology Laboratory