Hi Gary,


0
      a     Thanks very very very very very ... much :-)
      b      or:    :-)

             while(true){
             thanks_very_much();   //:-)
                if( you_are_in_Ottawa ){
                I_will_invite_you_to_drink_beer_and_see_jazz_band_live_show
();   // :-)
                }
            }


1
I have spent many days in it, because I can not use "WHERE"
in "CMP findByXxx " with J2EE1.2.1 RI.  I will try right now
according to your email :-)


2
BTW,  Sorry for another question :-) :-)

Can you use  "xxx findByPrimaryKey(xxxPK key)" with J2EE1.2.1 RI?
Now I only can use "String" or other, but if I use a "custom xxxPK",
I got a "...ClassCastExcaption". Perhaps something in my work is wrong,
so if you can do it, please tell me  :-)



Bo
Sept.13,2000




Gary Raley wrote:

> 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".

===========================================================================
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".

Reply via email to