This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft 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 Java 8 in Action this week in the Java 8 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: 4244
    
    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
joined-subclass problem
Joining tables
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.
How to autharize against Oracle DB with an LDAP Authentication
Query not returning any data..