Listing 1
<query>
<query-method>
<method-name>findAll</method-name>
<method-params/>
</query-method>
<ejb-ql><![CDATA[SELECT OBJECT(i) FROM InvoiceBean AS 
i]]></ejb-ql>
</query>

Listing 2

<query>
<query-method>
<method-name>findByDidNotOrder</method-name>
<method-params>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<ejb-ql/>
</query>

Listing 3
<weblogic-query>
<query-method>
<method-name>findByDidNotOrder</method-name>
<method-params>
<method-param>java.lang.String</method-param>
</method-params>0
</query-method>
<weblogic-ql>
<![CDATA[SELECT OBJECT(i) FROM InvoiceBean AS i WHERE 
i.invoiceNumber NOT IN (SELECT i2 FROM InvoiceBean AS i2 WHERE 
i2.lineItems.name = ?1)]]>
</weblogic-ql>
</weblogic-query>

Listing 4
<weblogic-query>

<query-method>
<method-name>ejbSelectAllInvoices</method-name>
<method-params>
</method-params>
</query-method> 
<weblogic-ql><![CDATA[ SELECT i.invoiceNumber, 
SUM(i.lineItems.price) FROM InvoiceBean AS i GROUP BY 
i.invoiceNumber]]></weblogic-ql> 
</weblogic-query> 

Listing 5
public Collection ejbHomeGetInvoiceList(){
ArrayList resultList = new ArrayList();
try {
java.sql.ResultSet rs = ejbSelectAllInvoices();
while (rs.next() ) {
String row = Integer.toString( rs.getInt(1) ) + "\t" + 
Double.toString( rs.getDouble(2));
resultList.add( row );
}
return resultList;
}
catch (Exception fe){
fe.printStackTrace();
return null;
}
}

Listing 6
<weblogic-query>
<query-method>
<method-name>ejbSelectTotalInEntity</method-name>
<method-params></method-params>
</query-method>
<weblogic-ql><![CDATA[SELECT SUM(i.lineItems.price) FROM InvoiceBean AS 
i]]></weblogic-ql>
</weblogic-query>