Please help me!!!

  Is there any possibility to pass order direcrtion as parameter
of a finder? That is parameter string ("asc" or "desc") is added to
the end of SQL?

Ex.: findAllSortedByState("asc");

In orion-ejb-jar.xml:

            <finder-method query=" select * from SomeTable order by state $1" 
partial="false">
                <!-- Generated SQL: " select * from SomeTable order by state ?" -->
                <method>
                    <ejb-name>SomeTable</ejb-name>
                    <method-name>findAllSortedByState</method-name>
                    <method-params>
                    </method-params>
                </method>
            </finder-method>

In SomeTableHome.java:

  public Collection findAllSortedByState(String direction) throws RemoteException, 
FinderException;
  public static final String findAllSortedByStatec_query="full: select * from 
SomeTable order by state $1";



Reply via email to