ORA-01843 ERR IS THROWN WHEN INSERT A ROW WITH DATE TYPE WITH JDK7
(Doc ID 1498112.1)
Last updated on AUGUST 12, 2022
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 <TABLE NAME>(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 <TABLE NAME> values ('TEXT ONE','TEXT TWO','TEXT THREE','YYYY',14.99,8000,4095,1,'TEXT FOUR','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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |