dcsimg

In a Weblogic CMP EJB, how to obtain the maximum value in the specified database column? In WLQL is there something similar to MAX() function in SQL?

Created May 4, 2012

oli nilavan

I dont know how to write in WLQL. Another solution is to write the query using SQL inside the weblogic-cmb-rdbms-jar.xml file. 

  

<?xml version="1.0" encoding="UTF-8"?>

<finder-list>
    <finder>
      <method-name>findByOrgn</method-name>
      <method-params>
	<method-param>
	  <param-type>java.lang.String</param-type>
	  <param-name>orgnCode</param-name>
	</method-param>
      </method-params>
      <finder-type>SQL</finder-type>
      <finder-query>
< ! [ CDATA[SELECT * FROM Asn_Goal_M WHERE ( orgn_code = #orgnCode and DELETE_FLAG='N') ] ] >
      </finder-query>
   </finder>