Hi Folks,

I'm developing a web application using Hibernate. During the scope of a single Hibernate Session & Transaction, objects may be created, persisted and subsequently queried for (using hql). This last bit presents a problem, since at the point these objects are queried for the session has not yet been flushed thus the hql query returns nothing.

Is there some way in which I can include these un-flushed objects, sitting in the Hibernate Session, in my hql queries?

Cheers,
Richard.

Hibernate version:

3.2.6

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

After having a read through some of the previous posts on this forum, it looks like it's expected functionality for Hibernate NOT to search it's cache for unflushed objects. This is something that we most certainly need to do, so does anyone have any recommendations for how this should be done?

The standard aproach would be to configure Hibernate to flush before query. (search the docs for FlushMode). If this doesn't work for you you are pretty much on your own.

Thanks for your reply. I'd kind of figured we were probably going to be on our own!

I think we're going to have to implement our own Session, which looks at the cache before performing a query against the db.

Cheers.