Isee... so you do not inplement a finder methods for this... well, i'll try it out... Thanks... Kar
John ----- Original Message ----- From: "Kar YEOW" <[EMAIL PROTECTED]> To: "Jboss Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, October 16, 2001 3:13 PM Subject: Re: [JBoss-user] Select COUNT????? in Entity > Have a method in your home interface say > public interface UserHome extends EJBHome { > int getUserCount() throws RemoteException; > } > > then in you ejb bean class you implement the method say > > public class UserBean extends .... { > public int ejbHomeGetUserCount() { > ... do your "select count(*)" sql here > ... etc > return count; > } > > } > > hope this help. Kar > ----- Original Message ----- > From: "John LYC" <[EMAIL PROTECTED]> > To: "Kar YEOW" <[EMAIL PROTECTED]>; "Jboss Mailing List" > <[EMAIL PROTECTED]> > Sent: Tuesday, October 16, 2001 5:14 PM > Subject: Re: [JBoss-user] Select COUNT????? in Entity > > > what do you mean? > John > > ----- Original Message ----- > From: "Kar YEOW" <[EMAIL PROTECTED]> > To: "Jboss Mailing List" <[EMAIL PROTECTED]> > Sent: Tuesday, October 16, 2001 2:54 PM > Subject: Re: [JBoss-user] Select COUNT????? in Entity > > > > Try using Home Interface. Kar > > ----- Original Message ----- > > From: "John LYC" <[EMAIL PROTECTED]> > > To: "Jboss Mailing List" <[EMAIL PROTECTED]> > > Sent: Tuesday, October 16, 2001 1:08 PM > > 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 > > > > > _______________________________________________ > 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