Как настроить Hibernate на правильное создание типа в таблице?

Question

[Maks Burkov]

В таблице company_coupons создаётся Coupon_Title типа BIGINT FK на Coupon , ТОГДА КАК в таблице Coupons создаётся Coupon_Title типа VARCHAR .. После чего имею проблемму с Insert ..
Как настроить хибернейт на правильное создание ?

@OneToMany
    @JoinTable(name = "company_coupons" , joinColumns = @JoinColumn(name = "COMPANY_ID") , inverseJoinColumns = {@JoinColumn(name = "COUPON_ID"), @JoinColumn(name = "COUPON_TITLE")})
    private Collection<Coupon> company_coupons;

Answer 1

[Eugene Khrustalev]

Покажите класс Coupon

Comments

[Maks Burkov]

@Entity
@Table(name = "coupons")
public class Coupon implements Serializable{

    public Company getCompany() {
        return company;
    }

    public void setCompany(Company company) {
        this.company = company;
    }

    @Transient
    private Company company;

    @Id
    @Column(name = "COUPON_ID")
    @Size(min = 5, max = 20 , message = "Coupon id must be 5-20! ")
    private long id;

    @Column(name = "COUPON_TITLE" , unique = true)
    @Size(min = 10, max = 20 , message = "Coupon title must be 10-20! ")
    private String title;

    @Temporal(TemporalType.DATE)
    @Column(name = "RELEASE_DATE")
    @Pattern(regexp = "^(\\d{4})-(\\d{2})-(\\d{2})$",
            message = "Wrong date format! Correct example: YYYY-MM-DD")
    private Date startDate;

    @Temporal(TemporalType.DATE)
    @Column(name = "EXPIRATION_DATE")
    @Pattern(regexp = "^(\\d{4})-(\\d{2})-(\\d{2})$",
            message = "Wrong date format! Correct example: YYYY-MM-DD" )
    private Date endDate;

    @Column(name = "COUPON_AMOUNT")
    private int amount;
    @Column(name = "COUPON_MESSAGE")
    @Size(min = 10, max = 30 , message = "Coupon message must be 10-30! ")
    private String message;
    @Column(name = "COUPON_PRICE")
    private double price;

    @Column(name = "COUPON_IMAGE")
    @Pattern(regexp = "([^\\s]+(\\.(?i)(jpg|png|gif|bmp))$)",
            message = "Wrong image url! Correct examples: " +
                    "1. “a.jpg”, “a.gif”,”a.png”, “a.bmp”,\n" +
                    "2. “..jpg”, “..gif”,”..png”, “..bmp”,\n" +
                    "3. “a.JPG”, “a.GIF”,”a.PNG”, “a.BMP”,\n" +
                    "4. “a.JpG”, “a.GiF”,”a.PnG”, “a.BmP”,\n" +
                    "5. “jpg.jpg”, “gif.gif”,”png.png”, “bmp.bmp”")
    private String image;

    @Column(name = "COUPON_TYPE")
    @Enumerated(EnumType.STRING)
    @NotBlank(message = "Coupon type can't be empty! ")
    private CouponType type;


    @Override
    public boolean equals(Object o) {
        if (this == o) return true;
        if (o == null || getClass() != o.getClass()) return false;

        Coupon coupon = (Coupon) o;

        if (id != coupon.id) return false;
        if (amount != coupon.amount) return false;
        if (Double.compare(coupon.price, price) != 0) return false;
        if (!title.equals(coupon.title)) return false;
        if (!startDate.equals(coupon.startDate)) return false;
        if (!endDate.equals(coupon.endDate)) return false;
        if (!message.equals(coupon.message)) return false;
        if (!image.equals(coupon.image)) return false;
        return type == coupon.type;
    }

    @Override
    public int hashCode() {
        int result;
        long temp;
        result = (int) (id ^ (id >>> 32));
        result = 31 * result + title.hashCode();
        result = 31 * result + startDate.hashCode();
        result = 31 * result + endDate.hashCode();
        result = 31 * result + amount;
        result = 31 * result + message.hashCode();
        temp = Double.doubleToLongBits(price);
        result = 31 * result + (int) (temp ^ (temp >>> 32));
        result = 31 * result + image.hashCode();
        result = 31 * result + type.hashCode();
        return result;
    }

    public Coupon() {}

    public long getId() {
        return id;
    }

    public void setId(long id) {
        this.id = id;

    }

    public String getTitle() {
        return title;
    }

    public void setTitle(String title) {
        this.title = title;

    }

    public Date getStartDate() {
        return startDate;
    }

    public void setStartDate(Date startDate) {
        this.startDate = startDate;
    }

    public Date getEndDate() {
        return endDate;
    }

    public void setEndDate(Date endDate) {
        this.endDate = endDate;

    }

    public int getAmount() {
        return amount;
    }

    public void setAmount(int amount) {
        this.amount = amount;

    }

    public String getMessage() {
        return message;
    }

    public void setMessage(String message) {
        this.message = message;

    }

    public double getPrice() {
        return price;
    }

    public void setPrice(double price) {
        this.price = price;

    }

    public String getImage() {
        return image;
    }

    public void setImage(String image) {
        this.image = image;

    }

    public CouponType getType() {
        return type;
    }

    public void setType(CouponType type) {
        this.type = type;

    }

    @Override
    public String toString() {
        return "Coupon [id=" + id + ", title=" + title + ", startDate=" + startDate + ", endDate=" + endDate
                + ", amount=" + amount + ", message=" + message + ", price=" + price + ", image=" + image + ", type="
                + type + "]";
    }
}