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";