or,
#4) Rather than a new entity bean, use the existing entity bean and put a new method that grabs the datasource from jndi, gets a connection, runs the query and closes (hands back) the connection.
I have done #2 & #4, more often #2.
#1 won't buy you anything except more beans to manage.
#3 is a waste of system resources
John
-----Original Message-----
From: IvanLatysh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 7:41 AM
To: [EMAIL PROTECTED]
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