Hi, Is there any way to load a number of entity beans (BMP) by doing one querry to database? I intend to get all the data for say, 500 entity bean in one querry and want to populate 500 entity beans. I want to save 500 calls to the database (ejbload for each entity beans). Similarly at the time of storing I dont want to generate 500 ejbstore(), instead I want to use batch storing. Any comment on how to improve database access preformance will be greatly appreciated. Regards, SRP _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user