You don't need to do this in a finder method ... just do it in a normal business method, wich return an int or an Integer object (the result of the 'select count' query ...)
Hermann R A N G A M A N A Ingénieur Informaticien Primagendys SAS Tél : +(33) 1 43 58 27 83 Fax : +(33) 1 43 58 27 17 e-mail : [EMAIL PROTECTED] ----- Original Message ----- From: "John LYC" <[EMAIL PROTECTED]> To: "Jboss Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, October 16, 2001 5:08 AM Subject: [JBoss-user] Select COUNT????? in Entity > Hi all, > I'm using Bean-managed Entity Beans.. > and i wanna do a sql "select count".. > the thing is the finder methods in entity can only return the beans remote > type or a collection of it. > meaning i cannot select count . > > How do i do a sql "count"? > > one way to do work around i guess is to do a sql "select" as per normal , > return collection. and do a collection .size. > but this seems redundant. > i just wan a figure. instead i'm selecting a collection of beans.... > > help > thanks > john > > > > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
