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
