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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
DAO hibernate/JPA, data missing
using 2 @OnetoMany annoations in one Entity Class
@joincolumn updatable false
Outer join between 3 entities in HQL
javax.persistence.EntityNotFoundException: deleted entity passed to persist