"icordoba" wrote : select count(.) as col_0_0_ from Role role0_, User_Role users1_, User user2_ where role0_.pkey=users1_.roles_pkey and users1_.users_pkey=user2_.pkey and role0_.pkey=? ...not sure about that generated "count(.)". Just ran a test for that syntax on MySQL 5.0.27 and came up with the same error you're getting. Sure you've configured the correct dialect for Hibernate in persistence.xml? S, ALR View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4085163#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...