Discussions

EJB design: Finder query in CMP bean

  1. Finder query in CMP bean (2 messages)

    I have a date filed declared in my cmp entity bean,how should I write the finder query to return the records which fall into certain range of dates.
    The equivalent DB query is:
    select * from table_name where date>date1 and date<date2;

    Thanks

    Threaded Messages (2)

  2. Finder query in CMP bean[ Go to top ]

    Finder queries are container dependant so we cant help you unless you tell us what container it is.

    In Sybase EAServer the finder query would look like

    select * from [table] where date > @date1 and date < @date2

    Dave Wolf
    Internet Applications Division
    Sybase
  3. Finder query in CMP bean[ Go to top ]

    Hi,
    in weblogic5.1 u have to give WLQL query in finder method like (& (date >date1) (date <date2)).
    by
    anil