org.hibernate.TransactionException: Transaction not successf

suzie · **Joined:** Fri Nov 03, 2006 4:57 pm **Posts:** 60

why do I get the following error when I execute this method:

private void updatePerson(Long personId, String firstname) {

Session session = HibernateUtil.getSessionFactory().getCurrentSession();

session.beginTransaction();

Person aPerson = (Person) session.load(Person.class, personId);

aPerson.setFirstname(firstname);
session.update(aPerson);
session.save(aPerson);

session.getTransaction().commit();
}

exception

org.hibernate.TransactionException: Transaction not successfully started
org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:149)
events.PersonServlet.doGet(Unknown Source)
javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

batmat · **Posted:** Sun Dec 17, 2006 2:32 am

* Which line does throw this exception?
* Please use the code tags so as to make your posts more readable.

suzie · **Joined:** Fri Nov 03, 2006 4:57 pm **Posts:** 60

here is the code that calls this method and throws the exception:

protected void doGet(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {

//SimpleDateFormat dateFormatter = new SimpleDateFormat("dd.MM.yyyy");

try {
// Begin unit of work
//HibernateUtil.getSessionFactory()
// .getCurrentSession().beginTransaction();

// Write HTML header
PrintWriter out = response.getWriter();
out.println("<html><head><title>Event Manager</title></head><body>");

// Handle actions
if ( "addemailtoperson".equals(request.getParameter("action")) ) {

Long eventTitle = Long.parseLong(request.getParameter("eventTitle"));
String eventDate = request.getParameter("eventDate");

if ( "".equals(eventTitle) || "".equals(eventDate) ) {
out.println("Please enter event title and date.");
} else {
//createAndStoreEvent(eventTitle, dateFormatter.parse(eventDate));
addEmailToPerson(eventTitle, eventDate);
out.println("Added event.");
}
}

// Print page
printEventForm(out);
listEvents(out);

// Write HTML footer
out.println("</body></html>");
out.flush();
out.close();

// End unit of work
//HibernateUtil.getSessionFactory()
// .getCurrentSession().getTransaction().commit();

} catch (Exception ex) {
HibernateUtil.getSessionFactory()
.getCurrentSession().getTransaction().rollback();
throw new ServletException(ex);
}
}

suzie · **Joined:** Fri Nov 03, 2006 4:57 pm **Posts:** 60

here is the code that calls this method and throws the exception:

protected void doGet(HttpServletRequest request,
HttpServletResponse response)
throws ServletException, IOException {

//SimpleDateFormat dateFormatter = new SimpleDateFormat("dd.MM.yyyy");

try {
// Begin unit of work
HibernateUtil.getSessionFactory()
.getCurrentSession().beginTransaction();

// Write HTML header
PrintWriter out = response.getWriter();
out.println("<html><head><title>Event Manager</title></head><body>");

// Handle actions
if ( "addemailtoperson".equals(request.getParameter("action")) ) {

Long eventTitle = Long.parseLong(request.getParameter("eventTitle"));
String eventDate = request.getParameter("eventDate");

if ( "".equals(eventTitle) || "".equals(eventDate) ) {
out.println("Please enter event title and date.");
} else {
//createAndStoreEvent(eventTitle, dateFormatter.parse(eventDate));
addEmailToPerson(eventTitle, eventDate);
out.println("Added event.");
}
}

// Print page
printEventForm(out);
listEvents(out);

// Write HTML footer
out.println("</body></html>");
out.flush();
out.close();

// End unit of work
HibernateUtil.getSessionFactory()
.getCurrentSession().getTransaction().commit();

} catch (Exception ex) {
HibernateUtil.getSessionFactory()
.getCurrentSession().getTransaction().rollback();
throw new ServletException(ex);
}
}

suzie · **Joined:** Fri Nov 03, 2006 4:57 pm **Posts:** 60

the problem was that i was beginning and commiting my transaction once in my method and once in my doGet method of my servlet.

suzie · **Joined:** Fri Nov 03, 2006 4:57 pm **Posts:** 60

I have list of items in my jsp pages and that are being generated by the following code
and I want to be able to update multiple records if I change one my items in my list since
it is a text box and can be modified....and I want to be able to only update my items on
the list that have been checked with the check box:

suzie · **Joined:** Fri Nov 03, 2006 4:57 pm **Posts:** 60

have this field called status and you can enter anything in this field and it is not even required. but for some reason when I get data back from hibernate I get back the value "null" in my field.... why is this happening.. i am using hibernate to retrieve the data...