Deepak, I believe you can create a separate data-source for each server, and put this in the data-source.xml. Then use a 1-1 mapping between each entity bean and the data-source. If you already have your entity bean(s) (I would use some kindof simple naming convention for your entity bean(s) to reflect their the server mybean1, mybean2, mybean3, etc. the only difference between them is their reference to each separate data-source), you can use your session bean to select which of the entity bean's to grab. Of course, you would then have to properly describe each of these in your ejb-jar.xml and application.xml. Its brute force, but its gotta work. Regards, Lawrence -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Goel, Deepak Sent: Thursday, September 21, 2000 6:39 PM To: Orion-Interest Subject: Deploying same set of EJBs on single Orion Server but multiple data servers Hello everyone, I have a set of EJBs which I have finally managed to run on Orion. Now, I want that the database server to which these EJBs talk be changed dynamically at run-time. For example, I have about 10-15 servers all having exactly the same database schema. Now depending on the client request, when I want to instantiate an EJB I may have to look up at any of these 10-15 servers. I know that this is not specific to Orion but I'll appreciate any help on how to do this with Orion. TIA, Deepak Goel
