Update: I believe this is due to the object being recreated everytime it's referenced in the view. I thought when an object is referenced the first time it's created, and should stay alive in that session. Should I be setting a particular ScopeType or setting somewhere to stop this from happening?
----

I've been migrating a seam/hibernate app that used to use a MSSQL database in windows, over to linux and oracle.

For some reason after the switch to linux and oracle, the queries executed are being repeated over and over again in the JBoss log. It happened a little in windows as well, but it's gotten much worse in linux with oracle.

For instance, one view loads an object with 4 fields that's mapped to a table. There's one query that loads the object and displays it in a view. Yet the jboss log shows the INFO [STDOUT] Hibernate: <query here> executing 7 or more times.

Is there a reason for this? Is it really executing it that many times, or just relaying it that many times? Can someone point me in the right direction?

Thanks.

How are you retrieving your object?
When using get() or load() to retrieve the object via its id-field it should be loaded from the DB only once.
If you retrieve it by querying some other (non-id-)field the query will be executed each time because the persistence-context doesn#t know about query-results, only about entities and their ids.

This is actually in a xhtml view using JSF and seam tags. So I'm referencing fields like #{ObjectName.field} in the xhtml.