persistence@glassfish.java.net

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

From: Varun Rupela <Varun.Rupela_at_Sun.COM>
Date: Wed, 21 Feb 2007 16:34:34 +0530

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?

thanks.

varun.