java.lang.UnsupportedOperationException: SQL queries do not currently support iteration

Hi All.

code as below
Query query=session.createSQLQuery(" select Character.nationality_cd from crm_t_character Character ");
Iterator ite=query.iterate();

exception throws as below:
java.lang.UnsupportedOperationException: SQL queries do not currently support iteration
at org.hibernate.impl.SQLQueryImpl.iterate(SQLQueryImpl.java:203)

hi
use


Query query=session.createQuery(" select Character.nationality_cd from crm_t_character Character ");

dont forget to rate if this helps.

nirav
-----------------------------

thanks ,

I konw it is ok.but I don't konw why is it.