It is a blocker to upgrade Hibernate 3.1.3 to 5.1 for our up-gradation.

The current situstion is as follows:

> The classes hold a many-to-many relationship amongst themselves.

> They communicate between themselves using OSSJ_ASSOCIATION (SUPPORTINGID, SUPPORTEDBYID) table.

>This table is not related to any java entity class by design.

> The class, "ManagedEntityValueDB", is the super class which is inherited by all database related classes(like InternetServiceProviderValueDB which refers OSSJ_ISP table, PointOfInterconnectSpecificationValueDB which refers OSSJ_POI table, CMTSSpecificationValueDB which refers OSSJ_CMTS_SPEC table etc.) either directly or indirectly, to achieve this many-to-many relationship dynamically with the other classes.

// ManagedEntityValueDB.java
/**

• @hibernate.class abstract="true"
  */
  public class ManagedEntityValueDB extends AbstractPersistentObject implements PersistentManagedEntity {

private static final long serialVersionUID = 1L;

private static final Notifier log = Notifier.getNotifier(ManagedEntityValueDB.class);

private Set supportedByManagedEntities = new HashSet();
private Set supportingManagedEntities = new HashSet();
private String valueType;

/**

• @hibernate.set table="OSSJ_ASSOCIATION" cascade="none" fetch="join"
• @hibernate.collection-many-to-many class="dk.tdc.ossj.inventory.model.db.ManagedEntityValueDB"
• column="supportedByID"
• @hibernate.collection-key column="supportingID"
  */
  public Set getSupportedByManagedEntities() { return supportedByManagedEntities; }

public void setSupportedByManagedEntities(Set supportedByManagedEntities)

/**

• @hibernate.set table="OSSJ_ASSOCIATION" cascade="none" inverse="true"
• fetch="join"
• @hibernate.collection-many-to-many class="dk.tdc.ossj.inventory.model.db.ManagedEntityValueDB"
• column="supportingID"
• @hibernate.collection-key column="supportedByID"
  */
  public Set getSupportingManagedEntities() { return supportingManagedEntities; }

public void setSupportingManagedEntities(Set supportingManagedEntities)

public void addSupportingManagedEntity(ManagedEntityValueDB managedEntityValueDB)

/**

• @hibernate.property
  */
  public String getValueType() { return valueType; }

public void setValueType(String valueType)

…
}

//InternetServiceProviderValueDB.java
/**

• @hibernate.union-subclass abstract="false" table="OSSJ_ISP"
  */
  public class InternetServiceProviderValueDB extends PartyRoleValueDB implements PersistentManagedEntity {

private static final long serialVersionUID = 1L;
private String ispId;
private String name;
private String spec24Name;

/**

• @hibernate.property
  */
  public String getIspId() { return ispId; }

public void setIspId(String ispId)

/**

• @hibernate.property
  */
  public String getName() { return name; }
  
  public void setName(String name) { this.name = name; }
  /**
  * @hibernate.property
  */
  public String getSpec24Name() { return spec24Name; }
  
  public void setSpec24Name(String spec24Name) { this.spec24Name = spec24Name; }
  
  
  public void populateManagedEntityValue(ManagedEntityValue value) { super.populateManagedEntityValue(value); }
  public void populateManagedEntityValueNoParty(ManagedEntityValue value) { super.populateManagedEntityValueNoParty(value); }
  
  public void populatePersistentObject(ManagedEntityValue value) { super.populatePersistentObject(value); }
  
  public String toString() { return "Name = " + name + " - IspId = " + ispId + " - Spec24Name = " + spec24Name; }
  }
  
  //PointOfInterconnectValueDB.java
  /**
  * @hibernate.union-subclass abstract="false" table="OSSJ_POI"
  */
  public class PointOfInterconnectValueDB extends ResourceValueDB implements PersistentManagedEntity {
  
  private static final long serialVersionUID = 1L;
  private String type;
  private String name;
  private String qos;
  
  /**
  * @hibernate.property
  */
  public String getName() { return name; }

public void setName(String name)

/* (non-Javadoc)

• @see java.lang.Object#toString()
  */
  public String toString() { return "Name=" + name; }

  }

> Here is an option in our application, this many-to-many relationship can be created dynamically through "Entitier" link from its GUI.

E.g., To give an example, if we take up the relationship between POI-CMTS-ISP, CMTS is a supported by entity in the OSSJ_ASSOCIATION table, related to POI in supporting entity. Similarly, ISP is a supported by entity in the OSSJ_ASSOCIATION table, related to POI in supporting entity. So we can conclude that POI joins ISP and CMTS together.

> Xdoclet is using to generate *.hbm.xml

> As per hibernate 5.1, all entity classes should be annotated instead of hbm.xml.

What we are struggling with right now is to achieve the dynamic many-to-many relationship through the entity mapping and annotate them.

What we did before is to change all the annotation for all the classes that are there since one at a time change is not possible for that application as they are related to each other some way or the other and individual testing would not have been feasible. There were challenges in configuration as well which we overcame as we worked through. We didn't change any design in the whole class diagram. And we are totally stuck here in.