How to insert two tables in the DAO layer?

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

Hi everyone:

I want to insert two tables in one transaction . But I don't want to pass the transaction logic into DAO. And I also don't want to do this in my servlet. How to do it?[/url]

anthony · **Posted:** Thu Dec 16, 2004 4:02 am

what?
are you talking about insert table (insert into....) or persisting new instances? (session.save, session.create, or maybe dao.save)?

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

anthony wrote:

what?
are you talking about insert table (insert into....) or persisting new instances? (session.save, session.create, or maybe dao.save)?

Hi anthony

I use JTA Transaction.
But it can't insert data using the following code:

Code:

UserTransaction utx=......................

doInsertItem(item1);
doUpdateItem(item2);

utx.commit().
.......................................

The two method is:

Code:

public void doInsertItem(Object item){

  Session s=HibernateUtil.currentSession();
  s.save(item);
  HibernateUtil.closeSession();
}

public void doUpdateItem(Object item){

  Session s=HibernateUtil.currentSession();
  item.set.....
. .......................
  s.update(item);
  HibernateUtil.closeSession();
}

This method can't insert and update database.Why? If I commit transaction in two method,it can't be in the same transaction. How to do it correctly?
Thks[/code]

kamal_tavant · **Posted:** Thu Dec 16, 2004 7:14 am

Take a look at this.
http://hibernate.org/42.html