Hi

I am using createSQLQuery to fetch a list of objects. The objects does not exist in the database, the query is used to get the attributes for instantiating the loaded objects.
This works fine - the objects are in my list.

However the objects are not persisted. The objects are loaded into the list and into the session, but hibernate does not persist them.
I guess hibernate thinks that the objects are persisted since they where loaded from tha database, but that is not the case. Thus calling persist(), saveOrUpdate() or save() does not do anything.

If I try to instantiate a new objects based the fetched list and persist these objects - then hibernate complains that the objects are already in the session.

A workaround is to do a session.delete and session.persist. This will delete the objects from the session (and the database, but they where never in the database) and thus I can persist the objects again - this time also into the database.

My question is - is this:
Objects loaded by createSQLQuery are in the session, but not necessarily persisted - is this correct hibernate behavior?

/Tage

PS: Hibernate 3 - Oracle 9

As long as the objects are created in the same session that executes the query, the objects should get persisted.

Can you post the code snippet where you are facing this problem?

regards,
~Vinayak

Exactly, but the table in the database remains empty.


Fetching the list by:
List rels = session.createSQLQuery(
"select " +
"est.stamklasseidfk AS {FagholdxStamklasse.stamklasseId}, " +
"fxe.fagholdidfk AS {FagholdxStamklasse.fagholdId}, " +
"count(UNIQUE fxe.elevidfk) AS {FagholdxStamklasse.gyldig} " +
"from " +
"elevxstamklasse est " +
"LEFT JOIN fagholdxelev fxe on est.elevidfk = fxe.elevidfk " +
"group by est.stamklasseidfk, fxe.fagholdidfk")
.addEntity("FagholdxStamklasse", FagholdxStamklasse.class)
.list();

I guess this somehow should be sufficient to persist the "FagholdxStamklasse"-objects , but they do not get persisted.

Maybe the explanation is pretty simple. The objects have just been loaded - albeit via a query - and hibernate assumes that the objects are persisted since the values retreived are from the database.

The caveat is that the objects haven't been loaded as hibernate assumes.

Or am I complete off here?

/Tage