Support for 2007 Daylight Saving Time (DST) in JDBC products
DataDirect Connect for JDBC
The United States has planned a change to its Daylight Saving Time (DST) observance beginning in 2007. The Energy Policy Act of 2005 mandates that DST will start on the second Sunday in March and end on the first Sunday in November. For 2007, this means that DST will start and end on the following dates:
Start date: March 11
End date: November 4
JVM Versions with Updated Rules for DST
The DataDirect Connect for JDBC drivers rely on the underlying Java platform for their handling of time zones and DST. If your application is sensitive to the change in DST, you must run the application with a Java Virtual Machine (JVM) that has been updated for the change in DST rules for 2007 and beyond. The JVM versions that use the updated rules for DST are listed here.
Sun Microsystems
Java SE 6 or higher
J2SE 5.0 Update 6 or higher
J2SE 1.4.2_11 or higher
J2SE 1.3.1_18 or higher
http://java.sun.com/developer/technicalArticles/Intl/USDST/
IBM
DST compatibility depends on the operating system on which the JVM runs. Refer to the following IBM documents for details:
http://www-1.ibm.com/support/docview.wss?uid=swg21248542
http://www-03.ibm.com/servers/eserver/iseries/
software/globalization/dst.html
BEA Systems
JRockit 1.4.2_11 R26.4 or higher
JRockit 1.5.0_06 R26.3 or higher
http://support.bea.com//support_news/Patch_for_2007
_Daylight_Savings_Time_Changes.jsp
Other JVM Vendors
Contact your JVM vendor for information about their support for DST changes.
DataDirect has tested DataDirect Connect for JDBC 3.5 and 3.6 drivers running on updated JVM versions and has verified that the new DST start and end dates beginning in 2007 adhere to the new DST rules. No driver changes were needed.
If your application uses time and date built-in database functions, JDBC time and date scalar function escapes1, or Java stored procedures that perform date and time processing, you must ensure that the database has been updated to support the DST time change. Refer to the following database vendor links below for details.
Microsoft SQL Server
http://www.microsoft.com/windows/timezone/dst2007.mspx
Oracle
Oracle MetaLink Documents
397281.1 - USA 2007 Daylight Saving Time (DST) Compliance for Database
359145.1 - Impact of 2007 USA daylight saving changes on the Oracle database
IBM DB2
http://www-1.ibm.com/support/docview.wss?uid=swg21248542
Sybase
http://www.sybase.com/detail?id=1048699
Informix
http://www-1.ibm.com/support/docview.wss?uid=swg21248851
1The DataDirect Connect for JDBC drivers map the JDBC time and date scalar function escapes to the corresponding database-specific built-in time and date functions.
