Discussions

EJB programming & troubleshooting: EJB Finder methods

  1. EJB Finder methods (1 messages)

    Hi

    I want to pass an collection of primary objects into a finder method (of a CMP bean) so I can then update each bean appropriately.

    What I would like to do is something like this

    Collection findMyBeans(Collection pkObjects)

    with the EJB QL behind this method

    SELECT OBJECT(obj) FROM MyBean AS obj where obj.orderId IN (?1)


    Is this possible how do I make this work correctly, and if not is there a way around this without multiple queries ie findObject(PKObject pk) for each pk in the collection.

    I am using Weblogic 6.1 sp3 and Oracle 8.1.6.

    Thanks

    Matt
  2. I'm also looking for a "In expression" collection parameter example. As mentioned
    in the j2ee tutorial, the following thing is possible with EJB QL 2.1:

    [code]
    SELECT OBJECT(o) FROM country o WHERE o.country IN ('UK', 'US', 'France')
    [/code]

    What I need is the following:
    - finder signature:
    [code]
    public java.util.Collection findByCountry(Collection aCountryNameList)
    [/code]
    - query:
    [code]
    SELECT OBJECT(o) FROM country o WHERE o.country IN (?1)
    [/code]

    Is this possible, either in EJB 2.1 Or EJB 2.0?

    Thanks in advance


    EJB 2.1 tutorial: http://java.sun.com/j2ee/1.4/docs/tutorial/doc/EJBQL5.html#wp80051 (CTRL-F IN Expressions)