wood burning stoves*
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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: ORA-00942" Watch "java.sql.SQLException: ORA-00942" New topic

java.sql.SQLException: ORA-00942

Sachin Judge

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!

David O'Meara

Joined: Mar 06, 2001
Posts: 13459

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

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

Joined: Dec 20, 2006
Posts: 2491

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
wood burning stoves
subject: java.sql.SQLException: ORA-00942
Similar Threads
ORA-00942: table or view does not exist
Exception when having different class and table name
hi,what cause this Exception?
Not able to drop user Oracle10.2.0.3 Ent Ed.
Problem in entity bean in websphere at create() statement