Simple ?set? mapping for one column type string table

myfamcdevmanager · **Posted:** Wed Jul 23, 2008 12:37 pm

I've a simple class for Foo:
public class Foo {
private Integer fooId;
private String division;
private Context context;
}
public class Context{
private Integer contextId;
private String description;
}

Now the kicker is that division in Foo is in a table called divisions that have one column in it called division of type string. I don’t want to create a class called division just to be able to map it like I did context but I do want Hibernate to “enforce” that the division is contained in the divisions table. Is there anyway to do this?

<hibernate-mapping>
<class name="Foo" table="Foo">
<id name="fooId" type="java.lang.Integer">
<column name="Foo_ID" />
<generator class="assigned" /></generator>
</id>
<property name="description" type="com.famc.model.hibernate.StringTrim">
<column name="Description" length="50" not-null="true" />
</property>
<many-to-one name="context" column="context_id" lazy="false"/>
</class>
<class name=" WorkflowContext" table="CONTEXT">
<id name="contextId" type="java.lang.Integer">
<column name="CONTEXT_ID" />
<generator class="assigned" />
</id>
<property name="description" type="java.lang.String">
<column name="Description" length="50" not-null="true" />
</property>
</class>

</hibernate-mapping>

Cameron McKenzie · **Posted:** Fri Jul 25, 2008 3:42 am

Couldn't you just do a secondary talbe mapping?

Essentially, that allows you to map one class to properties in two tables.

Mapping one Class to Two Tables

Code:

package com.examscam.mappings;
import javax.persistence.*;import org.hibernate.Session;
import com.examscam.HibernateUtil;

@Entity
@Table(name="bar")
@SecondaryTable(name="foo")
public class FooBar {
  int id;
  String fooName;
  String barCode;

  @Id
  @GeneratedValue
  public int getId() {return id;}
  public void setId(int id) {this.id = id;}

  @Column(table="foo")
  public String getFooName() {return fooName;}
  public void setFooName(String fooName) {
    this.fooName = fooName;
  }

  /* no need for mapping-goes to default bar table */
  public String getBarCode() {return barCode;}
  public void setBarCode(String barCode) {
    this.barCode = barCode;
  }

  public static void main(String args[]) {
/*HibernateUtil needs FooBar.class in AnnotationConfiguration*/
    HibernateUtil.recreateDatabase();
    FooBar fb = new FooBar();
    fb.setBarCode("90210");
    fb.setFooName("ManChu");
     Session session = HibernateUtil.beginTransaction();
    session.save(fb);
    HibernateUtil.commitTransaction();
  }
}