JDBC Binding Timestamp To Oracle Date Column Does Not Use Indices (Doc ID 1302914.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Utilities Framework - Version: 2.1.0 to 2.2.0 - Release: 2.1 to 2.2
Information in this document applies to any platform.

Symptoms

The JDBC prepared statement binding a Timestamp (the "universal" datetime SQL type) against the Oracle DB columns of 'Date' type does not use indices in any queries.

Cause

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