JDBC Application Does Not Reflect The DST Changes That Take Effect In The Database
Last updated on JULY 09, 2012
Applies to:JDBC - Version 10.2.0 to 184.108.40.206
Information in this document applies to any platform.
You have noticed that the DST changes that take effect in the database are not reflected when the timestamp is retrieved by an application using the JDBC driver.
1. set current timezone of your Windows PC to US/NewYork
2. set system clock to 01:59:00 01 Nov 2009
3. start the testCase application (Press enter to get another date-time
reading by the application)
4. wait a minute. Operating system should change time to apply Day Light
Savings (system clock should be reverted to 01:00 AM)
5. get another time reading from the application (press enter). It shows
application time different from database time.
We would expect that in step 5 database time matches the application time.
Time discrepency is not balanced until application restart.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms