SYS.XMLTYPE Throws SQLException: Invalid column type: sqlType=2007 Error Code: 17004 (Doc ID 1933309.1)

Last updated on MARCH 10, 2016

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 ORD_ACTIVITY_CUST_DATA (ACTIVITY_CUST_DATA_ID, CONFIG_VERSION, UPDATE_COUNT, ACTIVITY_DATA, FOR_ORDER, FOR_ACTIVITY) VALUES (?, ?, ?, ?, ?, ?)

 

 

 

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