persistence@glassfish.java.net

Re: exception on table name length >30 char with oracle 10g

From: Wouter van Reeven <wouter_at_van.reeven.nl>
Date: Wed, 21 Feb 2007 12:07:18 +0100

Hi,


On Wed, Feb 21, 2007 at 04:34:34PM +0530, Varun Rupela wrote:
> Hi:
>
> I get the following exception on using a Entity Name or @Table(name)
> that is larger that 30 characters:
>
> [TopLink Warning]: 2007.02.21
> 04:22:17.695--ServerSession(1623405)--Exception [TOPLINK-4002] (Oracle
> TopLink Essentials - 9.1 (Build b33d-beta)):
> oracle.toplink.essentials.exceptions.DatabaseException
> [java] Internal Exception: java.sql.SQLException: [sunm][Oracle
> JDBC Driver][Oracle]ORA-00972: identifier is too long
> [java] Error Code: 972
>
> Is this a bug or toplink does not handle this situation?
> Without specifying a smaller table name, is there a way in toplink (a
> property setting perhaps) to accept names greater than 30 characters
> with Oracle? OR does this require some specific configuration settings
> during creation of database / schema with Oracle 10g?

This is a restriction in Oracle 10g. See

http://www.oracle-base.com/articles/misc/NamingConventions.php


HTH, Wouter van Reeven

-- 
People: "If she weighs the same as a Duck, she's made of wood!"
Sir Bedevere: "And therefore...?"