Re: Storing time values via jdbc thin driver

"Chris Seidel" <cseidel_at_arcor.de> wrote in message news:49304116$0$31863$9b4e6d93_at_newsspool3.arcor-online.net...
> Vladimir M. Zakharychev wrote:
>> However, since the date component is meaningless for java.sql.Time, I
>> think
>> it's not really important what its value is in the database as it
>> probably will be properly reset in Java when retrieved and you don't
>> need it anyway.
>
> The problem is the switch from 9 to 10.
>
> java-pesudo-query: from foo where time := 10:00:00
>
> oracle-query with 9.2 driver: ... from foo where time = 1900-01-01
> 10:00:00
> oracle-query with 10.2 driver: ... from foo where time = 1970-01-01
> 10:00:00
>
> The 10.2-query will not find any records stored with the 9.2 driver.
>
> So it is impossible to used the same database with different drivers.
>
> Right?
>
> Thx.
>
>
>
>

I am not sure I understand the question. Wouldn't you be specifying the date and the time? In Oracle you don't have just time anyway. You have a date and a time. You could have a string field that represents a time. (ugh) or you could use some sort of integer to represent the time. It looks like you have an impediance mismatch between Java and Oracle. Jim Received on Fri Nov 28 2008 - 13:13:08 CST