Any help will be greatly appreciated.
In my code, after create session, I am running the following code:

session.iterate("SELECT count(*) FROM data.Role");

And get the following error consistently:
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.String.substring(String.java(Compiled Code))
at java.lang.String.substring(String.java(Compiled Code))
at net.sf.hibernate.sql.QuerySelect.toQueryString(QuerySelect.java:96)
at net.sf.hibernate.hql.QueryTranslator.renderSQL(QueryTranslator.java:465)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:119)
at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:358)
at net.sf.hibernate.impl.SessionFactoryImpl.getShallowQuery(SessionFactoryImpl.java:340)
at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1354)
at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1382)
at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1372)
at net.sf.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1364)
at data.HibernateDataAccess.selectUser(HibernateDataAccess.java:98)

Bizarre!

Are you absolutely certain that data.Role is a mapped persistent class?

I am sure data.Role is a mapped persistent class.
I solved this problem just by chagning my hibernate version from 2.0.3 to 2.1. I don't know why but it is working now.
Thanks
George