wood burning stoves 2.0*
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 Android Security Essentials Live Lessons this week in the Android 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
 
Consider Paul's rocket mass heater.
 
subject: Table or view not found querying on subclass
 
Similar Threads
@joincolumn updatable false
Outer join between 3 entities in HQL
using 2 @OnetoMany annoations in one Entity Class
javax.persistence.EntityNotFoundException: deleted entity passed to persist
DAO hibernate/JPA, data missing