hibernate-issues

[Hibernate-issues] [Hibernate-JIRA] Created: (HHH-355) Identifier is too long

[<no...@at...>]

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-355

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HHH-355
    Summary: Identifier is too long
       Type: Bug

     Status: Unassigned
   Priority: Major

 Original Estimate: Unknown
 Time Spent: Unknown
  Remaining: Unknown

    Project: Hibernate3
 Components: 
             core
   Versions:
             3.0 final

   Assignee: 
   Reporter: Tim McCune

    Created: Fri, 15 Apr 2005 11:28 AM
    Updated: Fri, 15 Apr 2005 11:28 AM
Environment: Oracle 9, JDK 1.5

Description:
SchemaUpdate is trying to create a foreign key constraint whose name is too long for Oracle:

2005-04-15 12:25:26,444 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table LoadDescriptor add constraint FK18D5ABAD371DC5BAba9c69f2d683d915 foreign key (parent) references Workspace
2005-04-15 12:25:26,444 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] [Oracle] #60 ORA-00972: identifier is too long


---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-355) Identifier is too long

[<no...@at...>]

The following comment has been added to this issue:

     Author: Gavin King
    Created: Fri, 15 Apr 2005 10:46 PM
       Body:
I'll close this, unless you have some simple test case the reproduces the problem.
---------------------------------------------------------------------
View this comment:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-355?page=comments#action_17160

---------------------------------------------------------------------
View the issue:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-355

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HHH-355
    Summary: Identifier is too long
       Type: Bug

     Status: Unassigned
   Priority: Major

 Original Estimate: Unknown
 Time Spent: Unknown
  Remaining: Unknown

    Project: Hibernate3
 Components: 
             core
   Versions:
             3.0 final

   Assignee: 
   Reporter: Tim McCune

    Created: Fri, 15 Apr 2005 11:28 AM
    Updated: Fri, 15 Apr 2005 10:46 PM
Environment: Oracle 9, JDK 1.5

Description:
SchemaUpdate is trying to create a foreign key constraint whose name is too long for Oracle:

2005-04-15 12:25:26,444 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table LoadDescriptor add constraint FK18D5ABAD371DC5BAba9c69f2d683d915 foreign key (parent) references Workspace
2005-04-15 12:25:26,444 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] [Oracle] #60 ORA-00972: identifier is too long


---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Closed: (HHH-355) Identifier is too long

[<no...@at...>]

Message:

   The following issue has been closed.

   Resolver: Gavin King
       Date: Wed, 20 Apr 2005 10:32 AM

No response from user.
---------------------------------------------------------------------
View the issue:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-355

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HHH-355
    Summary: Identifier is too long
       Type: Bug

     Status: Closed
   Priority: Major
 Resolution: INCOMPLETE

 Original Estimate: Unknown
 Time Spent: Unknown
  Remaining: Unknown

    Project: Hibernate3
 Components: 
             core
   Versions:
             3.0 final

   Assignee: 
   Reporter: Tim McCune

    Created: Fri, 15 Apr 2005 11:28 AM
    Updated: Wed, 20 Apr 2005 10:32 AM
Environment: Oracle 9, JDK 1.5

Description:
SchemaUpdate is trying to create a foreign key constraint whose name is too long for Oracle:

2005-04-15 12:25:26,444 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table LoadDescriptor add constraint FK18D5ABAD371DC5BAba9c69f2d683d915 foreign key (parent) references Workspace
2005-04-15 12:25:26,444 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] [Oracle] #60 ORA-00972: identifier is too long


---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-355) Identifier is too long

[<no...@at...>]

The following comment has been added to this issue:

     Author: Stephen Schleimer
    Created: Fri, 5 Aug 2005 11:14 AM
       Body:
I have found the same problem when processing mapping for a model with 343 classes and 212 mapping files (using union-subclass).  In a subset of the model (the exactly same hierarchies, merely pruned) in which I have 67 classes and 29 mapping files, I do not experience this failure.  So, I do not believe that I can provide a simple example of the failure.

-steve
---------------------------------------------------------------------
View this comment:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-355?page=comments#action_19184

---------------------------------------------------------------------
View the issue:
  http://opensource.atlassian.com/projects/hibernate/browse/HHH-355

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HHH-355
    Summary: Identifier is too long
       Type: Bug

     Status: Closed
   Priority: Major
 Resolution: INCOMPLETE

 Original Estimate: Unknown
 Time Spent: Unknown
  Remaining: Unknown

    Project: Hibernate3
 Components: 
             core
   Versions:
             3.0 final

   Assignee: 
   Reporter: Tim McCune

    Created: Fri, 15 Apr 2005 11:28 AM
    Updated: Fri, 5 Aug 2005 11:14 AM
Environment: Oracle 9, JDK 1.5

Description:
SchemaUpdate is trying to create a foreign key constraint whose name is too long for Oracle:

2005-04-15 12:25:26,444 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table LoadDescriptor add constraint FK18D5ABAD371DC5BAba9c69f2d683d915 foreign key (parent) references Workspace
2005-04-15 12:25:26,444 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] [Oracle] #60 ORA-00972: identifier is too long


---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira

[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-355) Identifier is too long

[Andrea A. (JIRA) <no...@at...>]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-355?page=comments#action_23573 ] 

Andrea Aime commented on HHH-355:
---------------------------------

While I don't have a simple example, I can tell you how this long names are created. I do have a hierarchy mapped with the table per class approach, with intermediate abstract classes.

Leaf classes of this hierarchy are apparently managed in hibernate usign the DenormalizedTable class. The code that generates the foreign keys for this class is:

public void createForeignKeys() {
		includedTable.createForeignKeys();
		Iterator iter = includedTable.getForeignKeyIterator();
		while ( iter.hasNext() ) {
			ForeignKey fk = (ForeignKey) iter.next();
			createForeignKey( 
					fk.getName() + Integer.toHexString( getName().hashCode() ), 
					fk.getColumns(), 
					fk.getReferencedEntityName() 
				);
		}
	}

As you can see, it gets the foreign key name of the contained class, and appends another hexstring. This name can become really long if the 
hierarchy has many levels. In my case I get names as long as: FK14F780C41886F83e63ff56e238e868d73630607

> Identifier is too long
> ----------------------
>
>          Key: HHH-355
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-355
>      Project: Hibernate3
>         Type: Bug

>   Components: core
>     Versions: 3.0 final
>  Environment: Oracle 9, JDK 1.5
>     Reporter: Tim McCune

>
>
> SchemaUpdate is trying to create a foreign key constraint whose name is too long for Oracle:
> 2005-04-15 12:25:26,444 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table LoadDescriptor add constraint FK18D5ABAD371DC5BAba9c69f2d683d915 foreign key (parent) references Workspace
> 2005-04-15 12:25:26,444 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] [Oracle] #60 ORA-00972: identifier is too long

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira