Environment: Container managed transactions

Problem:

Firstly a query is done returning several beans. The query has the readonly attribute set to true

Next a bean is retrieved which is cached in the previous query.

The bean is changed but fails to update to DB as the readonly attirbute has been set to true when the query was done.

Question:
Is there a way to change the status of the bean to be updated or can I remove the bean from cache prior to retrieving the bean for update.

I'm not sure I follow here. Are you wanting to update a read only bean? Or is the "update" done inside the database and you want to re-read?

Beans can be removed from the current session via the evict method on the session object.

http://www.hibernate.org/hib_docs/v3/ap ... ssion.html

Is that what you want?

HI I want the "update" done after the re-read. I tried the following:

Ran a query (for validation) with read only true

Iterated thru the result set and retrieving each bean in list

Called session.evict(bean) on each bean retrieved

Re-read (using FindById) the bean to be updated (this bean was one of the results returned in the query)

Changed bean properties

This still didn't update to the DB even though the session.evict was called it is still re-using the same bean from the query call.