ORA-01843 ERR IS THROWN WHEN INSERT A ROW WITH DATE TYPE WITH JDK7
Last updated on JULY 02, 2017
Applies to:JDBC - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 11.2]
Information in this document applies to any platform.
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
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.
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