After Upgrade From Weblogic version from 12.2.1.1.0 To 12.2.1.4.0 JPA Based Inserts Throw ORA-00957 (Doc ID 2723788.1)

Last updated on FEBRUARY 02, 2023

Applies to:

Symptoms

After upgrading the Weblogic server installations from version 12.2.1.1.0 to 12.2.1.4.0, when inserting data to JPA managed relational table it throws ORA-00957, duplicate column name.

Exception

javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.7.v20190604-418f1a1c56): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00957: duplicate column name
Error Code: 957
Call: INSERT INTO <table_name> (<column1>, <column2>, <column3>, <column4>, <column1>) VALUES (?, ?, ?, ?, ?)
bind => [11 parameters bound]
Query: InsertObjectQuery(<applicationpackage)>

<column1> is found twice in the insert statement.

 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.