I want to create several tables in my module to add its in database. At first I created table UserRiskFactors without fields rang and isApproved, and then added its.
Table UserRiskFactors with rows rang and isApproved was created is MySQL. But I get some strange error: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ‘rang’ in ‘field list’
My module’s code is below:
> <?xml version="1.0"?>
<class name="org.openmrs.module.hyphothesisnet.UserRiskFactors" table="risk"> <cache usage="read-write"/> <id name="userRiskFactorId" type="java.lang.Integer" column="user_risk_factor_id" unsaved-value="0"> <generator class="native"> <param name="sequence">user_risk_factor_id_seq</param> </generator> </id> <property name="uuid" type="java.lang.String" column="uuid" length="38" unique="true"/> <property name="rang" type="java.lang.Integer" column="rang"/> <property name="isApproved" type="java.lang.Boolean" column="isApproved"/> <many-to-one name="risk" class="org.openmrs.module.hyphothesisnet.Risk" column="risk_id" /> <many-to-one name="factor" class="org.openmrs.module.hyphothesisnet.Factor" column="factor_id" /> <many-to-one name="kbResult" class="org.openmrs.module.hyphothesisnet.KBResult" column="kbResult_id" /> </class>
package org.openmrs.module.hyphothesisnet;
import com.fasterxml.jackson.annotation.JsonIdentityInfo;
import com.fasterxml.jackson.annotation.ObjectIdGenerators;
import org.hibernate.search.annotations.DocumentId;
import org.openmrs.BaseOpenmrsObject;
import javax.persistence.Column;
import java.io.Serializable;
@JsonIdentityInfo(generator = ObjectIdGenerators.IntSequenceGenerator.class, property = "@id")
public class UserRiskFactors extends BaseOpenmrsObject implements Serializable {
private static final long serialVersionUID = 8873867396395387714L;
@DocumentId
protected Integer userRiskFactorId;
private Risk risk;
private Factor factor;
private KBResult kbResult;
private Integer rang;
private Boolean isApproved;
public static long getSerialVersionUID() {
return serialVersionUID;
}
public Integer getUserRiskFactorId() {
return userRiskFactorId;
}
public void setUserRiskFactorId(Integer userRiskFactorId) {
this.userRiskFactorId = userRiskFactorId;
}
@Override
public void setId(Integer id) {
setUserRiskFactorId(id);
}
@Override
public Integer getId() {
return getUserRiskFactorId();
}
public Risk getRisk() {
return risk;
}
public void setRisk(Risk risk) {
this.risk = risk;
}
public Factor getFactor() {
return factor;
}
public void setFactor(Factor factor) {
this.factor = factor;
}
public KBResult getKbResult() {
return kbResult;
}
public void setKbResult(KBResult kbResult) {
this.kbResult = kbResult;
}
public Integer getRang() {
return rang;
}
public void setRang(Integer rang) {
this.rang = rang;
}
public Boolean getIsApproved() {
return isApproved;
}
public void setIsApproved(Boolean approved) {
isApproved = approved;
}
}