logging insert/update/delete statements

So far I only see select statements in the torque logs. Is there a way to get torque to log everything, not just selects? Raul - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: Oracle Date Village Patch

Supposedly starting the JVM with -Doracle.jdbc.V8Compatible=true fixes this: http://wiki.apache.org/db-torque/OracleFAQ However it didn't work for me, even after setting the Torque mapping to TIMESTAMP. I had to change the columns from DATE to TIMESTAMP. Raul Acevedo

Re: Oracle Date Village Patch

It doesn't change the whole JVM, it's a flag for the Oracle JDBC driver. I was a little leery of that also, but enough Google research seems to show that it only applies to the date/timestamp handling, though admittedly I did not find a site that definitely stated that. Ra

using timestamp with time zone

s it possible for this to work? Many thanks, Raul Acevedo http://www.cantara.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

RE: using timestamp with time zone

can > then locally override/add your own methods for converting > too and from a Java date object via the String representation. > > > > > > > -Original Message- > > From: Raul Acevedo [mailto:[EMAIL PROTECTED] > > Sent: Thursday, December 27, 200

using prepared statements for "in"

When you use Criteria.addIn, Torque does not generate a prepared statement. (Or at least it doesn't use bind variables for the "in" part, even if it does for other parts of the query.) Is there a way to get Torque to use bind variables for this? Without having to convert the query into a bunch o

Re: Criteria.addIn on List or Object[] doesn't generate quoted strings?

Apparently (and unfortunately) true. Unless someone speaks up and says there is a way to get Torque to do prepared statements for addIn, I'm going to have to convert our code to use OR instead of IN. Raul On Mar 7, 2008, at 7:06 AM, Brendan Miller wrote: Also, on the topic of addIn() and

Can LargeSelect use prepared statements?

It looks like Torque's LargeSelect does not use prepared statements in its queries. Is there a way to make it do that? Raul - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

RE: using prepared statements for "in"

E: using prepared statements for "in" > > > > I assume you are using XXPeer.doPSSelect ? > > Looking at the source code, I cannot see a way. Not even > > Criteria.CUSTOM > > will help :-( > > > > Do jdbc drivers understand binding of a collecti