[jboss-user] [EJB 3.0] - Re: How to get the size of a Lazy load relation

"code" tag should show everything for you. :) What version of MySQL are you using? There's also: MySQL5Dialect MySQL5InnoDBDialect ...available to you, though I'm not confident that's the source of your problem. I'd play around with the EJBQL to get resultant SQL that'll execute in the MySQL Command-Line or GUI Tools on its own first. That "count(.)" should either be "count(fieldName)" or "count(*)". Maybe try EJBQL: SELECT COUNT(obj.association.pkey)...? S, ALR View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4085231#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...