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 doesnt exist error 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 doesnt exist error" Watch "table or view doesnt exist error" New topic
Author

table or view doesnt exist error

Booma Devi
Ranch Hand

Joined: Nov 02, 2011
Posts: 61

Can someone please help to solve the below error?


Hibernate: select this_.EMP_ID as EMP1_0_0_, this_.EMP_NAME as EMP2_0_0_ from EMPLOYEE this_

Matthew Brown
Bartender

Joined: Apr 06, 2010
Posts: 4240
    
    7

That just sounds as if either the EMPLOYEE table doesn't exist, or the database user you are connecting as doesn't have permission to see it. Maybe it needs qualifying with the schema name. I'd suggest checking those first.
Booma Devi
Ranch Hand

Joined: Nov 02, 2011
Posts: 61
Thanks for your quick response mathew. The problem is, I didn't include the schema name in hibernate mapping file. Now, its working fine.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: table or view doesnt exist error
 
Similar Threads
Query not returning any data..
How to autharize against Oracle DB with an LDAP Authentication
Joining tables
joined-subclass problem
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.