java.lang.NullPointerException at org.hibernate.tuple.entity.AbstractEntityTuplizer.getPropertyValue (Object Relational Mapping forum at Coderanch)

Post by: kaleeswaran Gounder , Greenhorn

May 21, 2013 21:53:51

I am having an object called Customer, It will have a relationship with address object (one-to-one relation) and Tickets object (one-to-many relation). [Each customer can have many tickets]. And Each ticket will have a payment object (One-to-one relation). I specified the relation in hibernate annotation.

I am getting the below error when executing the test,

Hibernate: insert into TestDB.customer (name, registrationDate) values (?, ?)
Hibernate: insert into TestDB.tickets (accessories, comments, uid, problem, problemFiledDate, repairTye, status, statusChangedDate) values (?, ?, ?, ?, ?, ?, ?, ?)
Exception in thread "main" java.lang.NullPointerException
at org.hibernate.tuple.entity.AbstractEntityTuplizer.getPropertyValue(AbstractEntityTuplizer.java:521)
at org.hibernate.persister.entity.AbstractEntityPersister.getPropertyValue(AbstractEntityPersister.java:3867)
at org.hibernate.id.ForeignGenerator.generate(ForeignGenerator.java:100)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:121)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:117)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:685)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:677)
at org.hibernate.engine.CascadingAction$5.cascade(CascadingAction.java:252)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:392)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:335)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:204)
at org.hibernate.engine.Cascade.cascade(Cascade.java:161)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:475)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:353)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:203)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:129)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:117)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:685)
at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:677)
at org.hibernate.engine.CascadingAction$5.cascade(CascadingAction.java:252)
at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:392)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:335)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:204)
at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:425)
at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:362)
at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:338)
at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:204)
at org.hibernate.engine.Cascade.cascade(Cascade.java:161)
at org.hibernate.event.def.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:475)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:353)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:203)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:129)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:713)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:701)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:697)
at com.test.CustomerRunWithTicketsWithPay.saveCustomer(CustomerRunWithTicketsWithPay.java:83)
at com.test.CustomerRunWithTicketsWithPay.main(CustomerRunWithTicketsWithPay.java:22)

My Application code is

My objects, Customer :

package com.test.model;
import static javax.persistence.GenerationType.IDENTITY;
@Entity
@Table(name = "customer", catalog = "mkyongTestDB")
public class Customer implements java.io.Serializable {
private Integer uid;
private String name;
private Date registrationDate;
private Address address;
private List<Tickets> tickets = new ArrayList<Tickets>();
public Customer() {
}
public Customer(Integer uid, String name, Date registrationDate,
Address address) {
super();
this.uid = uid;
this.name = name;
this.registrationDate = registrationDate;
this.address = address;
}
@Id
@GeneratedValue(strategy = IDENTITY)
@Column(name = "uid", unique = true, nullable = false)
public Integer getUid() {
return uid;
}
public void setUid(Integer uid) {
this.uid = uid;
}
@OneToOne(fetch = FetchType.LAZY, mappedBy = "customer", cascade = CascadeType.ALL)
public Address getAddress() {
return address;
}
public void setAddress(Address address) {
this.address = address;
}
@OneToMany(fetch = FetchType.LAZY, mappedBy = "customer", cascade = CascadeType.ALL)
public List<Tickets> getTickets() {
return tickets;
}
public void setTickets(List<Tickets> tickets) {
this.tickets = tickets;
}
@Column(nullable = false)
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
@Temporal(TemporalType.DATE)
@Column(nullable = false, length = 10)
public Date getRegistrationDate() {
return registrationDate;
}
public void setRegistrationDate(Date registrationDate) {
this.registrationDate = registrationDate;
}
}

Address :

package com.test.model;
import javax.persistence.Column;
@Entity
@Table(name = "address", catalog = "mkyongTestDB")
public class Address implements java.io.Serializable {
private Integer uid;
private Integer phoneNumber;
private String street;
private String city;
private String country;
private Customer customer;
public Address() {
}
public Address(Integer uid, String street, String city, String country) {
this.uid = uid;
this.street = street;
this.city = city;
this.country = country;
}
@GenericGenerator(name = "generator", strategy = "foreign", parameters = @Parameter(name = "property", value = "customer"))
@Id
@GeneratedValue(generator = "generator")
@Column(unique = true, nullable = false)
public Integer getUid() {
return uid;
}
public void setUid(Integer uid) {
this.uid = uid;
}
@OneToOne(fetch = FetchType.LAZY)
@PrimaryKeyJoinColumn
public Customer getCustomer() {
return customer;
}
public void setCustomer(Customer customer) {
this.customer = customer;
}
public String getStreet() {
return street;
}
@Column(nullable = false, length = 100)
public void setStreet(String street) {
this.street = street;
}
public String getCity() {
return city;
}
public void setCity(String city) {
this.city = city;
}
public String getCountry() {
return country;
}
public void setCountry(String country) {
this.country = country;
}
@Column(unique = true, nullable = false, length = 10)
public Integer getPhoneNumber() {
return phoneNumber;
}
public void setPhoneNumber(Integer phoneNumber) {
this.phoneNumber = phoneNumber;
}
@Override
public String toString() {
return "Address [id=" + uid + ", street=" + street + ", city=" + city
+ ", country=" + country + "]";
}
}

Tickets :

package com.test.model;
import static javax.persistence.GenerationType.IDENTITY;
@Entity
@Table(name = "tickets", catalog = "mkyongTestDB")
public class Tickets implements java.io.Serializable {
private Integer ticketId;
private String problem;
private Date problemFiledDate;
private String accessories;
private String comments;
private String repairTye; // office, home
private Date statusChangedDate;
private String status; //open, in-progress, fixed, deferred ... tobe-fixed, in-progress, fixed
private Customer customer;
private Payment payment;
@Id
@GeneratedValue(strategy = IDENTITY)
@Column(unique = true, nullable = false)
public Integer getTicketId() {
return ticketId;
}
public void setTicketId(Integer ticketId) {
this.ticketId = ticketId;
}
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "uid", nullable = false)
public Customer getCustomer() {
return customer;
}
public void setCustomer(Customer customer) {
this.customer = customer;
}
@OneToOne(fetch = FetchType.LAZY, mappedBy = "ticket", cascade = CascadeType.ALL)
public Payment getPayment() {
return payment;
}
public void setPayment(Payment payment) {
this.payment = payment;
}
@Column(nullable = false)
public String getProblem() {
return problem;
}
public void setProblem(String problem) {
this.problem = problem;
}
@Temporal(TemporalType.DATE)
@Column(nullable = false, length = 10)
public Date getProblemFiledDate() {
return problemFiledDate;
}
public void setProblemFiledDate(Date problemFiledDate) {
this.problemFiledDate = problemFiledDate;
}
public String getAccessories() {
return accessories;
}
public void setAccessories(String accessories) {
this.accessories = accessories;
}
public String getComments() {
return comments;
}
public void setComments(String comments) {
this.comments = comments;
}
@Column(nullable = false)
public String getRepairTye() {
return repairTye;
}
public void setRepairTye(String repairTye) {
this.repairTye = repairTye;
}
@Temporal(TemporalType.DATE)
@Column(nullable = false, length = 10)
public Date getStatusChangedDate() {
return statusChangedDate;
}
public void setStatusChangedDate(Date statusChangedDate) {
this.statusChangedDate = statusChangedDate;
}
public String getStatus() {
return status;
}
public void setStatus(String status) {
this.status = status;
}
@Override
public String toString() {
return "Tickets [ticketId=" + ticketId + ", problem=" + problem
+ ", problemFiledDate=" + problemFiledDate + ", accessories="
+ accessories + ", comments=" + comments + ", repairTye="
+ repairTye + ", statusChangedDate=" + statusChangedDate
+ ", status=" + status + ", customer=" + customer + "]";
}
}

Payment :

package com.test.model;
import java.util.Date;
@Entity
@Table(name = "payment", catalog = "mkyongTestDB")
public class Payment implements java.io.Serializable {
private Integer pid;
private Integer amount;
private String staus;
private Date paymentDate;
private Tickets ticket;
public Payment() {
}
public Payment(Integer pid, Integer amount, String staus, Date paymentDate) {
this.pid = pid;
this.amount = amount;
this.staus = staus;
this.paymentDate = paymentDate;
}
@GenericGenerator(name = "generator", strategy = "foreign", parameters = @Parameter(name = "property", value = "tickets"))
@Id
@GeneratedValue(generator = "generator")
@Column(unique = true, nullable = false)
public Integer getPid() {
return pid;
}
public void setPid(Integer pid) {
this.pid = pid;
}
@OneToOne(fetch = FetchType.LAZY)
@PrimaryKeyJoinColumn
public Tickets getTicket() {
return ticket;
}
public void setTicket(Tickets ticket) {
this.ticket = ticket;
}
public Integer getAmount() {
return amount;
}
public void setAmount(Integer amount) {
this.amount = amount;
}
public String getStaus() {
return staus;
}
public void setStaus(String staus) {
this.staus = staus;
}
public Date getPaymentDate() {
return paymentDate;
}
public void setPaymentDate(Date paymentDate) {
this.paymentDate = paymentDate;
}
@Override
public String toString() {
return "Payment [pid=" + pid + ", amount=" + amount + ", staus="
+ staus + ", paymentDate=" + paymentDate + "]";
}
}
Test program is :
public int saveCustomer() {
Session session = HibernateUtil.getSessionFactory().openSession();
Transaction transaction = null;
int stockId = 0;
try {
transaction = session.beginTransaction();
Customer customer = new Customer();
customer.setName("testing");
customer.setRegistrationDate(new Date());
Address address = new Address();
address.setCity("CN");
address.setCountry("IN");
address.setStreet("CTM");
address.setPhoneNumber(90403);
// One to one relationship
customer.setAddress(address);
address.setCustomer(customer);
// One to many mapping
Tickets ticket = new Tickets();
ticket.setProblem("Not able to start the machine. ");
ticket.setRepairTye("office");
ticket.setProblemFiledDate(new Date());
ticket.setStatus("open");
ticket.setStatusChangedDate(new Date());
Payment payment = new Payment();
payment.setAmount(100);
payment.setPaymentDate(new Date());
payment.setStaus("not paid");
payment.setTicket(ticket);
ticket.setPayment(payment);
ticket.setCustomer(customer);
List<Tickets> tickets = new ArrayList<Tickets>();
tickets.add(ticket);
customer.setTickets(tickets);
stockId = (Integer) session.save(customer);
session.save(payment);
session.save(ticket);
transaction.commit();
} catch (HibernateException e) {
transaction.rollback();
e.printStackTrace();
} finally {
session.close();
}
return stockId;
}

Hibernate Configuration is :

Where am i wrong in this code ?

Screen-Shot-2013-05-22-at-9.23.01-AM.png

Relationship Diagram

Post by: kaleeswaran Gounder , Greenhorn

May 31, 2013 01:33:21

I found the answer, The mistake is on the below line of Payment POJO.

@GenericGenerator(name = "generator", strategy = "foreign", parameters = @Parameter(name = "property", value = "tickets"))

Here I specified like value = "tickets" which is invalid in this mapping. I have to specify like value = "ticket". This fixed it.

Post by:autobot

Space pants. Tiny ad:

Why should you try IntelliJ IDEA ?

https://coderanch.com/wiki/696337/IntelliJ-IDEA