Hello everbody,

I have a problem in inserting data in database using hibernate,
Lets i explain total scenario of my problem,

I creates three tables in mysql database.

1) Category:
which has following fields.

-cid (int 6)(primary key,)
-cname (varchar 40) (NULL)
-description (varchar 100) (NULL)
-parentid (int 6) (NULL)

2)Test:
which has following fields.

-tid (bigint 15) (primary key,)
-cid (int 6) (references Category(cid)) (NULL)
-tname (varchar 40) (NULL)
-tdate (date) (NULL)
-duration (int 3) (NULL)
-totalmarks (int 3) (NULL)
-maxmarks (int 3) (NULL)
-uid (bigint 10) (NULL)
-criteria (varchar 100) (NULL)

3)Question:
which has following fields.

-id (bigint 15) (primary key,)
-qid (int 3) (NULL)
-tid (bigint 15) (references Test(tid)) (NULL)
-question (varchar 200) (NULL)
-option (varchar 300)
-answer (int 1)
-cid () (references Category(cid))


I am using NetBeans 6.8 IDE and tomacat server.
I ceates java web application with hibernate.
first i creates reverse engineering and then creates "Hibernate mapping files and POJOs from database"

please make one java package named as "pojos" and creates all pojos and hbm files in that package.


below is all pojo and hbm files..........

1)category.hbm :-

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Mar 26, 2011 11:04:10 PM by Hibernate Tools 3.2.1.GA -->
<hibernate-mapping>
<class name="pojos.Category" table="category" catalog="pre">
<id name="cid" type="java.lang.Integer">
<column name="cid" />
<generator class="assigned" />
</id>
<property name="cname" type="string">
<column name="cname" length="40" />
</property>
<property name="description" type="string">
<column name="description" length="100" />
</property>
<property name="parentid" type="java.lang.Integer">
<column name="parentid" />
</property>
<set name="questions" inverse="true">
<key>
<column name="cid" />
</key>
<one-to-many class="pojos.Question" />
</set>
<set name="tests" inverse="true">
<key>
<column name="cid" />
</key>
<one-to-many class="pojos.Test" />
</set>
</class>
</hibernate-mapping>
-----------------------------------------------------------------------------------------

2) test.hbm:-

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Mar 26, 2011 11:04:10 PM by Hibernate Tools 3.2.1.GA -->
<hibernate-mapping>
<class name="pojos.Test" table="test" catalog="pre">
<id name="tid" type="java.lang.Long">
<column name="tid" />
<generator class="assigned" />
</id>
<many-to-one name="category" class="pojos.Category" fetch="select">
<column name="cid" />
</many-to-one>
<property name="tname" type="string">
<column name="tname" length="40" />
</property>
<property name="tdate" type="date">
<column name="tdate" length="10" />
</property>
<property name="duration" type="java.lang.Integer">
<column name="duration" />
</property>
<property name="totalmarks" type="java.lang.Integer">
<column name="totalmarks" />
</property>
<property name="maxmarks" type="java.lang.Integer">
<column name="maxmarks" />
</property>
<property name="uid" type="java.lang.Long">
<column name="uid" />
</property>
<property name="criteria" type="string">
<column name="criteria" length="100" />
</property>
<set name="questions" inverse="true">
<key>
<column name="tid" />
</key>
<one-to-many class="pojos.Question" />
</set>
<set name="questions_1" inverse="true">
<key>
<column name="tid" />
</key>
<one-to-many class="pojos.Question" />
</set>
</class>
</hibernate-mapping>

------------------------------------------------------------------------------------------

3) question.hbm

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Mar 26, 2011 11:04:10 PM by Hibernate Tools 3.2.1.GA -->
<hibernate-mapping>
<class name="pojos.Question" table="question" catalog="pre">
<id name="id" type="java.lang.Long">
<column name="id" />
<generator class="assigned" />
</id>
<many-to-one name="test" class="pojos.Test" fetch="select">
<column name="tid" />
</many-to-one>
<many-to-one name="category" class="pojos.Category" fetch="select">
<column name="cid" />
</many-to-one>
<property name="qid" type="java.lang.Integer">
<column name="qid" />
</property>
<property name="que" type="string">
<column name="que" length="200" />
</property>
<property name="option" type="string">
<column name="option" length="300" />
</property>
<property name="answer" type="java.lang.Integer">
<column name="answer" />
</property>
</class>
</hibernate-mapping>
------------------------------------------------------------------------------------------

below is all POJO files.....

1) Category.java :-

package pojos;

import java.util.HashSet;
import java.util.Set;

public class Category implements java.io.Serializable {


private Integer cid;
private String cname;
private String description;
private Integer parentid;
private Set<Question> questions = new HashSet<Question>(0);
private Set<Test> tests = new HashSet<Test>(0);

public Category() {
}

public Category(String cname, String description, Integer parentid, Set<Question> questions, Set<Test> tests) {
this.cname = cname;
this.description = description;
this.parentid = parentid;
this.questions = questions;
this.tests = tests;
}

public Integer getCid() {
return this.cid;
}

public void setCid(Integer cid) {
this.cid = cid;
}
public String getCname() {
return this.cname;
}

public void setCname(String cname) {
this.cname = cname;
}
public String getDescription() {
return this.description;
}

public void setDescription(String description) {
this.description = description;
}
public Integer getParentid() {
return this.parentid;
}

public void setParentid(Integer parentid) {
this.parentid = parentid;
}
public Set<Question> getQuestions() {
return this.questions;
}

public void setQuestions(Set<Question> questions) {
this.questions = questions;
}
public Set<Test> getTests() {
return this.tests;
}

public void setTests(Set<Test> tests) {
this.tests = tests;
}
}


------------------------------------------------------------------------------------------

2) Test.java :-

package pojos;

import java.util.Date;
import java.util.HashSet;
import java.util.Set;

public class Test implements java.io.Serializable {

private Long tid;
private Category category;
private String tname;
private Date tdate;
private Integer duration;
private Integer totalmarks;
private Integer maxmarks;
private Long uid;
private String criteria;
private Set<Question> questions = new HashSet<Question>(0);
private Set<Question> questions_1 = new HashSet<Question>(0);

public Test() {
}

public Test(Category category, String tname, Date tdate, Integer duration, Integer totalmarks, Integer maxmarks, Long uid, String criteria, Set<Question> questions, Set<Question> questions_1) {
this.category = category;
this.tname = tname;
this.tdate = tdate;
this.duration = duration;
this.totalmarks = totalmarks;
this.maxmarks = maxmarks;
this.uid = uid;
this.criteria = criteria;
this.questions = questions;
this.questions_1 = questions_1;
}

public Long getTid() {
return this.tid;
}

public void setTid(Long tid) {
this.tid = tid;
}
public Category getCategory() {
return this.category;
}

public void setCategory(Category category) {
this.category = category;
}
public String getTname() {
return this.tname;
}

public void setTname(String tname) {
this.tname = tname;
}
public Date getTdate() {
return this.tdate;
}

public void setTdate(Date tdate) {
this.tdate = tdate;
}
public Integer getDuration() {
return this.duration;
}

public void setDuration(Integer duration) {
this.duration = duration;
}
public Integer getTotalmarks() {
return this.totalmarks;
}

public void setTotalmarks(Integer totalmarks) {
this.totalmarks = totalmarks;
}
public Integer getMaxmarks() {
return this.maxmarks;
}

public void setMaxmarks(Integer maxmarks) {
this.maxmarks = maxmarks;
}
public Long getUid() {
return this.uid;
}

public void setUid(Long uid) {
this.uid = uid;
}
public String getCriteria() {
return this.criteria;
}

public void setCriteria(String criteria) {
this.criteria = criteria;
}
public Set<Question> getQuestions() {
return this.questions;
}

public void setQuestions(Set<Question> questions) {
this.questions = questions;
}
public Set<Question> getQuestions_1() {
return this.questions_1;
}

public void setQuestions_1(Set<Question> questions_1) {
this.questions_1 = questions_1;
}
}


-----------------------------------------------------------------------------------------

3) Question.java :-

package pojos;

public class Question implements java.io.Serializable {

private Long id;
private Test test;
private Category category;
private Integer qid;
private String que;
private String option;
private Integer answer;

public Question() {
}

public Question(Test test, Category category, Integer qid, String que, String option, Integer answer) {
this.test = test;
this.category = category;
this.qid = qid;
this.que = que;
this.option = option;
this.answer = answer;
}

public Long getId() {
return this.id;
}

public void setId(Long id) {
this.id = id;
}
public Test getTest() {
return this.test;
}

public void setTest(Test test) {
this.test = test;
}
public Category getCategory() {
return this.category;
}

public void setCategory(Category category) {
this.category = category;
}
public Integer getQid() {
return this.qid;
}

public void setQid(Integer qid) {
this.qid = qid;
}
public String getQue() {
return this.que;
}

public void setQue(String que) {
this.que = que;
}
public String getOption() {
return this.option;
}

public void setOption(String option) {
this.option = option;
}
public Integer getAnswer() {
return this.answer;
}

public void setAnswer(Integer answer) {
this.answer = answer;
}
}


------------------------------------------------------------------------------------------



now I created one package named as "servlets" and make one servlet as "addQuestionData".

below is that servlet "addQuestionData.java"



package servlets;

import java.io.IOException;
import java.io.PrintWriter;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import manager.DbManager;
import pojos.Category;
import pojos.Question;
import pojos.Test;


public class addQuestionData extends HttpServlet {


protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
try {

Date date = new Date();
DateFormat df= new SimpleDateFormat("yyyy-MM-dd");
df.format(date);

Category c = new Category();
c.setCid(9);
c.setCname("Gate-2010");
c.setDescription("Entrace exam for MTech");
c.setParentid(0);

Test t = new Test();
t.setTid((long)4);
t.setCategory(c);
t.setTname("Test1");
t.setTdate(date);
t.setDuration(300);
t.setTotalmarks(300);
t.setMaxmarks(0);
t.setUid((long)1);
t.setCriteria("300:1:1;");

Question q = new Question();
q.setQid(1);
q.setTest(t);
q.setQue("What is your name ?");
q.setOption("jayesh:patrix:priyanka:pruthika");
q.setAnswer(1);
q.setCategory(c);

if(DbManager.saveQuestionData(q))
{
out.print("<h1>Question added sucessfully</h1>");
}
else
{
out.print("<h1>Some error occurs</h1>");
}

}catch(Exception ex){
ex.printStackTrace();
}
finally {
out.close();
}
}

// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/**
* Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}

/**
* Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}

/**
* Returns a short description of the servlet.
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return "Short description";
}// </editor-fold>

}
------------------------------------------------------------------------------------------

then I creates one another package named as "manager" and make one class in it named as "DbManager.java"

below is that "DbManager.java"




package manager;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import pojos.Question;

public class DbManager {

public static boolean saveQuestionData(Question q)
{
Session s=null;
try{
SessionFactory sf= new Configuration().configure().buildSessionFactory();
s=sf.openSession();
Transaction tx=s.beginTransaction();

s.save(q);
tx.commit();

return true;

}catch(Exception ex){
ex.printStackTrace();
}
finally{
s.close();
return false;
}

}

}
-----------------------------------------------------------------------------------------




Now my problem is that after run the servlet , it cant insert the data in database.

so please help me any body to solve this problem,

thanks

Please post error stack trace

I got solution of my problem,

Here I am using option word as a field of table which is keyword of java,
thats why it gives error to insert data in database,

So many persons view my post but no body gives reply to my post.

any way thanks...............