posted 18 years ago
This is a query I defined in a mapping file:
<query name="com.abc.db.member.membersById">
<![CDATA[
from com.abc.db.member.MemberDTO as member
where upper(member.id) = upper(:id)
]]>
</query>
I got following exception when I try to create SessionFactory
org.hibernate.HibernateException: Errors in named queries: com.abc.db.member.membersById
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:289)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1043)
If I change the alias �member� in the query to a different name, e.g. member0 or mbr, everything works fine. Have anyone had a similar experience before? Is this a bug? Is �member� a reserved name?