aspose 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
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: 4420
    
    8

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