This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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: 4344
    
    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.
 
 
subject: table or view doesnt exist error
 
Similar Threads
joined-subclass problem
Joining tables
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.
Query not returning any data..
How to autharize against Oracle DB with an LDAP Authentication