Hi,
But why does the upper(companyName) ? if i give it then only it is working.
Otherwise it is giving error saying that "error in finder method".
Since that is a columnname it should work with out the upper operator
applied to it also. Or am i missing any thing here?
Regards
Rama Rao
----- Original Message -----
From: Kimpton,C (Chris) <[EMAIL PROTECTED]>
To: 'jBoss' <[EMAIL PROTECTED]>
Sent: Friday, February 02, 2001 6:49 PM
Subject: RE: [jBoss-User] ORACLE - CMP Problems
> Hi,
>
> > I could deploy successfully one entity bean.
>
> Great.
>
> > How can i write a query expression for findByMIP(String
> > s1,String s2,String
> > s3).
> >
> > Where can i get information on query expression to give for
> > finder methods?
> >
>
> Its all in the example I gave...
>
> > >
> > #####################################################################
> > >
> > > jaws.xml
> > >
> > >
> > >
> > > <?xml version="1.0"?>
> > >
> > > <jaws>
> > >
>
> <snip>
>
>
> > > <enterprise-beans>
> > >
> > > <entity>
> > > <ejb-name>CompanyBean</ejb-name>
> > > <finder>
> > > <name>findWithCompanyNameLike</name>
> > > <query>upper(companyName) like '%'||upper({0})||'%'</query>
> > > <order>companyName</order>
> > > </finder>
> > > </entity>
> > >
>
> You have 3 parameters, so refer to them as {0}, {1} and {2}, as I have
above
> for my 1 parameter...
>
> For more info see..
>
> http://www.jboss.org/documentation/jawsxml_howto.html#finders
>
> Chris
>
>
============================================================================
====================
> This electronic message (email) and any attachments to it are subject to
copyright and are sent for the personal attention of the addressee. Although
you may be the named recipient, it may become apparent that this email and
its contents are not intended for you and an addressing error has been made.
This email may include information that is legally privileged and exempt
from disclosure. If you have received this email in error, please advise us
immediately and delete this email and any attachments from your computer
system.Rabobank International is the trading name of Coöperatieve Centrale
Raiffeisen-Boerenleenbank B.A. which is incorporated in the Netherlands.
Registered with the Registrar of Companies for England & Wales No. BR002630
and regulated by the SFA for the conduct of investment business in the UK.
>
> The presence of this footnote also confirms that this email has been
automatically checked by Rabobank International for the presence of computer
viruses prior to it being sent, however, no guarantee is given or implied
that this email is virus free upon delivery.
>
>
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> List Help?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
