How to Make JDBC 11.2 Use Timezone Offset and Not Named Timezone? (Doc ID 2087294.1)

Last updated on MARCH 08, 2017

Applies to:

JDBC - Version 11.2.0.4.0 and later
Information in this document applies to any platform.

Goal

JDBC 11.2 sets the time_zone in a different way from how JDBC 11.1 sets it. JDBC 11.2 uses named time_zone like 'America/Chicago' whereas 11.1 JDBC drivers uses offset like time_zone='-6:00'.
How to make JDBC 11.2 use timezone offset and not named timezone?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms