File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 Murach's Java Servlets and JSP this week in the Servlets 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Table or view not found querying on subclass
 
Similar Threads
Outer join between 3 entities in HQL
javax.persistence.EntityNotFoundException: deleted entity passed to persist
DAO hibernate/JPA, data missing
using 2 @OnetoMany annoations in one Entity Class
@joincolumn updatable false