I have an EJB that performs some calculations from values retrieved from some database. The logic for performing the calculations are the same though the values are retrieved from different databases. One of the database is the Employee database and the other one is the Contractor database. Since the calculation logic is the same, my approach is to bind the same EJB classes to 2 different JNDI names, namely EmployeeCalculatorEJB and ContractorCalculatorEJB.
Now, I need to pass a different Datasource object to each of these beans so that they read from the relevant database (ie either Employee or Contractor database). How do I pass these types of information such that the beans are able to know whether they should read from which Datasource?
Let me elaborate further. I created 2 session bean entries in ejb-jar.xml though using the same EJB classes. Furthermore, I bind it to different JNDI names.
Use the resource reference element in the ejb-jar.xml.
Define the SAME resource reference in both ejb's
And then bind this same name (jdbc/paidworkerDB) to the respective JNDI name of each different database connection pool.
Otherwise, set some environment variable:
Won't there be a JNDI naming conflict if EmployeeCalculatorEJB and ContractorCalculatorEJB refers to different datasources within the same container?
I don't think that you will have JNDI problems. it is only a matter that you will have two different DataSources bound to two different JNDI. as the guys mentioned to you in the deployment Descriptor, you define to the Bean which one it should get its data from.
Moreover, you need to define those DataSources in your Application Server, in case of Weblogic, you define two different Databse Pools, one for Employee and the other for the Contractor. Even if these two Database are in two different IPs, Weblogic will able to manage these pools and creat them to you while Server start up.