Sebastian, thanks for taking time to change your display name
We need a few more things to be able to figure out what the issue is.
1) The contents of the hbm.xml for that specific class/table that you are trying to query.
2) The code where you are building the SessionFactory
3) The logs when the SessionFactory is being built
4) The entire exception stacktrace that you are seeing.
In the meantime, can you try out the following:
If your hibernate POJO class (lets call it User) is inside the package named myPackage, then try out this HQL
Note that the User is the
classname and not the tablename and also the usr.id and usr.number are members of the User class.
[Jaikiran: Edited to remove specific references to tables, on original poster's request]
[ July 04, 2007: Message edited by: Jaikiran Pai ]