Hi, You're doing a BMP bean, so you work with jdbc already, why don't you just define a method count() on the bean and call "SELECT COUNT * FROM blabla" on the datasource....
In my opinion you don't have to use only findBYXXX methods... Joost. -----Original Message----- From: John LYC [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 16, 2001 5:08 AM To: Jboss Mailing List 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