2285225 - HANA DB JDBC Timestamp value for DST (Daylight Savings Time)

• SAP HANA JDBC PreparedStatement used to insert Timestamp values into SAP HANA DB.
• The Timestamp value is passed into the PreparedStatement as a String.
• The Timestamp value happen to reside within the time where clock shift occurs for Daylight Saving Time (DST) for the local time zone.
• The Timestamp value is shifted by one hour by the SAP HANA JDBC driver before the PreparedStatement is sent to the SAP HANA DB.
• This results in an incorrect value being stored in the database, or an error being triggered from constraint violation:
  
  com.sap.db.jdbc.exceptions.jdbc40.SQLIntegrityConstraintViolationException: [301]: unique constraint violated
  
  

• SAP HANA DB 1.0
• SAP HANA DB JDBC driver
• SAP HANA Studio
• Note: this issue does not occur for the SAP HANA DB ODBC driver.

SQL, Prepared Statement, Time zone, timezone, timestamp, time stamp, java.sql.Timestamp, TimeZone, UTC, user.timezone , KBA , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , HAN-DB , SAP HANA Database , How To