This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes Object Relational Mapping and the fly likes Table or view not found querying on subclass Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Table or view not found querying on subclass" Watch "Table or view not found querying on subclass" New topic
Author

Table or view not found querying on subclass

Mars Mondal
Greenhorn

Joined: Jan 01, 2011
Posts: 14
I am using a single table inheritance straegy for a table as follows:


and the subclass is


The case History table is lmapped like this


The subclass is joined to another table as given above.
Now my query is like


However I get a table not found error. What is my mistake?
Mars Mondal
Greenhorn

Joined: Jan 01, 2011
Posts: 14
Sigh looks like I keep overlooking small things because of my deadlines. The hibernate was actually using the tables from another schema and I had forgotton to give access to that schema. Its resolved
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Table or view not found querying on subclass