@ManyToOne @JoinColumnOrFormula(formula=@JoinFormula(value="UPPER(lang_code)")) //@JoinColumnOrFormula(formula=@JoinFormula(value="(select l.code from Language l where l.name = lang_name)")) public Language getLanguage() { return language; } public void setLanguage(Language language) {
@Entity( name = "A" ) @Table( name = "A" ) public static class A { @Id @Column( name = "idA") public Integer id; @OneToMany @JoinColumnOrFormula(formula = @JoinFormula(value = "idA", referencedColumnName = "idA")) Set<D> ds = new HashSet<D>(); }
@ManyToOne @JoinColumnOrFormula(column = @JoinColumn(name = "CDT_MDL_CODE", referencedColumnName = "MDL_CODE")) @JoinColumnOrFormula(formula = @JoinFormula(value = "CDT_MFG_CODE", referencedColumnName = "MDL_MFG_CODE")) @JoinColumnOrFormula(formula = @JoinFormula(value = "CDT_COMPANY_CODE", referencedColumnName = "MDL_COMPANY_CODE")) public Model getModel() { return model; }
@ManyToOne @JoinColumnOrFormula(column=@JoinColumn(name="order_nbr", referencedColumnName="order_nbr")) @JoinColumnOrFormula(formula=@JoinFormula(value="'F'", referencedColumnName="is_default")) public Menu getOrder() { return order; }
@ManyToOne @JoinColumnOrFormula(column = @JoinColumn(name = "CDT_MFG_CODE", referencedColumnName = "MFG_CODE")) @JoinColumnOrFormula(formula = @JoinFormula(value = "CDT_COMPANY_CODE", referencedColumnName = "MFG_COMPANY_CODE")) public Manufacturer getManufacturer() { return manufacturer; }
@ManyToOne @JoinColumnOrFormula(column=@JoinColumn(name="id", referencedColumnName="company_id", updatable=false, insertable=false)) @JoinColumnOrFormula(formula=@JoinFormula(value="'T'", referencedColumnName="is_default")) public Person getDefaultContactPerson() { return person; } public void setDefaultContactPerson(Person person) {
@JoinFormula( "REGEXP_REPLACE(phoneNumber, '\\+(\\d+)-.*', '\\1')::int" ) private Country country;
@JoinFormula(value="SUBSTRING(product_idnf, 1, 3)", referencedColumnName="product_idnf") @Fetch(FetchMode.JOIN)
@Entity(name = "Stock") public static class Stock implements Serializable { @Id @Column(name = "ID") private Long id; @ManyToOne(fetch = FetchType.LAZY) @JoinColumnOrFormula(column = @JoinColumn(name = "CODE_ID", referencedColumnName = "ID")) @JoinColumnOrFormula(formula = @JoinFormula(referencedColumnName = "TYPE", value = "'TYPE_A'")) private StockCode code; public Long getId() { return id; } public void setId(Long id) { this.id = id; } public StockCode getCode() { return code; } public void setCode(StockCode code) { this.code = code; } }
@Entity(name = "Stock") public static class Stock implements Serializable { @Id @Column(name = "ID") private Long id; @ManyToOne(fetch = FetchType.LAZY) @NotFound(action = NotFoundAction.IGNORE) @JoinColumnOrFormula(column = @JoinColumn(name = "CODE_ID", referencedColumnName = "ID")) @JoinColumnOrFormula(formula = @JoinFormula(referencedColumnName = "TYPE", value = "'TYPE_A'")) private StockCode code; public Long getId() { return id; } public void setId(Long id) { this.id = id; } public StockCode getCode() { return code; } public void setCode(StockCode code) { this.code = code; } }
@Entity(name = "Stock") public static class Stock implements Serializable { @Id @Column(name = "ID") private Long id; @OneToOne(fetch = FetchType.LAZY) @NotFound(action = NotFoundAction.IGNORE) @JoinColumnOrFormula(column = @JoinColumn(name = "CODE_ID", referencedColumnName = "ID")) @JoinColumnOrFormula(formula = @JoinFormula(referencedColumnName = "TYPE", value = "'TYPE_A'")) private StockCode code; public Long getId() { return id; } public void setId(Long id) { this.id = id; } public StockCode getCode() { return code; } public void setCode(StockCode code) { this.code = code; } }
@JoinFormula( value = "true", referencedColumnName = "is_default"
@JoinFormula("(" + "SELECT pc.id " + "FROM post_comment pc " +
@JoinFormula( "REGEXP_REPLACE(locale, '\\w+_(\\w+)[_]?', '\\1')" ) private Country country; @JoinFormula( "REGEXP_REPLACE(locale, '(\\w+)_.*', '\\1')" ) private Language language;
@JoinFormula( "(select c.code from Country c where UPPER(c.code) = UPPER(countryCode))" ) private Country country;
@JoinFormula( "( " + " SELECT prev_salary.id " +