I think u can try out Toplink addon to WLS 5.1 (public beta available on may
12th www.objectpeople.com) --- they have a replacement for WLQL and that may
be more powerful.
Ana

-----Original Message-----
From: Shiv Kumar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 04, 2000 10:44 AM
To: [EMAIL PROTECTED]
Subject: Does finder support IN clause


Hi all

Does any other Application Server provide such a feature? Read on..

I am using Weblogic 5.1 and struggling to write a finder method for a CMP
bean
which can use the SQL 'IN' clause. For example, I want something like this
:-

public Enumeration findByAandBs(A a, B[] b) {
  // this finder should translate to
  // select * from t where t.a = a and t.b IN (b[0], b[1], b[2],.... b[n]);
}

The weblogic WLQL operator list does not include the 'IN' operator. Has
anyone
else in this list faced the same problem?

Thanks.
--
shiv
[EMAIL PROTECTED]



--
shiv
[EMAIL PROTECTED]



__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com

===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST".  For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".

===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST".  For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".

Reply via email to