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 ¢é칻®&ޱéÝzf¢–Ú%ŠËlz»ãjö¬ºw(™©݊w%¹עžØ^n‡r¡ûazg¬±¨²('¡÷Ä$ LDDI1h®§z¶¥…éi±éÝzf¢–Ú%ŠËlz»ãjö¬ºw(™©݊w%¹עžØ^n‡r¡ûazg¬±¨…éi