H.E.M. (Hibernate Entity Manager) prefixes the schema name of accessed database tables to that of the connecting user. For example, if my database account username is MICKEYMOUSE, and I connect a database and then all tables that I try to access will be accessed as MICKEYMOUSE.*.
So try removing the "INFORMATION_SCHEMA" schema name from the query.
posted 11 years ago
I tried in that by removing schema too, but I get the same exception
Objects in HQL are case sensitive. You've mapped SystemAliases, not SYSTEM_ALIASES.
Hey Paul, I got idea and changed to "from SystemAliases"
I didn't find exception but I didn't find the results, in DB there are.
and the query is look like I printed from console.
Here I got a doubt, actually there is no id in the table (SYSTEM_ALIASES), but I put the id tag in the hbm file as it is recommended. Then generally it supposed to throw an SQL error as Im trying to fetch id form the table. why it is not throwing error?