This is a very odd problem. We are using the version of Hibernate included in Seam 1.1Beta.
I have the following EJB3 native query:
Code:
rawResults = fusion.createNativeQuery("Select site_server.member_id"+
" FROM site_server" +
" JOIN v_dynamic_node_tree ON site_server.associated_node_member_id = v_dynamic_node_tree.ancestor_member_id" +
" WHERE v_dynamic_node_tree.descendant_member_id = :CHILD_CONTROL_SET_ID").setParameter("CHILD_CONTROL_SET_ID", parentId).getResultList();
When I compile via the Eclipse Java builder (Eclipse 3.1) all is fine. That is, my rawResults is a List<Object> which is expected behavior. However, when I compile using the standard Java 1.5 compiler (either _08 or _09) using Ant, I get back List<Object[]>. That is, I get a list of object array with length = 1.
We are using Oracle 10g -- 10.2.0.1.0
This would seem like a bug, but the question is where? It's odd that the
compiler being used determines the result type, which is determined by the EJB3 implementation.