Simply have a jdbc where clause like
<jdbc-where-clause>where field1= ? and field2 = 0</jdbc-where-clause>
or
<jdbc-where-clause>where field1= ? and field2 = ?</jdbc-where-clause>
if you finder method has two arguments ... (see programmer's guide of Jonas).
Regards,
François
Seema Verma wrote:
> Hi,
>
> I have a problem in Finder descriptor in jonas-ejb-jar.xml file.
>
> As from sample example of eb ,I found the tag and syntax,which is as given
> below.
>
> <finder-method-jdbc-mapping>
> <jonas-method>
> <method-name>findByNumber</method-name>
> </jonas-method>
> <jdbc-where-clause>where accno = ?</jdbc-where-clause>
> </finder-method-jdbc-mapping>
>
> Above descriptor will query with the condition where accno="userdefined".
>
> But I want to use "and" in my where condition.How do I incorporate.Pls tell
> me the syntax.
> My query where condition is something like
>
> " where field1= ? and field2 = 0"
>
> Looking forward for your reply.
>
> Regards
> Seema
> ----
> To unsubscribe, send email to [EMAIL PROTECTED] and
> include in the body of the message "unsubscribe jonas-users".
> For general help, send email to [EMAIL PROTECTED] and
> include in the body of the message "help".
--
==================================================================
Francois EXERTIER Evidian (Groupe Bull)
1, rue de Provence, BP 208, 38432 Echirolles cedex, FRANCE
mailto:[EMAIL PROTECTED]
http://www.evidian.com/jonas http://www.objectweb.org/jonas
Tel: +33 (0)4 76 29 71 51 - Fax: +33 (0)4 76 29 76 00
==================================================================
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".
