• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

Doubt in CMP ( websphere 4.0)

 
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
 
Sheriff
Posts: 5782
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to IBM/Websphere forum...
 
Ranch Hand
Posts: 179
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Post the code.
 
Always look on the bright side of life. At least this ad is really tiny:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
    Bookmark Topic Watch Topic
  • New Topic