Query Generated By TopLink Causes Error "ORA-00972: identifier is too long" (Doc ID 1253121.1)

Last updated on OCTOBER 25, 2016

Applies to:

Oracle TopLink - Version 11.1.1.3.0 and later
Information in this document applies to any platform.
** Check for relevance 06-AUG-2013**

Symptoms

TopLink returns following error:

Internal Exception:
java.sql.SQLException: ORA-00972: identifier is too long Error Code: 972

This happens when an underlying database column has a name that contains 30 characters. As TopLink adds some additional numbers when generating the alias for the columns, the maximum length of the alias exceeds 30 characters  which causes an ORA-00972 error.

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