By trial and error, I eventually determined that a very specific syntax
was
necessary to set up CMP finder methods other than FindByPrimaryKey
within
the J2EE RI deployment tool.
The deployment settings SQL statement for other Finder methods needs to
specify a parameter number. This is required even when there is only
one
parameter. This is in contrast to the FindByPrimaryKey method's sql
statement:
SELECT "personID" FROM Person WHERE "personID" = ?
For example, a FindByFullName method would require the following sql
statement:
SELECT "personID" FROM Person where "fullName" = ?1
Notice the number "1" after the question mark. If the J2EE tutorials had
included an example of this, I might have saved myself a half day. I
thought I'd post this message to possibly save other people time.
===========================================================================
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".
