[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-5041) @ManyToOne not working with @Formula

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5041?page=c... ] Sharath Reddy closed HHH-5041. ------------------------------ Resolution: Won't Fix Correct Mapping: @Entity @Table(name="product") public class Product implements Serializable { private static final long serialVersionUID = 6956478993159505828L; @Id public Integer id; @Column(name="product_idnf", length=18, nullable=false, unique=true, columnDefinition="char(18)") public String productIdnf; @Column(name="description", nullable=false) public String description; @ManyToOne @JoinColumnsOrFormulas( { @JoinColumnOrFormula(formula=@JoinFormula(value="SUBSTR(product_idnf, 1, 3)", referencedColumnName="product_idnf")) }) @Fetch(FetchMode.JOIN) private Product productFamily; public Product getProductFamily() { return productFamily; } } And this is the test case I ran: public void testFailing() throws Exception { Session s = openSession(); Transaction tx = s.beginTransaction(); Product kit = new Product(); kit.id = 1; kit.productIdnf = "KIT"; kit.description = "Kit"; s.persist(kit); Product kitkat = new Product(); kitkat.id = 2; kitkat.productIdnf = "KIT_KAT"; kitkat.description = "Chocolate"; s.persist(kitkat); s.flush(); s.clear(); kit = (Product) s.get(Product.class, 1); kitkat = (Product) s.get(Product.class, 2); System.out.println(kitkat.description); assertNotNull(kitkat); assertEquals(kit, kitkat.getProductFamily()); assertEquals(kit.productIdnf, kitkat.getProductFamily().productIdnf); assertEquals("KIT_KAT", kitkat.productIdnf.trim()); assertEquals("Chocolate", kitkat.description.trim()); tx.rollback(); s.close(); } -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira