INFO [AWT-EventQueue-0] (CustomerImpl.java:72) - Query is "Select c from Customer c where c.paddleNumber = :paddleNumber "
INFO [AWT-EventQueue-0] (NullableType.java:182) - could not read column value from result set: PaddleN15_16_; No data found
The error is generated by this call .
Any help would be greatly appreciated.
import java.io.Serializable;
import java.util.Collection;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.OneToMany;
import javax.persistence.Table;
/**
*
* @author
*/
@Entity
@Table(name = "Customers", catalog = "", schema = "")
public class Customer implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@Column(name = "CustomerID")
private Integer customerID;
@Column(name = "LastName", length = 510)
private String lastName;
@Column(name = "FirstName", length = 510)
private String firstName;
@Column(name = "MiddleName", length = 510)
private String middleName;
@Column(name = "Title", length = 510)
private String title;
@Column(name = "PartnerLastName", length = 510)
private String partnerLastName;
@Column(name = "PartnerFirstName", length = 510)
private String partnerFirstName;
@Column(name = "PartnerMiddleName", length = 510)
private String partnerMiddleName;
@Column(name = "PartnerTitle", length = 510)
private String partnerTitle;
@Column(name = "PaddleNumber")
private Integer paddleNumber;
@Column(name = "TableNumber", length = 100)
private String tableNumber;
@Column(name = "Classification", length = 510)
private String classification;
@Column(name = "Sponsor", length = 510)
private String sponsor;
@Column(name = "IfExpress")
private Boolean ifExpress;
@Column(name = "Address1", length = 510)
private String address1;
@Column(name = "Address2", length = 510)
private String address2;
@Column(name = "City", length = 510)
private String city;
@Column(name = "Phone", length = 510)
private String phone;
@Column(name = "State", length = 510)
private String state;
@Column(name = "Zip", length = 510)
private String zip;
@Column(name = "Payment")
private Integer payment;
@Column(name = "Attendee1", length = 100)
private String attendee1;
@Column(name = "Attendee2", length = 100)
private String attendee2;
@Column(name = "Attendee3", length = 100)
private String attendee3;
@Column(name = "Email", length = 100)
private String email;
@Column(name = "Company", length = 200)
private String company;
@OneToMany(mappedBy = "customerID")
private Collection<Payments> paymentsCollection;
@OneToMany(mappedBy = "paddleNumber")
private Collection<NonCatalog> nonCatalogCollection;
@OneToMany(mappedBy = "customerID")
private Collection<Bids> bidsCollection;
public Customer() {
}
public Customer(Integer paddleNumber) {
this.paddleNumber = paddleNumber;
}
public Integer getCustomerID() {
return customerID;
}
public void setCustomerID(Integer customerID) {
this.customerID = customerID;
}
public String getLastName() {
return lastName;
}
public void setLastName(String lastName) {
this.lastName = lastName;
}
public String getFirstName() {
return firstName;
}
public void setFirstName(String firstName) {
this.firstName = firstName;
}
public String getMiddleName() {
return middleName;
}
public void setMiddleName(String middleName) {
this.middleName = middleName;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getPartnerLastName() {
return partnerLastName;
}
public void setPartnerLastName(String partnerLastName) {
this.partnerLastName = partnerLastName;
}
public String getPartnerFirstName() {
return partnerFirstName;
}
public void setPartnerFirstName(String partnerFirstName) {
this.partnerFirstName = partnerFirstName;
}
public String getPartnerMiddleName() {
return partnerMiddleName;
}
public void setPartnerMiddleName(String partnerMiddleName) {
this.partnerMiddleName = partnerMiddleName;
}
public String getPartnerTitle() {
return partnerTitle;
}
public void setPartnerTitle(String partnerTitle) {
this.partnerTitle = partnerTitle;
}
public Integer getPaddleNumber() {
return paddleNumber;
}
public void setPaddleNumber(Integer paddleNumber) {
this.paddleNumber = paddleNumber;
}
public String getTableNumber() {
return tableNumber;
}
public void setTableNumber(String tableNumber) {
this.tableNumber = tableNumber;
}
public String getClassification() {
return classification;
}
public void setClassification(String classification) {
this.classification = classification;
}
public String getSponsor() {
return sponsor;
}
public void setSponsor(String sponsor) {
this.sponsor = sponsor;
}
public Boolean getIfExpress() {
return ifExpress;
}
public void setIfExpress(Boolean ifExpress) {
this.ifExpress = ifExpress;
}
public String getAddress1() {
return address1;
}
public void setAddress1(String address1) {
this.address1 = address1;
}
public String getAddress2() {
return address2;
}
public void setAddress2(String address2) {
this.address2 = address2;
}
public String getCity() {
return city;
}
public void setCity(String city) {
this.city = city;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getState() {
return state;
}
public void setState(String state) {
this.state = state;
}
public String getZip() {
return zip;
}
public void setZip(String zip) {
this.zip = zip;
}
public Integer getPayment() {
return payment;
}
public void setPayment(Integer payment) {
this.payment = payment;
}
public String getAttendee1() {
return attendee1;
}
public void setAttendee1(String attendee1) {
this.attendee1 = attendee1;
}
public String getAttendee2() {
return attendee2;
}
public void setAttendee2(String attendee2) {
this.attendee2 = attendee2;
}
public String getAttendee3() {
return attendee3;
}
public void setAttendee3(String attendee3) {
this.attendee3 = attendee3;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getCompany() {
return company;
}
public void setCompany(String company) {
this.company = company;
}
public Collection<Payments> getPaymentsCollection() {
return paymentsCollection;
}
public void setPaymentsCollection(Collection<Payments> paymentsCollection) {
this.paymentsCollection = paymentsCollection;
}
public Collection<NonCatalog> getNonCatalogCollection() {
return nonCatalogCollection;
}
public void setNonCatalogCollection(Collection<NonCatalog> nonCatalogCollection) {
this.nonCatalogCollection = nonCatalogCollection;
}
public Collection<Bids> getBidsCollection() {
return bidsCollection;
}
public void setBidsCollection(Collection<Bids> bidsCollection) {
this.bidsCollection = bidsCollection;
}
@Override
public int hashCode() {
int hash = 0;
hash += (paddleNumber != null ? paddleNumber.hashCode() : 0);
return hash;
}
@Override
public boolean equals(Object object) {
// TODO: Warning - this method won't work in the case the id fields are not set
if (!(object instanceof Customer)) {
return false;
}
Customer other = (Customer) object;
if ((this.paddleNumber == null && other.paddleNumber != null) || (this.paddleNumber != null && !this.paddleNumber.equals(other.paddleNumber))) {
return false;
}
return true;
}
@Override
public String toString() {
return "com.az.auctionsync.model.Customer[paddleNumber=" + paddleNumber + "]";
}
}
Login
FAQ
Search