Framework to allow one CMP EJB to connect to multiple data sources

A method for accessing more than one database within an execution environment wherein each database is associated with a respective data source, comprising the steps of:

• receiving a request from an executing container managed persistent enterprise java bean (CMP EJB) to access one of the more than one database;
• selecting one of the data sources from among the respective data sources;
• and
• connecting the CMP EJB to the selected one of the respective data sources.

An apparatus comprising:

• a container managed persistent enterprise java bean (CMP EJB);
• a session EJB configured to interface with the CMP EJB;
• an application server configured to instantiate the session EJB, the CMP EJB, and two or more data sources;
• and
• a mapping module that maps a data request from the CMP EJB to be serviced by one of the two or more data sources.

An apparatus for accessing more than one database server within a J2EE application server platform, the apparatus comprising:

• at least one processor;
• a memory coupled with the at least one processor;
• and
• a program code residing in the memory and executed by the at least one processor, the program code configured to:
• associate each of more than one data source with a respective resource reference;
• identify a mapping between an attribute of a container managed persistent enterprise java bean (CMP EJB) and the respective resource references;
• and
• determine which of the more than one data sources to use to service a call by the CMP EJB to access one of the databases.

A program product for accessing more than one database server within a J2EE application server platform, comprising:

• program code configured upon execution thereof to:
• associate each of more than one data source with a respective resource reference;
• identify a mapping between an attribute of a container managed persistent enterprise java bean (CMP EJB) and the respective resource references;
• and
• determine which of the more than one data sources to use to service a call by the CMP EJB to access one of the databases;
• and
• a computer readable signal bearing medium bearing the program code.