SYS.XMLTYPE Throws SQLException: Invalid column type: sqlType=2007 Error Code: 17004
(Doc ID 1933309.1)
Last updated on AUGUST 21, 2023
Applies to:
Oracle TopLink - Version 12.1.1.0 to 12.1.2.0.0 [Release 12c]Information in this document applies to any platform.
Symptoms
When upgrading an Eclipselink JPA application to 12.1.1.0/Eclipselink 2.3.2 with JDBC driver 11.2.x (ojdbc6.jar), a runtime exception is encountered similar to the following example:
javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Invalid column type: sqlType=2007
Error Code: 17004
Call: INSERT INTO <TABLE NAME> (<COLUMN1>, <COLUMN2>, <COLUMN3>, <COLUMN4>, <COLUMN5>, <COLUMN6>) VALUES (?, ?, ?, ?, ?, ?)
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 |
Cause |
Solution |