db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Armin Waibel <arm...@apache.org>
Subject Re: Oracle, timestamp locking and nanoseconds
Date Wed, 23 Feb 2005 21:52:38 GMT
Hi Martin,

your mail sounds like a  detective novel detective novel ;-)

Martin Kalén wrote:
> Martin Kalén wrote:
> 
>> This still failed with Oracle though, but today for the first time I 
>> really checked the DDL and saw that Torque was generating a 
>> DATE-column for LOCKED_BY_TIMESTAMP.TIMESTAMP_
> 
> 
> Now reproduced ~10 times:
> testTimestampLock with DDL as auto-generated by Torque (ie column 
> _TIMESTAMP as Oracle datatype DATE): FAIL
> 
> After the following SQL...
> alter table LOCKED_BY_TIMESTAMP modify (TIMESTAMP_ TIMESTAMP);
> ...the test is 100% OK.
> 
> Anyone know if we can get the old Torque to produce TIMESTAMP for Oracle 
> 9 or higher?
> 

I never used torque, but I found in torque jar under
torque-3.0.2.jar\sql\base\oracle the file dp.props. Seems that this file 
is responsible for java/sql mapping. Maybe a modified class could solve 
the problem.

regards,
Armin

>  Martin
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-dev-help@db.apache.org
> 
> 
> 

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


Mime
View raw message