2 Replies Latest reply on May 17, 2006 3:48 AM by Ramzi Maalej

    ora-00972

    Ramzi Maalej Newbie

      Hi,
      I am trying to build an application based on EJB3, but when i deploy it to the server i get this error : ORA-00972 identifier is too long.
      The problem caused by the name of the generated foreign key.

      Thanks for helps

        • 1. Re: ora-00972
          Atanas Todorov Newbie

          Well.. unfortunately Oracle will not allow you to use column names, longer than 30 chars. I suppose this is the problem you encounter. Check the length of your property name and consider the naming strategy you use?

          For example, using org.hibernate.cfg.DefaultComponentSafeNamingStrategy and several levels of embedded properties, can easily interfere with this Oracle limitation when trying to generate names like "customer_address_municipality_id":(

          If this is not the case, it's not a bad idea to paste some code, logs...?

          • 2. Re: ora-00972
            Ramzi Maalej Newbie

            Hi, i tried to use the safe strategy, but it doesn't work, i got the same problem, i think that i missed some properties. here is my persistence. xml file

            <persistence>
             <persistence-unit name="NtimBizAppDataLayer">
             <jta-data-source>java:OracleDS</jta-data-source>
             <properties>
             <property name="hibernate.hbm2ddl.auto" value="create-drop"/>
             <property name="hibernate.ejb.naming_strategy" value="org.hibernate.cfg.DefaultComponentSafeNamingStrategy" />
             </properties>
             </persistence-unit>
            </persistence>
            

            Please can you give a short example.
            thx for your help