Ciao a tutti ho eseguito una named queries su DB Oracle attraverso questo codice:

Codice PHP:
StatelessSession session AssignSessionFactory.getInstance().openStatelessSession();

List 
allRecord session.getNamedQuery("policiesAssingmentQuery").list(); 
dove la named queries in questione è:

Codice PHP:
<sql-query name="policiesAssingmentQuery"
<return-
scalar column="POL_NO" type="java.lang.Integer" />
<return-
scalar column="LIFE_ASS" type="java.lang.String" />
<return-
scalar column="PROPOSER" type="java.lang.String"/>
<return-
scalar column="ASSIGNOR" type="java.lang.String"/>
<return-
scalar column="ASSIGNEE" type="java.lang.String"/>
 <![
CDATA

SELECT

SASASSIGNS
.POLICIES.POL_NO,
SASASSIGNS.POLICIES.LIFE_ASS,
SASASSIGNS.POLICIES.PROPOSER
SASASSIGNS.ASSIGNS.ASSIGNOR,
SASASSIGNS.ASSIGNS.ASSIGNEE 

    FROM SASASSIGNS
.POLICIES
            LEFT JOIN SASASSIGNS
.ASSIGNS 
       ON
          SASASSIGNS
.POLICIES.POL_NO SASASSIGNS.ASSIGNS.POL_NO

    ORDER BY SASASSIGNS
.POLICIES.POL_NO 
Mi restituisce l'errore

class java.lang.ClassCastException: org.hibernate.impl.SQLQueryImpl cannot be cast to java.util.List

sulla riga:
List allRecord = session.getNamedQuery("policiesAssingmentQuery").l ist();

La query è corretta dove sta quindi il problema????

attendo le vostre risposte...

grazie