the code is:
here in my DB, we don.t have the id column, that's why we are getting the problem? in hibernate we must needed the id attribute, but in our table it doesn't, The error is
How to avoid this problem?
So try removing the "INFORMATION_SCHEMA" schema name from the query.
Paul Sturrock wrote:Are you connecting using a user that can see this table? Are they in the same schema, or has the table been made available via another mechanism (e.g. synonyms)?
I'm using HSQL Database Engine and these tables are already predefined with JBOSS Dev studio. They are in the same schema too.
Paul Sturrock wrote:
They are in the same schema too.
So when you log in to the database using a normal SQL client and the user details hibenrate is using to connect you can see this object?
Yes, Before I start using hibernate, I used JDBC code to test and I got the results too
Paul Sturrock wrote:Sorry - I'm a bit slow today.
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?