File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Websphere and the fly likes Doubt in CMP ( websphere 4.0) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "Doubt in CMP ( websphere 4.0)" Watch "Doubt in CMP ( websphere 4.0)" New topic
Author

Doubt in CMP ( websphere 4.0)

Rajesh Kuriaparambil
Greenhorn

Joined: Feb 24, 2003
Posts: 2
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

Joined: Mar 17, 2000
Posts: 5782
Moving to IBM/Websphere forum...


Open Group Certified Distinguished IT Architect. Open Group Certified Master IT Architect. Sun Certified Architect (SCEA).
Patrick Finnegan
Ranch Hand

Joined: Mar 05, 2002
Posts: 179
Post the code.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Doubt in CMP ( websphere 4.0)