File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and Relational Databases and the fly likes java.sql.SQLException: ORA-00942 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "java.sql.SQLException: ORA-00942" Watch "java.sql.SQLException: ORA-00942" New topic
Author

java.sql.SQLException: ORA-00942

Sachin Judge
Greenhorn

Joined: May 02, 2007
Posts: 1
I am getting the error java.sql.SQLException: ORA-00942 when i try to insert rows in a DB.

I am able to login using the same username and pwd that i'm using in the code. And am also able to select records.

Any help will be appreciated!


Thanks!
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

ORA-00942: table or view does not exist
padma vvvs
Greenhorn

Joined: May 07, 2007
Posts: 2
verify whether thge table/view existing or not.check for the exact case of the letters in the table/view name.
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2541
    
  10

check for the exact case of the letters in the table/view name
SQL (and sql) is not case sensitive for database object names (such as a table, a column, a view).
Regards, Jan


OCUP UML fundamental and ITIL foundation
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException: ORA-00942
 
It's not a secret anymore!