3 Replies Latest reply on Mar 12, 2003 7:21 AM by Tin Blaskovic

    finder method

    Qasim Newbie

      Hi,

      I tried to create a finder method using Xdoclet. I want to get all the distinct isbn numbers from my table. I wrote the following code:

      * @ejb.finder
      * signature="java.util.Collection findByIsbn()
      * query="SELECT DISTINCT OBJECT (i.isbn) FROM OrderItem AS i"
      *

      'isbn' is the column name and OrderItem is the abstract name of the bean.

      any suggestions.