RE: [JBoss-user] (Retry) Problem with findByPrimaryKey

[Gavin Hughes]

Title: (Retry) Problem with findByPrimaryKey

The problem turned out to be that I wasn’t specifying the primkey-field attribute in the XDoclet @ejb:bean tag.   So the generated descriptors had this empty, hence the “missing expression” in the SQL being passed to Oracle.   I guess it would be nice if JBoss complained loudly about this when the EJB jar is deployed.   Thanks for the answers all.       -----Original Message----- From: Sebastien CHAUSSON [mailto:[EMAIL PROTECTED]] Sent: Friday, 6 September 2002 5:01 PM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] (Retry) Problem with findByPrimaryKey   How do you call this finder ?   ----- Original Message ----- From: Gavin Hughes To: [EMAIL PROTECTED] Sent: Friday, September 06, 2002 6:26 AM Subject: [JBoss-user] (Retry) Problem with findByPrimaryKey   Hi, I’m getting the following error when calling the default finder “findByPrimaryKey” for a CMP entity bean. javax.ejb.FinderException: Find failed: java.sql.SQLException: ORA-00936: missing expression Can anyone explain what this means and how I can fix it ? I’m using JBoss3.0.0, XDoclet 1.1.2 and Oracle 9i on Windows XP. I haven’t done any explicit definition of this finder or any other finder in my Bean class – other than XDoclet generating a findByPrimaryKey method in the Home interface. Thanks, Gavin.