Aggregate queries are usually best performed by a SLSB using an SQL statement. One exception is if the query range is a small number of records whose corresponding EBs can be readily activated by a finder, e.g. a sum over a user's account balances where the account EBs are fetched by a UserHome finder. The finder alternative is esp. appropriate if the use case calls for a subsequent drill down into the detail EBs. Moral: depends on the app usage model, as usual.
Fred Loney Spirited Software, Inc. www.spiritedsw.com ----- Original Message ----- From: "IvanLatysh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 24, 2001 7:40 AM Subject: [JBoss-user] Please help me ... > > Hi All. > > I have got one problem and I can't get the right way. > > I have database and I wrap this database with EntityBeans. > But now I need build report and I need summary information (in SQL: select sum(myColumn) from > myTable group by myID) > > I see any ways how to do it. > 1. Build the new EntityBean which will execute SQL and will represent summary information (but I > see something wrong here) > 2. Build a SessionStateless bean and execute SQL to get this summary information > 3. Build SessionStateless bean to get data from my EntityBean-s and group this data manualy. > > My question - how to have it done more easely and in right way. > > Sincerely yours, Ivan Latysh. > [EMAIL PROTECTED] > http://ivan.yourmail.com > > > _______________________________________________ > 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