finder queries

[DPietro]

Can some one help me out on this?
I want to implement a findByName.
I've looked at findquery.html and finders.html and am still having 
trouble.
I want a findByName but I dont want to edit the orio-ejb-jar.xml file, I 
want to put the string into the Bean. 
Where? In the bean, the home, or the remote. 
And how do you do a partial? (findquery.html shows a full: I have yet to 
find any docs that describe the use of this method)

I guess I want something like findByName_query=partial: where prov_name = 
$1 and I dont know how.
thanks.

Finder queries...

[Alex Paransky]

I have defined the following finder for the relationship (Account has many
Users) - (User has One Account):

query
  query-method
method-namefindByAccountLogin/method-name
method-params
  method-paramjava.lang.String/method-param
  method-paramjava.lang.String/method-param
/method-params
  /query-method
  ejb-ql
FROM com.indnet.symbiosis.model.User u WHERE u.account.id = ?1 and
u.login = ?2
  /ejb-ql
/query

Here is what Orion generates in orion-ejb-jar.xml:

finder-method query=""
  !-- Generated SQL: "select Users.id, Users.firstName, Users.middleName,
Users.lastName, Users.birthDate, Users.gender, Users.userLogin,
Users.userPassword, Users.accountId, Users.scheduleId, Users.superuser from
Users" --
  method
ejb-namecom.indnet.symbiosis.model.entity.User/ejb-name
method-namefindByAccountLogin/method-name
method-params
  method-paramjava.lang.String/method-param
  method-paramjava.lang.String/method-param
/method-params
  /method
/finder-method

Thanks.
-AP_

Re: Finder queries...

[Hani Suleiman]

Orion doesn't support ejb-ql yet.

On Mon, 2 Apr 2001, Alex Paransky wrote:

 I have defined the following finder for the relationship (Account has many
 Users) - (User has One Account):
 
 query
   query-method
 method-namefindByAccountLogin/method-name
 method-params
   method-paramjava.lang.String/method-param
   method-paramjava.lang.String/method-param
 /method-params
   /query-method
   ejb-ql
 FROM com.indnet.symbiosis.model.User u WHERE u.account.id = ?1 and
 u.login = ?2
   /ejb-ql
 /query
 
 Here is what Orion generates in orion-ejb-jar.xml:
 
 finder-method query=""
   !-- Generated SQL: "select Users.id, Users.firstName, Users.middleName,
 Users.lastName, Users.birthDate, Users.gender, Users.userLogin,
 Users.userPassword, Users.accountId, Users.scheduleId, Users.superuser from
 Users" --
   method
 ejb-namecom.indnet.symbiosis.model.entity.User/ejb-name
 method-namefindByAccountLogin/method-name
 method-params
   method-paramjava.lang.String/method-param
   method-paramjava.lang.String/method-param
 /method-params
   /method
 /finder-method
 
 Thanks.
 -AP_