Object value not getting updated in the database using hibernate

Posted by user1662917 on Stack Overflow See other posts from Stack Overflow or by user1662917
Published on 2012-10-04T09:30:08Z Indexed on 2012/10/04 9:37 UTC
Read the original article Hit count: 149

Filed under:
|

I am using Spring,hibernate,jsf with jquery in my application. I am inserting a Question object in the database through the hibernate save query . The question object contains id ,question,answertype and reference to a form object using form_id. Now I want to alter the values of Question object stored in the database by altering the value stored in the list of Question objects at the specified index position. If I alter the value in the list the value in the database is not getting altered by update query . Could you please advise.

Question.java package com.otv.model;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;

import org.apache.commons.lang.builder.ToStringBuilder;

@Entity
@Table(name = "questions")
public class Question implements Serializable {

    @Id
    @GeneratedValue
    @Column(name = "id", unique = true, nullable = false)
    private int id;

    @Column(name = "question", nullable = false)
    private String text;

    @Column(name = "answertype", nullable = false)
    private String answertype;

    @ManyToOne(fetch = FetchType.EAGER)
    @JoinColumn(name = "form_id")
    private Form form;

    // @JoinColumn(name = "form_id")
    // private int formId;

    public Question() {
    }

    public Question(String text, String answertype) {
        this.text = text;
        this.answertype = answertype;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getQuestion() {
        return text;
    }

    public void setQuestion(String question) {

        this.text = question;
    }

    public String getAnswertype() {
        return answertype;
    }

    public void setAnswertype(String answertype) {
        this.answertype = answertype;
    }

    @Override
    public int hashCode() {
        final int prime = 31;
        int result = 1;
        result = prime * result + ((answertype == null) ? 0 : answertype.hashCode());
        result = prime * result + id;
        result = prime * result + ((text == null) ? 0 : text.hashCode());
        return result;
    }

    @Override
    public boolean equals(Object obj) {
        if (this == obj)
            return true;
        if (obj == null)
            return false;
        if (getClass() != obj.getClass())
            return false;
        Question other = (Question) obj;
        if (answertype == null) {
            if (other.answertype != null)
                return false;
        } else if (!answertype.equals(other.answertype))
            return false;
        if (id != other.id)
            return false;
        if (text == null) {
            if (other.text != null)
                return false;
        } else if (!text.equals(other.text))
            return false;
        return true;
    }

    public void setForm(Form form) {
        this.form = form;
    }

    @Override
    public String toString() {
        return ToStringBuilder.reflectionToString(this);
    }

}

Form.java

package com.otv.model;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;

import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.OneToMany;
import javax.persistence.Table;

import org.apache.commons.lang.builder.ToStringBuilder;

@Entity
@Table(name = "FORM")
public class Form implements Serializable {

    @Id
    @GeneratedValue
    @Column(name = "id", unique = true, nullable = false)
    private int id;

    @Column(name = "name", nullable = false)
    private String name;

    @Column(name = "description", nullable = false)
    private String description;

    @OneToMany(mappedBy = "form", fetch = FetchType.EAGER, cascade = CascadeType.ALL)
    List<Question> questions = new ArrayList<Question>();

    public Form(String name) {
        super();
        this.name = name;
    }

    public Form() {
        super();
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getDescription() {
        return description;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public List<Question> getQuestions() {
        return questions;
    }

    public void setQuestions(List<Question> formQuestions) {
        this.questions = formQuestions;
    }

    public void addQuestion(Question question) {
        questions.add(question);
        question.setForm(this);
    }

    public void removeQuestion(Question question) {
        questions.remove(question);
        question.setForm(this);
    }

    @Override
    public String toString() {
        return ToStringBuilder.reflectionToString(this);
    }

    public void replaceQuestion(int index, Question question) {
        Question prevQuestion = questions.get(index);
        // prevQuestion.setQuestion(question.getQuestion());
        // prevQuestion.setAnswertype(question.getAnswertype());
        question.setId(prevQuestion.getId());
        question.setForm(this);
        questions.set(index, question);
    }

}

QuestionDAO.java

package com.otv.user.dao;

import java.util.List;

import org.hibernate.SessionFactory;

import com.otv.model.Question;

public class QuestionDAO implements IQuestionDAO {

    private SessionFactory sessionFactory;

    public SessionFactory getSessionFactory() {
        return sessionFactory;
    }

    public void setSessionFactory(SessionFactory sessionFactory) {
        this.sessionFactory = sessionFactory;
    }

    public void addQuestion(Question question) {
        getSessionFactory().getCurrentSession().save(question);
    }

    public void deleteQuestion(Question question) {
        getSessionFactory().getCurrentSession().delete(question);
    }

    public void updateQuestion(Question question) {
        getSessionFactory().getCurrentSession().update(question);
    }

    public Question getQuestionById(int id) {
        List list = getSessionFactory().getCurrentSession().createQuery("from Questions where id=?")
                .setParameter(0, id).list();
        return (Question) list.get(0);
    }

}

© Stack Overflow or respective owner

Related posts about hibernate

Related posts about object