Oracle JDBC驱动程序版本11.2.0.2.0是否打破了夏令时处理? [英] Was daylight savings time handling broken in Oracle JDBC driver version 11.2.0.2.0?

问题描述

我突然注意到，我与Oracle 11g R2一起使用的Oracle JDBC驱动程序认为，美国的夏令时开始于今年3月13日凌晨2:59:59.实际上，它是在凌晨1:59:59之后开始的.我进行了一些其他测试，发现该驱动程序的错误行为不取决于它与Oracle 11g R2还是与Oracle 10g对话.另外，该驱动程序的所有可用早期版本都可以正确处理夏时制.

I suddenly noticed that Oracle JDBC driver that I was using With Oracle 11g R2 was thinking that daylight savings time in US started after 2:59:59 am on March 13th this year. Actually, it started after 1:59:59 am. I did some additional testing and noticed that the buggy behavior of that driver did not depend on whether it talks to Oracle 11g R2 or Oracle 10g. Also, all available previous versions of that driver handle daylight savings time change correctly.

这是一个已知的错误吗?是否有可用的修复程序?

Is this a known bug? Is there a fix available for it?

推荐答案

我们的DBA进行了研究，发现这是一个已知的错误，并且已经有可用的补丁程序.感谢所有关心此事并动动脑筋寻找答案的人！

Our DBA did research and found that this is a known bug and that a patch is available for it. Thanks everyone who cared to look into this and rake your brain for answers!

编辑9/25/2013 :在撰写本文时(两年多以前)，付费的Oracle客户可以使用Oracle JDBC驱动程序11.2.0.2.0的补丁程序.我还没有亲自测试，但是我认为该问题已在Oracle JDBC驱动程序的当前版本11.2.0.4中得到解决，该版本可从Oracle免费下载.

EDIT 9/25/2013: At the time of writing (over 2 years ago) a patch for the Oracle JDBC driver 11.2.0.2.0 was available to the paying Oracle customers. I have not tested personally, but I believe that the issue is resolved in the current version of the Oracle JDBC driver 11.2.0.4 which is available from Oracle for a free download.

这篇关于Oracle JDBC驱动程序版本11.2.0.2.0是否打破了夏令时处理?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！