i have the same problem, did you find a solution?. I have an entity field witch is combine by select of 3 tables . I use this kind of line in the mapping file : <property formula="( select .... ) and this select use 3 tables to get the value . ...> i have the same error ::: [JDBCExceptionReporter] SQL Error: 907, SQLState: 42000 09:24:10,196 ERROR [JDBCExceptionReporter] ORA-00907:... Could you mind to help me? Thanks in advance . View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4084911#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...