Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.0

Mapping documents:

<hibernate-mapping package="com.lib">

<class name="Role" table="Role">
<id name="roleid" column="RoleId" type="string">
<generator class="native"/>
</id>

<property name="privilege" column="Privilege" type="serializable" />
</class>

</hibernate-mapping>

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:
sql2000

The generated SQL (show_sql=true):[/b
SQLQuery query = session.createSQLQuery("select af.privilege from from Role af");
query.addScalar("privilege",Hibernate.STRING);

[b]Debug level Hibernate log excerpt:
line 1:18: unexpected token: from

Hi to all,

Actually I have Mssql2000 Role table
It contains rolid(varchar 20)
and
Privilege (text 16) . It contains xml formated data.

But Using

SQLQuery query = session.createSQLQuery("select af.privilege from from Role af");
query.addScalar("privilege",Hibernate.STRING);

I got Error.

Is Hibernate.String or any type.

Pls tell me some Idea?

Thanks
Edward Durai. A

Check your SQL -- "... from from ..." is not valid.