Seam/hibernate issuing lots of selects

[tanyaka]

Hi, I am porting a Seam 2.2.2 based app from JBoss 4.2.3 to 5.1.0 and have ran into a problem with a dataTable. On 4.2.3 when a row in the table is clicked a few sql statements are issued and the row is rendered. When doing the same thing on 5.1.0 however, hundreds of selects are issued which grinds the app to a halt. I suspect it has got something to do with the way seam and hibernate interact since hibernate is the only thing that has changed really in terms of database access when moving JBoss versions. Has anyone else seen anything like this and found a solution?

[cyberanto]

My first suspicion would be that your action method is called mutiple times - check that first. If so, there may be ways in the page to ensure the action is called only once. Worst case, you may have to write a hack in your action method to make sure it gets called only once e.g. per conversation, or per row, etc.

[gebuh]

Can you post the offending component and backing methods?

[tanyaka]

Solved it with the aid of this http://davidrabinowitz.com/en/2007/12/22/seam-datamodel-factories/ for anyone in a similar situation.