Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Need Help on TableDoesNotExistException  RSS feed

 
Kumar Saravanan
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

I got an EAR file and import it into WSAD 5.0 and tested the application. Application contains Stateful Session Beans and Entity Beans (CMP).

I am getting the following error when I hit one hyperlink in the application. Behind the scenes, Servlet is calling the CMP Entity Bean and more particularly it is calling the finder methods of that Entity Bean.

CNTR0019E: Non-application exception occurred while processing method findByPrimaryKey: com.ibm.websphere.cpi.CPIException: com.ibm.ejs.cm.portability.TableDoesNotExistException: ORA-00942: table or view does not exist
; nested exception is:
com.ibm.ejs.cm.portability.TableDoesNotExistException: ORA-00942: table or view does not exist

com.ibm.ejs.cm.portability.TableDoesNotExistException: ORA-00942: table or view does not exist.

Help me to resolve this issue and please tell me what kind of problem is this.

Appreciate your help.

Thanks,
Kumar.S
 
Kumar Saravanan
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

Anybody can give me some help what I am doing wrong...

Thanks,
Kumar.S
 
Brian Tinnel
Ranch Hand
Posts: 69
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My best guess would be that the table or view that your CMP is trying to access does not exist in the database.
 
Kumar Saravanan
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Brian,

Thanks a lot for your reply.

I checked the table and it exists and also from the application I am able to view the data which exists in the same table but the problem arises only when I try to update the existing values.

If I update the data through the backend I am able to view the updated value from the application. But from the application, If I try to Update the value then I am getting the "Table Does not Exist exception".

Can you please tell me what else I am doing wrong?

Thanks,
Kumar.S
 
David Harkness
Ranch Hand
Posts: 1646
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If your appserver has JDBC/SQL logging, enable it and see what query it is issuing during the failed update. If it doesn't, you can use P6Spy, a JDBC driver wrapper that logs all SQL queries and results.

The only thing I can think of, which doesn't seem to apply here, is that there is another table that is being updated as well -- either a related bean or the cross table for a many-to-many (M:N) relation. If you're updating only the beans you retrieve, this shouldn't be the case.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!