Re: get the SQL to be executed

2012-01-20 Thread Ivano Luberti
l 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 18:38, Ivano Luberti wrote: >> Thanks all for your responses. >> Just

RE: get the SQL to be executed

2012-01-19 Thread Greg Monroe
l 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 18:38, Ivano Luberti wrote: > Thanks all for your responses. > Just to clarify, I need to generate sql commands i

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 (b

Re: get the SQL to be executed

2012-01-19 Thread Ivano Luberti
may need to > write some record handler code to deal with foreign keys. > > Greg > > -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 execut

RE: get the SQL to be executed

2012-01-19 Thread Greg Monroe
rque 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/p6spy/ On 19 January 2012 08:25, Thomas Fox 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 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 wrote: > 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 updat

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