Hi Rajesh, The Websphere generated Java files will be a gud point to start with. But I dont think it will be of much help unless you are able to relate some obvious problem in the impl classes with your descriptor files or with the WAS EJB Container. My guess is that the problem might be related to your descriptor files. Please recheck them.
Regards, Ritesh ----- Original Message ----- From: "Rajesh Kuriaparambil" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 27, 2003 9:03 AM Subject: A simple doubt in CMP beans ( Websphere 4.0 ) > 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 > > > > > =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".