Hi,
to provide a little background: In the Torque 3.1.1 release, the Torque
types date, time and timestamp ar all mapped to oracle type Date.
Unfortunately, the underlying village library (not the database!) truncates
all dates to date accuracy. So, if plain 3.1.1 is used, all the above
Torque types have day accuracy.
However, it is possible to change the mapping of Torque type Timestamp to
oracle type timestamp in the oracle db.props file, which changes the
accuracy of Torque type timestamp to at least milliseconds. I am not sure
if you have to regenerate your object model afterwards, maybe you can just
alter the table in the database.
There is nothing easy to be done about the Torque type time, I'm afraid.
See also http://issues.apache.org/scarab/issues/id/TRQS263
Thomas
[EMAIL PROTECTED] schrieb am 09.05.2005 16:42:47:
> http://www.devaki.org/nextobjects/torque-type-map.html
>
> Adam
>
>
>
>
>
> [EMAIL PROTECTED]
> c.fr To:
> "Apache Torque Users List" <[email protected]>
> cc:
> Subject: R�f. :
> Re: date fields / oracle
> 05/09/05 09:47 AM
> Please respond to
> "Apache Torque Users
> List"
>
>
>
>
>
>
> For Torque 3.1 (OM classes generated with Ant)
>
> \templates\sql\base\oracle\db.proprs
>
>
>
>
> Roel van Dijk
>
> <[EMAIL PROTECTED] Pour : Apache Torque Users List
> <[email protected]>
> l.com> cc :
>
> Objet : Re: date fields /
> oracle
> 09/05/2005
>
> 16:26
>
> Veuillez
>
> r�pondre �
>
> "Apache
>
> Torque Users
>
> List"
>
>
>
>
>
>
>
> > As a sidenote, where can I find a list of the available column types
> > that I can use in my XML schema?
>
> And a related question: where can I find the mapping between these
> column types (as defined in the XML schema), and the Java objects in
> the created OM classes? (e.g. VARCHAR to String, INTEGER to int, DATE
> to Date, etc..)
>
> --
> Roel -- [EMAIL PROTECTED]
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]