No, It doesn't work!
Anyway, putting the code "String findByName_query = "people.name like $1""
in the home interface seems to modify the orion-ejb-jar.xml as you said,
doesn't it?.
Has anybody made such a query?
Please!! Help!!!
Thanks in advance
----- Original Message -----
From: Luong, Tony S322 <[EMAIL PROTECTED]>
To: Orion-Interest <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 6:19 PM
Subject: RE: Problem with a finder QUERY.
> The code "String findByName_query = "people.name like $1"" in the home
> interface does not do anything for the bean,
> you have to modify the deployment descriptor (eq.
>
<orion_home>\application-deployments\<app>\<app>-ejb.jar\orion-ejb-jar.xml).
>
> in the deployment descriptor look for <finder-method query=""> tag then
> change it to <finder-method query="$name like $1" >
> ...
> ...
> call the method using findByName("%john%");
>
> stop and start the server.
> this should do it.
>
>
> > -----Original Message-----
> > From: fresnaULL [SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, February 13, 2001 8:43 AM
> > To: Orion-Interest
> > Subject: Problem with a finder QUERY.
> >
> > Hi all,
> >
> > Basically, this is the query i'm trying to do: (i'm using SQL SERVER
7.0)
> >
> > SELECT * FROM people
> > WHERE people.name LIKE '%john%'
> >
> > This is what i've done now:
> > - In the people home interface
> >
> > String findByName_query = "people.name like $1";
> > .
> > .
> > public java.util.Enumeration findByName(String value) throws
> > java.rmi.RemoteException, javax.ejb.FinderException;
> >
> >
> > I make a call to the finder query like this:
> >
> > Enumeration en = PeopleHome.findByName("%John%");
> >
> > But this doesn't work or at least I don't get any result(of course it
> > should return a result).
> > If I replace the "like" clause by "=" and i make a call like
> > Enumeration en = PeopleHome.findByName("John");
> > it does work, I get a result.
> >
> > Does anybody know what I'm doing wrong? is there any problem with the
> > "like" clause?
> >
> > Thanks in advance
> >
> > P.S. I'm not trying to laugh at anybody :-)
> >
> > >From: [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>
> > >[ <mailto:[EMAIL PROTECTED]>]On Behalf Of Geoff
> > Marshall
> > >Sent: Monday, February 12, 2001 10:31 AM
> > >To: Orion-Interest
> > >Subject: Re: Problems with a finder method in a cmp
> > >
> > >
> > >Please don't laugh at me, but what IS a 'finder method in a CMP'??
Just
> > a
> > >simple explanation or a pointer to more info, please...
> > >--
> > >
> > >-Geoff Marshall, Director of Development
> >
>
> --------------------------------------------------------------------------
----
> CONFIDENTIALITY NOTICE: If you have received this e-mail in error, please
immediately notify the sender by e-mail at the address shown. This e-mail
transmission may contain confidential information. This information is
intended only for the use of the individual(s) or entity to whom it is
intended even if addressed incorrectly. Please delete it from your files if
you are not the intended recipient. Thank you for your compliance.
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
