aspose file tools*
The moose likes JSP and the fly likes javax.servlet.ServletException:[Oracle][ODBC] [Ora]ORA-00942: table or view does not exist Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "javax.servlet.ServletException:[Oracle][ODBC] [Ora]ORA-00942: table or view does not exist" Watch "javax.servlet.ServletException:[Oracle][ODBC] [Ora]ORA-00942: table or view does not exist" New topic
Author

javax.servlet.ServletException:[Oracle][ODBC] [Ora]ORA-00942: table or view does not exist

sureshkumarneeli kumar
Greenhorn

Joined: Sep 30, 2011
Posts: 7
javax.servlet.ServletException:[Oracle][ODBC] [Ora]ORA-00942: table or view does not exist

when i run the jsp file in tomcat 5.0 version this is error came can any one solve this problem..


[Thumbnail for ora-942.png]

Komal Renu
Ranch Hand

Joined: Jul 21, 2011
Posts: 51
It seems straightforward, that the table or the View that you are trying to access is not present in the Database.
Check against the DB to see if all required tables and Views are present there.


Thanks and Regards,
-------------------------------------------------------------------------------------
Komal Renu | krenu@infocepts.com | www.infocepts.com
-------------------------------------------------------------------------------------
sureshkumarneeli kumar
Greenhorn

Joined: Sep 30, 2011
Posts: 7
No sir, It is in database ..but its giving this error ..in my system i am using oracle10g express edition..
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18903
    
    8

sureshkumarneeli kumar wrote:No sir, It is in database ..but its giving this error ..in my system i am using oracle10g express edition..


So who should I believe? The computer, or you? I believe the computer is right. You must have made some error.

However it's impossible for us to check that because we have no idea what table or view your code is looking for. Perhaps you don't know, either. At any rate, just saying "I'm right and the computer is wrong" is not going to solve your problem. You need to change your attitude.
Gopakumar Naryanan
Ranch Hand

Joined: Jan 15, 2011
Posts: 72

I guess it might be a typing mistake..

Please compare the table names.. whether both of them are same or not!!
One more thing , there is one more possibility that the table exists in the database but may not be under same schema..


Thanks & Regards
Gopakumar
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: javax.servlet.ServletException:[Oracle][ODBC] [Ora]ORA-00942: table or view does not exist