You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by "Algirdas M." <sn...@splius.lt> on 2004/04/18 16:35:15 UTC

generated queries

Hello,

  Is there a possibility to see which queries with Torque has been
  executed?

  

-- 
Best regards,
 Algirdas                          mailto:snk@splius.lt


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Re: generated queries

Posted by Bogdan Vatkov <bv...@globaltech-bg.com>.
Yes,
find your Torque.properties file
and locate in it the section that configures the logging

something like this:

# -------------------------------------------------------------------
#
#  L O G G I N G
#
# -------------------------------------------------------------------
# We use Log4J for all Torque logging and we embed the log4j
# properties within our application configuration.
# -------------------------------------------------------------------

log4j.rootCategory = ERROR, default
log4j.appender.default = org.apache.log4j.FileAppender
log4j.appender.default.file = ./torque.log
log4j.appender.default.layout = org.apache.log4j.SimpleLayout


and change:
log4j.rootCategory = ERROR, default
to 
log4j.rootCategory =DEBUG, default


regards,
bogdan
----- Original Message ----- 
From: "Algirdas M." <sn...@splius.lt>
To: <to...@db.apache.org>
Sent: Sunday, April 18, 2004 5:35 PM
Subject: generated queries


> Hello,
> 
>   Is there a possibility to see which queries with Torque has been
>   executed?
> 
>   
> 
> -- 
> Best regards,
>  Algirdas                          mailto:snk@splius.lt
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


RE: generated queries

Posted by Michael Manske <ne...@manskes.de>.
hi,

use P6Spy to log all sql statements:

There already a description about configuration and usage in Torques Wiki:
http://wiki.apache.org/db-torque/FrequentlyAskedQuestions -
just look for the question "How to add P6Spy for printing SQL".

You can download P6Spy from http://www.p6spy.com. It's licensed under a
Apache Software License compatible license, so you can use it without any
important restrictions.

so long
Micha


> -----Original Message-----
> From: Algirdas M. [mailto:snk@splius.lt]
> Sent: Sunday, April 18, 2004 4:35 PM
> To: torque-user@db.apache.org
> Subject: generated queries
>
>
> Hello,
>
>   Is there a possibility to see which queries with Torque has been
>   executed?
>
>
>
> --
> Best regards,
>  Algirdas                          mailto:snk@splius.lt
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.659 / Virus Database: 423 - Release Date: 15.04.2004
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.659 / Virus Database: 423 - Release Date: 15.04.2004


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org