My Oracle Support Banner

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 21, 2021

Applies to:

Oracle TopLink - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

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

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
References


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