Re: Storing time values via jdbc thin driver
Date: Fri, 28 Nov 2008 20:06:00 +0100
Vladimir M. Zakharychev wrote:
> However, since the date component is meaningless for java.sql.Time, I
> 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.
Thx. Received on Fri Nov 28 2008 - 13:06:00 CST