Oracle JDBC 11.2.0.1.0 Driver Generates "ASSERTION BATCH: NEGATIVE TIME" (Doc ID 1066051.1)

Last updated on AUGUST 03, 2016

Applies to:

JDBC - Version: 11.2.0.1 to 11.2.0.1 - Release: 11.2 to 11.2
Information in this document applies to any platform.

Symptoms


When executing an insert or update on a DATE field on the database using PreparedStatement, and the value 09/10/2009 23:00 (in the format dd/mm/yyyy hh24:mi),  the JDBC driver throws the following exception

"java.lang.RuntimeException: Assertion batch: negative time"

The problem occurs only when the locale is set to America/Brasilia and connecting to a 9.2.0.8
database. Other database versions higher than 9.2.0.8 do not cause this problem.

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