ORA-01843 ERR IS THROWN WHEN INSERT A ROW WITH DATE TYPE WITH JDK7 (Doc ID 1498112.1)

Last updated on JULY 02, 2017

Applies to:

JDBC - Version 11.2.0.3.0 to 11.2.0.3.0 [Release 11.2]
Information in this document applies to any platform.

Symptoms

When running jdbc tests for PS4 (10.3.5.0) with JDK7, error "ORA-01843: not a valid month" is thrown when trying to insert a row into oracle DB with a Date
type as below.


-----
[05-05 15:40:32][INFO ] 1  SQL: CREATE TABLE kyle_cnc2ttbasic0 (col0 CHAR(6)
NOT NULL, col1 VARCHAR(80) NOT NULL, col2 CHAR(12) NULL, col3 CHAR(4) NULL,
col4 NUMBER(4,2) NULL, col5 NUMBER(7,1) NULL, col6 INT NULL, col7 NUMBER NOT
NULL, col8 VARCHAR(200) NULL, col9 DATE NULL)
[05-05 15:40:33][INFO ] Table created...
[05-05 15:40:33][INFO ] dbtype= 0
[05-05 15:40:33][INFO ] col6 = 8000
[05-05 15:40:33][INFO ] SQL: insert into kyle_cnc2ttbasic0 values
('TC7777','Sushi, Anyone?','trad_cook','0877',14.99,8000,4095,1,'Detailed
instructions on improving your life by learning how to make authentic
Japanese sushi in your spare time. 5-10% increase in number of friends per
recipe reported from beta test.','12-Jul-85')
[05-05 15:40:34][INFO ] ERROR: ORA-01843: ?????
-----

This error will not occur when running with jdk6.

DIAGNOSTIC ANALYSIS (REQUIRED):
-------------------------------
The "?????" in above log is probably because that the test machine is a
windows box with Chinese language, but this should not impact the test result
since it could pass with jdk6.

Changes

 

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