NamingStrategy for foreign keys doesn't work

jps26401 · **Joined:** Tue Mar 21, 2006 5:22 am **Posts:** 5

Hello,
I want to replace generated foreign key names (FK + hash(table name) + hash(column name)) with my custom names.

I created new NamingStrategy class with foreignKeyColumnName() method but without efect to resultant foreign key names.

I see in log that my NamingStrategy is used (Using com.anect.rmt.utils.CustomNamingStrategy as naming strategy).

I use Hibernate 3.3.1 with JPA.

Here is my configuration of ANT task:

Code:

       <hibernatetool destdir="${output.schema.dir}">  
          <classpath refid="classpathDefault" />
          <annotationconfiguration configurationfile="hibernate.cfg.xml " namingstrategy="com.anect.rmt.utils.CustomNamingStrategy" />  
          <hbm2ddl  
              drop="true"  
              create="true"  
              export="false"  
              outputfilename="schema-ddl.sql"  
              delimiter=";"  
              format="true"/>  
      </hibernatetool>  

I have also used jpaconfiguration but with the same result. I can change table names for example but not foreign keys.

Please what's wrong?

Thank you in advance,
PETER

max · **Posted:** Thu Sep 25, 2008 6:02 pm

foreignKeyColumnName does not relate to foreign key names, but to the columns in the foreign keys.

jps26401 · **Joined:** Tue Mar 21, 2006 5:22 am **Posts:** 5

Oooh, good misunderstanding :(.

And is there possibility how to change foreign keys apart from @ForeignKey annotation?

@ForeignKey is good solution but not for this case:

Code:

public class BussinesValue {
  @ManyToOne(optional = false)
  @JoinColumn(name = "avail_level_id", nullable = false)  
  @ForeignKey(name = "avail_level_fk")
  private AvailabilityLevel availability;
  ...
}

Code:

public class Asset {
  @Embedded
  private BussinesValue value;
  ...
}

Code:

public class AssetGroup {
  @Embedded
  private BussinesValue value;
  ...
}

Then will be duplicate foreign key names in database...

Thank you in advance,
PETER

max · **Posted:** Fri Sep 26, 2008 12:57 pm

ask in annotations forum and if it is a bug report it in jra.