Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Doubt in CMP ( websphere 4.0)

 
Rajesh Kuriaparambil
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all ,

I am having a problem in calling the findbyprimarykey method and the create method of the home interface of a CMP bean in websphere 4.0 .
The error i am getting when i invoke the findbyprmarykey method is
java.rmi.ServerException: RemoteException occurred in server thread;
nested exception is:com.ibm.websphere.cpi.CPIException:
java.sql.SQLException: ORA-00933: SQL command not properly ended;
nested exception is:
java.sql.SQLException: ORA-00933: SQL command not properly ended

The error i am getting when i invoke the create method is
java.rmi.ServerException: RemoteException occurred in server thread;
nested exception is: com.ibm.websphere.cpi.CPIException:
java.sql.SQLException: ORA-00926: missing VALUES keyword;
nested exception is: java.sql.SQLException: ORA-00926: missing VALUES keyword
we don't have to provide any SQL code for CMP beans and it will be taken care by the container . So i don't know where to start the debugging .So please tell me the possible places where i 've gone wrong .

Should i check the mapping file ( EJB to RDB mapping ) or should i edit / debugg the java files generated by websphere where the original SQL query is formulated ?
Tell me if there is an another method

Help me .........
With regards
Rajesh Kuriaparambil
 
Ajith Kallambella
Sheriff
Posts: 5782
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to IBM/Websphere forum...
 
Patrick Finnegan
Ranch Hand
Posts: 179
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Post the code.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic