from Documentation:
in your Home interface:
public Collection findNullColumns()
throws FinderException, RemoteException;

in your jaws.xml
<jaws>
        <enterprise-beans>
                <entity>
                        <ejb-name>ClassBean</ejb-name>
                        ...
                <finder>
                        <name>findNullColumns</name>
                        <query>MyColumn is null</query>
                        <order></order>
                </finder>
                </entity>
        </enterprise-beans>
</jaws>
Should do the job.
Burkhard
----- Original Message -----
From: "Keerthi P" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 11:20 AM
Subject: [JBoss-user] URGENT !!! Finder....


> Hi all,
> how to declare a finder in jaws.xml if i need to select rows if a field's
value is null.
> for eg: my oracle query is "select * from table where mycolumn is null".
Could any one of you tell
> me the equivalent <finder> construct that i can use in jaws
>
> thanks in advance.
>
> keerthi
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user


_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to