db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fox <Thomas....@seitenbau.net>
Subject RE: get the SQL to be executed
Date Thu, 19 Jan 2012 08:25:53 GMT
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 can do the logging for you.

Torque 4 will not work because it uses prepared statements for updates,
this will not give you any sensible sql.

    Thomas

> Hello all, is there a way in Torque to get the SQL that is sent to the
DB.
> I have to generate a txt file where I save queries basically INSERT
> statements of long records.
> I was thinking of create the Torque classes, populate the objects with
> data that I get from a local instance of the DB and then, instead of
> using a save command, get the SQL that would be executed and store it in
> a file.
>
> Alternatively I could use this:
>
> http://openhms.sourceforge.net/sqlbuilder/
>
> but has dependencies that requires GPL license and I would avoid in this
> case that kind of license.


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


Mime
View raw message