Re: Storing time values via jdbc thin driver

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. Received on Fri Nov 28 2008 - 13:06:00 CST