db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Iskandar Salim" <iskan...@fused.com.sg>
Subject Struts and Torque
Date Fri, 31 Jan 2003 11:06:05 GMT


-----Original Message-----
From: Juan Perez [mailto:JuanP@buc.com]
Sent: Friday, January 31, 2003 2:35 AM
To: 'Turbine Torque Users List'
Subject: RE: timestamp is being truncated


Hello Steve,
As Walt mentioned, the root of the problem is that the Record class in
Village
is using the metadata type information for the Oracle columns so the
problems
lies at the JDBC level. Oracle JDBC driver is returning a datatype of DATE
which means that the time information is getting lost. This is using version

9.2.0.1 of the Oracle JDBC driver.




-----Original Message-----
From: Steve Dobie [mailto:sdobie@vcommerce.com]
Sent: Wednesday, January 29, 2003 4:01 PM
To: 'Turbine Torque Users List'
Subject: RE: timestamp is being truncated


I have seen this truncation problem as well, and it seems to be connected to
the Oracle driver version.  The truncation occurred when we used the Oracle
9.2.0 driver, but dates were set with a full timestamp wehn we used the
8.1.7 driver.  I am not sure if it is actually a driver bug, or just some
change in the drivers between the 8 and 9 versions that Torque has not been
updated to accomodate.

-----Original Message-----
From: Walt Armour [mailto:WaltA@concur.com]
Sent: Wednesday, January 29, 2003 1:46 PM
To: 'Turbine Torque Users List'
Subject: RE: timestamp is being truncated


We ran into this also.  I don't have all the details handy but I think it
went something like this:

We passed in a timestamp at some level.  It got converted into a
java.util.Date.  That got passed down through Torque and into Village.
Village converted it to a java.sql.Date (as opposed to java.sql.Timestamp).
Something after this (possibly the Oracle JDBC driver) considers it just a
date and whacks any timestamp portion (if there even is any at this point).

So it looks like a fix would need to occur at the village level.

> -----Original Message-----
> From: Geoff Fortytwo [mailto:g42@ign.com]
> Sent: Tuesday, January 28, 2003 1:53 PM
> To: turbine-torque-user@jakarta.apache.org
Hi all,

Something to get you started with using Struts and Torque.
http://javaxp.netfirms.com/torque-struts.html

Just my experience...

Regards,
Iskandar Salim


Mime
View raw message