[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: How to use Subqueries in a finder-Method???

sachin1506 do-not-reply at jboss.com
Wed Jan 14 04:46:31 EST 2009


Hello sir
i am using declared sql as i have to run subquery 
my declared-sql query is like this :-

  | 
  |          <query>
  |         <query-method>
  |           <method-name>findByMaxContactInfoId</method-name>
  |           <method-params/>
  |         </query-method>
  |          <declared-sql>
  |            <select>
  |            	<field-name> CONTACTINFOID</field-name>
  |            	<alias>o</alias>
  |            </select>
  |            <from>,RACONTACTINFO</from>
  |            <where> o.contactInfoId IN
  |                 <select> 
  |                  <additional-columns>MAX(CONTACTINFOID) </additional-columns> 
  |                   <alias>g</alias>
  |                   </select>
  |                  <from>, RACONTACTINFO </from>
  |            </where>
  |          </declared-sql>
  |          </query>
  | /code]
  | i am using JBOSS 4.0.0 jdk 1.4 
  | But showing following exception 
  | 
  | 
  |   | org.jboss.deployment.DeploymentException: The field-name element of declared-sql select is only allowed for ejbSelect queries
  |   | 
  | 
  | how can i resolve this ?? 
  | even jboss 3.2.6 shows the same exception 
  | 
  | my original query is like this
  |  
  |   | SELECT OBJECT(o) FROM RaContactInfo AS o WHERE o.contactInfoId IN (SELECT MAX(p.contactInfoId) FROM RaContactInfo AS p
  |   | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4201657#4201657

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4201657



More information about the jboss-user mailing list