Thanks for the tip. Ok, so I tried with FullSelectFinderDescriptor using the selectStatement="SELECT T1.USERID FROM T1.MYTABLE".
Hmm.... I noticed one thing. In the Inforcenter, it mentioned it supported 4 custom finders which includes SQL SELECT, SQL WHERE, SQL Method, EJB query language. However in AAT, only the SQL Where (whereClause) option is available to help you generate the finder descriptor codes in the ibm-ejb-jar-ext.xmi. Does that means if I want to use the other methods, I have select the user option, jar the file (save it) and modify the generated ibm-ejb-jar-ext.xmi file, right? I try that but it keep throwing a "Must implement Method in Bean class". I am wondering if I need to implement a finder helper interface for the SQL SELECT, SQL Method, and EJB query? I mean SQL Where is the only working one now without a finder helper.
Can anyone verify what I have just written? Or give me the correct step of using the find methods without using finder helper interface.