It's not a secret anymore!*
The moose likes JDBC 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 OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
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: 2497
    
    8

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
youtube channel
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: java.sql.SQLException: ORA-00942