java.lang.NullPointerException at org.hibernate.tuple.entity.AbstractEntityTuplizer.getPropertyValue

[kaleeswaran Gounder]

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 :

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
	<session-factory>
	 	<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
		<property name="hibernate.connection.url">jdbc:mysql://0.0.0.0:8889/TestDB</property>
		<property name="hibernate.connection.username">java</property>
		<property name="hibernate.connection.password">java</property>
		<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
		<property name="hbm2ddl.auto">create</property>
		<property name="show_sql">true</property>
		<mapping class="com.test.model.Customer" />
		<mapping class="com.test.model.Address" />
		<mapping class="com.test.model.Tickets" />
		<mapping class="com.test.model.Payment" />
	</session-factory>
</hibernate-configuration>

Where am i wrong in this code ?

[kaleeswaran Gounder]

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.