Seam distro examples of Criteria or QBE?

[admin.admin.email.tld]

Are there any examples of using Hibernate criteria or QBE in the Seam 2.0 distro example apps?

Specifically, a search screen with multiple search fields (inputText and drop-downs) involving potential joins with multiple tables.

thx.

[pmuir]

What did your last slave die of :-P

[admin.admin.email.tld]

Not sure what you mean exactly Mr. Muir.  I guess you're saying I'm lazy perhaps b/c all that's required is a keyword text search on criteria or example in the seam example source code. 

no luck (perhaps b/c those API's are Hibernate specific and not part of the JPA spec yet).  caveat emptor I think I tried and don't recall what results there were.

I was able to get it working using the Hibernate session.createSQLQuery method and return entities instead of scalar values and then do the path navigation using dot notation in the JSF EL.

But it gets complicated when there's more than two tables to be joined and there two db's, etc. and not sure of best practice in this scenario.

yeah, I know.  this doesn't really belong on the Seam forum...

[admin.admin.email.tld]

well it looks like I just lied, there are some hits on criteria.  my memory sucks...