Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.sql.SQLException: ORA-00942

 
Sachin Judge
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ORA-00942: table or view does not exist
 
padma vvvs
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
verify whether thge table/view existing or not.check for the exact case of the letters in the table/view name.
 
Jan Cumps
Bartender
Posts: 2584
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic