0

On server startup hibernate is altering table by adding new columns. When It prints in console that "schema update complete" table is altered.!

I have a table which has few fields of Number type. But when i am starting my tomcat from eclipse, hibernate is altering my table by adding new columns of same name of datatype float.

What is the root cause behind this

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name = "EPAMRT_BUC_COSTS_ARRAY") 
public class EPAMRTBucCostArray {

@Id
@GeneratedValue
private Integer BUC_COSTS_ARRAY_ID;
@Column(name= "BUC_CODE")
private String BUC_CODE;  
@Column(name= "BUC_DESC")
private String BUC_DESC;   
@Column(name= "BUC_AMOUNT")
private BigDecimal BUC_AMOUNT;  
@Column(name= "MTD_BUC")
private BigDecimal MTD_BUC;   
@Column(name= "YTD_BUC")
private BigDecimal YTD_BUC;  
@Column(name= "UNAMRT_BUC")
private BigDecimal UNAMRT_BUC;

public Integer getBUC_COSTS_ARRAY_ID() {
    return BUC_COSTS_ARRAY_ID;
}
public void setBUC_COSTS_ARRAY_ID(Integer bUC_COSTS_ARRAY_ID) {
    BUC_COSTS_ARRAY_ID = bUC_COSTS_ARRAY_ID;
}
public String getBUC_CODE() {
    return BUC_CODE;
}
public void setBUC_CODE(String bUC_CODE) {
    BUC_CODE = bUC_CODE;
}
public String getBUC_DESC() {
    return BUC_DESC;
}
public void setBUC_DESC(String bUC_DESC) {
    BUC_DESC = bUC_DESC;
}

public BigDecimal getBUC_AMOUNT() {
    return BUC_AMOUNT;
}
public void setBUC_AMOUNT(BigDecimal bUC_AMOUNT) {
    BUC_AMOUNT = bUC_AMOUNT;
}
public BigDecimal getMTD_BUC() {
    return MTD_BUC;
}
public void setMTD_BUC(BigDecimal mTD_BUC) {
    MTD_BUC = mTD_BUC;
}
public BigDecimal getYTD_BUC() {
    return YTD_BUC;
}
public void setYTD_BUC(BigDecimal yTD_BUC) {
    YTD_BUC = yTD_BUC;
}
public BigDecimal getUNAMRT_BUC() {
    return UNAMRT_BUC;
}
public void setUNAMRT_BUC(BigDecimal uNAMRT_BUC) {
    UNAMRT_BUC = uNAMRT_BUC;
}
}

when the schema update is completed there are 4 columns which are getting added are MTD_BUC, YTD_BUC, UNAMRT_BUC and BUC_DESC

previously my table was:

  • BUC_COSTS_ARRAY_ID NUMBER(22 , 0),
  • BUC_CODE VARCHAR2(10),
  • BUC_DESC VARCHAR2(30),
  • BUC_AMOUNT NUMBER(22 , 0),
  • MTD_BUC NUMBER(22 , 0),
  • YTD_BUC NUMBER(22 , 0),
  • UNAMRT_BUC NUMBER(22 , 0)

Modified by hibernate:

  • BUC_COSTS_ARRAY_ID NUMBER(22 , 0),
  • BUC_CODE VARCHAR2(10),
  • BUC_DESC VARCHAR2(30),
  • BUC_AMOUNT NUMBER(22 , 0),
  • MTD_BUC NUMBER(22 , 0),
  • YTD_BUC NUMBER(22 , 0),
  • UNAMRT_BUC NUMBER(22 , 0)
  • BUC_DESC VARCHAR2(255),
  • MTD_BUC NUMBER(19 , 2),
  • UNAMRT_BUC NUMBER(19 , 2),
  • YTD_BUC NUMBER(19 , 2)
Anup Mondal
  • 47
  • 1
  • 8

0 Answers0