Tuesday, 27 August 2013

Could not load an entity in hibernate

Could not load an entity in hibernate

Can any one tell me why I'm getting this exception in my project.
org.hibernate.exception.GenericJDBCException: could not load an entity:
[com.expo.esf.model.HouseBL#22344]
I can save records to database but whenever i try to load the entity for
edit. it shows the above message.
Below is the entity definition:
package com.expo.esf.model;
import java.util.Date;
import java.util.List;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;
import javax.persistence.Transient;
/**
*
* @author tanvir.rahman
*
*/
@Entity
@Table(name = "invoice_house")
public class InvoiceHouse extends BaseModel {
@Id
@GeneratedValue
@Column(name = "id")
private Long id;
@JoinColumn(name = "company_id", referencedColumnName = "id")
@ManyToOne
private Company company;
@JoinColumn(name = "carrier_mode_id", referencedColumnName = "id")
@ManyToOne
private CarrierMode carrierMode;
@JoinColumn(name = "inv_type_id", referencedColumnName = "id")
@ManyToOne
private InvoiceType invType;
@Column(name = "invoice_no")
private String invoiceNo;
@JoinColumn(name = "house_id", referencedColumnName = "id")
@ManyToOne
private HouseBL houseBL;
@Column(name = "ref_invoice_no")
private String refInvoiceNo;
@Column(name = "debit_credit_no")
private String debitCreditNo;
@JoinColumn(name = "shipper_id", referencedColumnName = "id")
@ManyToOne
private Shipper shipper;
@JoinColumn(name = "consignee_id", referencedColumnName = "id")
@ManyToOne
private Consignee consignee;
@JoinColumn(name = "buying_house_id", referencedColumnName = "id")
@ManyToOne
private BuyingHouse buyingHouse;
@Column(name = "inv_open_date")
private Date invOpenDate;
@Column(name = "inv_issue_date")
private Date invIssueDate;
@JoinColumn(name = "currency_id", referencedColumnName = "id")
@ManyToOne
private Currency currency;
@Column(name = "exchange_rate")
private float exchangeRate;
@JoinColumn(name = "issued_user_id", referencedColumnName = "id")
@ManyToOne
private User user;
@Column(name = "total_inv_amount")
private float totalInvAmount;
@Column(name = "total_cost_amount")
private float totalCostAmount;
@Column(name = "profit")
private float profit;
@Column(name = "status_id")
private long status;
@Column(name = "total_debitcredit_amount")
private float totalDebitCreditAmount;
@Column(name = "reff_inv_tamount")
private float reffInvTamount;
@Column(name = "diff_amount")
private float diffAmount;
@Column(name = "description", length = 500)
private String description;
@Column(name = "authorization_remarks", length = 500)
private String authorizationRemarks;
@Column(name = "authorized_by", length = 128)
private String authorizedBy;
private boolean authorized;
@Transient
private String houseBlNo;
@Transient
private String exchangeRateStr;
@Transient
private String partyType;
@Transient
private String button;
@Transient
private List<ShipmentChargeDetails> houseChargeDetailsList;
@Transient
private List<ShipmentChargeDetails> houseCostDetailsList;
@Transient
private List<InvoiceHouseDetails> invoiceHouseChargeDetailsList;
@Transient
private List<InvoiceHouseDetails> invoiceHouseCostDetailsList;
@Transient
private List<InvoiceHouseDetails> invoiceHouseDetailsList;
@Transient
private String errorCharge;
@Transient
private String errorCost;
public List<ShipmentChargeDetails> getHouseChargeDetailsList() {
return houseChargeDetailsList;
}
public void setHouseChargeDetailsList(List<ShipmentChargeDetails>
houseChargeDetailsList) {
this.houseChargeDetailsList = houseChargeDetailsList;
}
public InvoiceHouse() {
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public Company getCompany() {
return company;
}
public void setCompany(Company company) {
this.company = company;
}
public CarrierMode getCarrierMode() {
return carrierMode;
}
public void setCarrierMode(CarrierMode carrierMode) {
this.carrierMode = carrierMode;
}
public InvoiceType getInvType() {
return invType;
}
public void setInvType(InvoiceType invType) {
this.invType = invType;
}
public String getInvoiceNo() {
return invoiceNo;
}
public void setInvoiceNo(String invoiceNo) {
this.invoiceNo = invoiceNo;
}
public HouseBL getHouseBL() {
return houseBL;
}
public void setHouseBL(HouseBL houseBL) {
this.houseBL = houseBL;
}
public String getRefInvoiceNo() {
return refInvoiceNo;
}
public void setRefInvoiceNo(String refInvoiceNo) {
this.refInvoiceNo = refInvoiceNo;
}
public String getDebitCreditNo() {
return debitCreditNo;
}
public void setDebitCreditNo(String debitCreditNo) {
this.debitCreditNo = debitCreditNo;
}
public Shipper getShipper() {
return shipper;
}
public void setShipper(Shipper shipper) {
this.shipper = shipper;
}
public Consignee getConsignee() {
return consignee;
}
public void setConsignee(Consignee consignee) {
this.consignee = consignee;
}
public BuyingHouse getBuyingHouse() {
return buyingHouse;
}
public void setBuyingHouse(BuyingHouse buyingHouse) {
this.buyingHouse = buyingHouse;
}
public Date getInvOpenDate() {
return invOpenDate;
}
public void setInvOpenDate(Date invOpenDate) {
this.invOpenDate = invOpenDate;
}
public Date getInvIssueDate() {
return invIssueDate;
}
public void setInvIssueDate(Date invIssueDate) {
this.invIssueDate = invIssueDate;
}
public Currency getCurrency() {
return currency;
}
public void setCurrency(Currency currency) {
this.currency = currency;
}
public float getExchangeRate() {
return exchangeRate;
}
public void setExchangeRate(float exchangeRate) {
this.exchangeRate = exchangeRate;
}
public User getUser() {
return user;
}
public void setUser(User user) {
this.user = user;
}
public float getTotalInvAmount() {
return totalInvAmount;
}
public void setTotalInvAmount(float totalInvAmount) {
this.totalInvAmount = totalInvAmount;
}
public float getTotalCostAmount() {
return totalCostAmount;
}
public void setTotalCostAmount(float totalCostAmount) {
this.totalCostAmount = totalCostAmount;
}
public float getProfit() {
return profit;
}
public void setProfit(float profit) {
this.profit = profit;
}
public long getStatus() {
return status;
}
public void setStatus(long status) {
this.status = status;
}
public float getTotalDebitCreditAmount() {
return totalDebitCreditAmount;
}
public void setTotalDebitCreditAmount(float totalDebitCreditAmount) {
this.totalDebitCreditAmount = totalDebitCreditAmount;
}
public float getReffInvTamount() {
return reffInvTamount;
}
public void setReffInvTamount(float reffInvTamount) {
this.reffInvTamount = reffInvTamount;
}
public float getDiffAmount() {
return diffAmount;
}
public void setDiffAmount(float diffAmount) {
this.diffAmount = diffAmount;
}
public String getDescription() {
return description;
}
public void setDescription(String description) {
this.description = description;
}
public String getHouseBlNo() {
return houseBlNo;
}
public void setHouseBlNo(String houseBlNo) {
this.houseBlNo = houseBlNo;
}
public String getExchangeRateStr() {
return exchangeRateStr;
}
public void setExchangeRateStr(String exchangeRateStr) {
this.exchangeRateStr = exchangeRateStr;
}
public String getPartyType() {
return partyType;
}
public void setPartyType(String partyType) {
this.partyType = partyType;
}
public String getButton() {
return button;
}
public void setButton(String button) {
this.button = button;
}
public List<ShipmentChargeDetails> getHouseCostDetailsList() {
return houseCostDetailsList;
}
public void setHouseCostDetailsList(
List<ShipmentChargeDetails> houseCostDetailsList) {
this.houseCostDetailsList = houseCostDetailsList;
}
public List<InvoiceHouseDetails> getInvoiceHouseChargeDetailsList() {
return invoiceHouseChargeDetailsList;
}
public void setInvoiceHouseChargeDetailsList(
List<InvoiceHouseDetails> invoiceHouseChargeDetailsList) {
this.invoiceHouseChargeDetailsList = invoiceHouseChargeDetailsList;
}
public List<InvoiceHouseDetails> getInvoiceHouseCostDetailsList() {
return invoiceHouseCostDetailsList;
}
public void setInvoiceHouseCostDetailsList(
List<InvoiceHouseDetails> invoiceHouseCostDetailsList) {
this.invoiceHouseCostDetailsList = invoiceHouseCostDetailsList;
}
public List<InvoiceHouseDetails> getInvoiceHouseDetailsList() {
return invoiceHouseDetailsList;
}
public void setInvoiceHouseDetailsList(
List<InvoiceHouseDetails> invoiceHouseDetailsList) {
this.invoiceHouseDetailsList = invoiceHouseDetailsList;
}
public String getErrorCharge() {
return errorCharge;
}
public void setErrorCharge(String errorCharge) {
this.errorCharge = errorCharge;
}
public String getErrorCost() {
return errorCost;
}
public void setErrorCost(String errorCost) {
this.errorCost = errorCost;
}
public String getAuthorizationRemarks() {
return authorizationRemarks;
}
public void setAuthorizationRemarks(String authorizationRemarks) {
this.authorizationRemarks = authorizationRemarks;
}
public boolean isAuthorized() {
return authorized;
}
public void setAuthorized(boolean authorized) {
this.authorized = authorized;
}
public String getAuthorizedBy() {
return authorizedBy;
}
public void setAuthorizedBy(String authorizedBy) {
this.authorizedBy = authorizedBy;
}
}
}
Below is the method in which i'm getting error:
@Override
public InvoiceHouse getInvoiceHouse(long invoiceHouseId) {
InvoiceHouse invoiceHouse = null;
Query query = em.createQuery(" FROM InvoiceHouse ih WHERE ih.id =
:invoiceHouseId ");
query.setParameter("invoiceHouseId", invoiceHouseId);
try {
invoiceHouse = (InvoiceHouse) query.getSingleResult();
} catch (Exception e) {
log.debug("Error in getInvoiceHouse()------> "+e.getMessage());
}
return invoiceHouse;
}
Table definition:
Name Null? Type
ID NOT NULL NUMBER(19)
CREATED_BY VARCHAR2(128 CHAR)
CREATED_DATE TIMESTAMP(6)
UPDATED_BY VARCHAR2(128 CHAR)
UPDATED_DATE TIMESTAMP(6)
VERSION NOT NULL NUMBER(10)
DEBIT_CREDIT_NO VARCHAR2(255 CHAR)
DESCRIPTION VARCHAR2(500 CHAR)
DIFF_AMOUNT FLOAT(126)
EXCHANGE_RATE FLOAT(126)
INV_ISSUE_DATE TIMESTAMP(6)
INV_OPEN_DATE TIMESTAMP(6)
INVOICE_NO VARCHAR2(255 CHAR)
PROFIT FLOAT(126)
REF_INVOICE_NO VARCHAR2(255 CHAR)
REFF_INV_TAMOUNT FLOAT(126)
STATUS_ID NUMBER(19)
TOTAL_COST_AMOUNT FLOAT(126)
TOTAL_DEBITCREDIT_AMOUNT FLOAT(126)
TOTAL_INV_AMOUNT FLOAT(126)
BUYING_HOUSE_ID NUMBER(19)
CARRIER_MODE_ID NUMBER(19)
COMPANY_ID NUMBER(19)
CONSIGNEE_ID NUMBER(19)
CURRENCY_ID NUMBER(19)
HOUSE_ID NUMBER(19)
INV_TYPE_ID NUMBER(19)
SHIPPER_ID NUMBER(19)
ISSUED_USER_ID NUMBER(19)
AUTHORIZATION_REMARKS VARCHAR2(500 CHAR)
AUTHORIZED NUMBER(1)
AUTHORIZED_BY VARCHAR2(128 CHAR)

No comments:

Post a Comment