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?

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>
      
0 Comments  (click to add your comment)
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

About | Sitemap | Contact