Hi,

I am currently experiencing an issue using hibernate-tools 3.2.4.GA.

Consider following snippet



when i call methodA twice in a loop, I'm getting weird results. Ex: say for 1st call, resultset should contain ObjectA and for 2nd call resultset should contain ObjectB. What happens in my loop is: For first call i get the result correctly, but for second call i get (ObjectA + ObjectB) instead of only ObjectB.

I have been able to resolve this, using:


But I am wondering wether I missed any configuration which would have allowed me to use getCurrentSession().

Also, performance-wise what impact would this be having if I am to open a new session for each call?

Can anyone help please??

Generally, the usage of opensession() is not recommended since it opens a new session that needs manual closure since this comes away from spring or container managed sessions.

However opencurrentsession() asks the container to get the session that is already open and is the current session in use. Using this is highly recommended!

But can you let me know the query details which gives you such result sets. And can you let me know the content in your db that results in this output?

Thanks
Priya
Myblog: [url="http://javaprogrammingtips4u.blogspot.com"]Spring/Hibernate tips[/url]

Hi Priya,

Thanks for the reply. My queries are basic hibernate select statements.

Ex:



Now consider the following calls being made under one transaction:

Transaction 1
MethodA is executed once with userId = 3
ResultSet is User("xxx") is returned


Transaction 2
MethodA is executed once with userId = 5
ResultSet is User("yyy") is returned

Transaction 3
MethodA is executed twice, once with userId = 3 and then with userId = 5
ResultSet is User("xxx") is returned for first call
For Second Call, instead of User("yyy") being returned, User("xxx") and User("yyy") are returned.


The only ways the I have been able to resolve this is through openming a new session for each call, or perform each call under a seperate transaction.

I wanted to do each call under the same transaction but without having to open a new session each time. Can anyone help?