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.

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 ?

Hi,
I am also having same problem....Help me..

Thanks..

I am new to struts2... I designed a page in plain html.. now i have use this html page in struts2 project.. how can i convert html field elements to Struts2 ui tags ??? My html page looks like:
<tr>
<td class="style4">**Customer Name***</td>
<td><input type="text" name="Scr_Inq_CName" class="body-fieldsTextFields" id="Scr_Inq_CName_id" tabindex="4" onkeypress="return CommonKeyPressIsAlpha(event);"/></td>
</tr>

I have assigned style(style4) to a label "Customer name" and style(body-fieldsTextFields) to text box.

When i use Struts-tag

When i see this page in firebug.
It displays text field with style(body-fieldsTextFields) applied, When i run project... But Customer name label is displayed in separate row <tr><td>Customer name</td></tr>.

And text field is displayed in below table row <tr>.

how to apply style4 to Customer name label and body-fieldsTextFields style to all textfields and also how can i make both label and text field to be displayed in same row ???

Thanks..