Re: get the SQL to be executed

2012-01-20 Thread Ivano Luberti
. But for a few table objects, it might be easier to just do the manually created toSQL() methods. -Original Message- From: Thomas Vandahl [mailto:t...@apache.org] Sent: Thursday, January 19, 2012 12:51 PM To: Apache Torque Users List Subject: Re: get the SQL to be executed On 19.01.12

RE: get the SQL to be executed

2012-01-19 Thread Thomas Fox
Perhaps you can use the log output (with some tweaks to the log4j configuration). However I'm not sure how and if Torque 3.3 logs the update statements. But then again I've heard of drivers which at as a bridge between the application and the real driver (e.g http://www.squirrelsql.org/) and which

Re: get the SQL to be executed

2012-01-19 Thread Joe Carter
You can use a logging driver such as p6spy to see your SQL statements. http://sourceforge.net/projects/p6spy/ On 19 January 2012 08:25, Thomas Fox thomas@seitenbau.net wrote: Perhaps you can use the log output (with some tweaks to the log4j configuration). However I'm not sure how and if

RE: get the SQL to be executed

2012-01-19 Thread Greg Monroe
Subject: Re: get the SQL to be executed You can use a logging driver such as p6spy to see your SQL statements. http://sourceforge.net/projects/p6spy/ On 19 January 2012 08:25, Thomas Fox thomas@seitenbau.net wrote: Perhaps you can use the log output (with some tweaks to the log4j configuration

Re: get the SQL to be executed

2012-01-19 Thread Ivano Luberti
-Original Message- From: Joe Carter [mailto:joe.car...@gmail.com] Sent: Thursday, January 19, 2012 3:32 AM To: Apache Torque Users List Subject: Re: get the SQL to be executed You can use a logging driver such as p6spy to see your SQL statements. http://sourceforge.net/projects

Re: get the SQL to be executed

2012-01-19 Thread Thomas Vandahl
On 19.01.12 18:38, Ivano Luberti wrote: Thanks all for your responses. Just to clarify, I need to generate sql commands inside my code to generate a file that can be used by another software (not written by me) to import data. I would like not to execute commands but only write them

RE: get the SQL to be executed

2012-01-19 Thread Greg Monroe
...@apache.org] Sent: Thursday, January 19, 2012 12:51 PM To: Apache Torque Users List Subject: Re: get the SQL to be executed On 19.01.12 18:38, Ivano Luberti wrote: Thanks all for your responses. Just to clarify, I need to generate sql commands inside my code to generate a file that can be used