aspose file tools*
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
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: 2510
    
  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
youtube channel
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException: ORA-00942