Session and Transaction

oren · **Joined:** Wed Mar 03, 2004 6:38 am **Posts:** 26

Hi,

Code:

Session s = sessionFactory.openSession();
Transaction t = s.beginTransaction();
...

Do i need to close the session after committing the Transaction?

I want to make sure i have new Session for each call.

emmanuel · **Posted:** Wed Mar 17, 2004 11:26 am

You must close any opened session. It has a JDBC connection underneath

oren · **Joined:** Wed Mar 03, 2004 6:38 am **Posts:** 26

emmanuel wrote:

You must close any opened session. It has a JDBC connection underneath

I know, but i wasn't sure if trans.commit(); is closing session.

Thanks

anthony · **Posted:** Wed Mar 17, 2004 11:31 am

what architecture do you have?
using struts for example?

oren · **Joined:** Wed Mar 03, 2004 6:38 am **Posts:** 26

delpouve wrote:

what architecture do you have?
using struts for example?

struts actions --> delegate class --> db layer

I don't want to manage sessions in servlet because in the future we my change it to:

struts action--> delegate class --> ejb --> db layer

anthony · **Posted:** Wed Mar 17, 2004 11:42 am

http://www.hibernate.org/43.html

if you don't want to use a servlet filter, no problen you can reuse threadlocal concept, it's very usefull to manage sessions.

oren · **Joined:** Wed Mar 03, 2004 6:38 am **Posts:** 26

delpouve wrote:

http://www.hibernate.org/43.html

if you don't want to use a servlet filter, no problen you can reuse threadlocal concept, it's very usefull to manage sessions.

I used threadlocal but had some session problems so i decided to open new session in every db layer method.

I am not sure i found yet the right solution to the session management.

I have problems when i try to work with objects that have childs.

When i try for example to save an object that holds a collection of other objects i get exceptions about session etc.

anthony · **Posted:** Wed Mar 17, 2004 11:58 am

were you doing this:

get session from threadlocal (via static method)
session. find, query.list .... for example
modifying your persistent objects
comit

or:
get session from threadlocal (via static method)
session. find, query.list .... for example
session.disconnect or close
modifying your persistent objects
getting the session again
commit

?
[/b]

oren · **Joined:** Wed Mar 03, 2004 6:38 am **Posts:** 26

delpouve wrote:

were you doing this:

get session from threadlocal (via static method)
session. find, query.list .... for example
modifying your persistent objects
comit

or:
get session from threadlocal (via static method)
session. find, query.list .... for example
session.disconnect or close
modifying your persistent objects
getting the session again
commit

?
[/b]

The first

Code:

Session s = sessionFactory.openSession();
Transaction t = s.beginTransaction();
s.save(object);
s.close();

object holds collection of childs. If i don't set inverse="true" in the map decleration i get an exception. The problem is that in this way the childs are not saved so i need to save them my self.

emmanuel · **Posted:** Wed Mar 17, 2004 1:10 pm

Inverse="true" is not related at all with cascading.
use caascade="save-update"

oren · **Joined:** Wed Mar 03, 2004 6:38 am **Posts:** 26

emmanuel wrote:

Inverse="true" is not related at all with cascading.
use caascade="save-update"

Well i don't know, I saw somwhere that i must set it to true when working with one-to-many relation. So what the purpose of inverse?

I tried setting caascade to "all" but still childs were not saved.

anthony · **Posted:** Wed Mar 17, 2004 4:22 pm

http://www.hibernate.org/155.html

oren · **Joined:** Wed Mar 03, 2004 6:38 am **Posts:** 26

delpouve wrote:

http://www.hibernate.org/155.html

Thanks for your efforts

anthony · **Posted:** Thu Mar 18, 2004 4:35 am

hope this helped you

Anthony