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

A method for accessing a database server among a plurality of database servers within a J2EE application server platform, comprising the steps of:

• associating each of more than one data source with a respective resource reference;
• identifying a mapping between an attribute of a container managed persistent enterprise java bean (CMP EJB) and the respective resource references;
• determining based upon the identified mapping which of the more than one data sources to use to service a call by the CMP EJB to access one of the database servers;
• servicing the call by the CMP EJB by connecting to the determined which of the more than one data sources to access one of the database servers;
• and
• defining the respective resource references within a java artifact that interfaces with the CMP EJB.

A method for accessing a database server among a plurality of database servers within a J2EE application server platform, comprising the steps of:

• associating each of more than one data source with a respective resource reference;
• identifying a mapping between an attribute of a container managed persistent enterprise java bean (CMP EJB) and the respective resource references;
• determining based upon the identified mapping which of the more than one data sources to use to service a call by the CMP EJB to access one of the database servers;
• and
• servicing the call by the CMP EJB by connecting to the determined which of the more than one data sources to access one of the database servers;
• wherein a map is stored in the application server platform that provides the mapping between the attribute of the CMP EJB and the respective resource references, and wherein the map defines which of the respective resource references to use depending on a value of the attribute.

A method for accessing a database among a plurality of databases 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 plurality of databases;
• 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 to access the database associated with the selected data source;
• wherein the step of selecting further includes the step of evaluating an attribute of the CMP EJB to identify the one data source.

A method for accessing a database among a plurality of databases 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 plurality of databases;
• selecting one of the data sources from among the respective data sources;
• connecting the CMP EJB to the selected one of the respective data sources to access the database associated with the selected data source;
• associating with each of the respective data sources a respective resource reference;
• and
• defining the respective resource references within a session EJB that interfaces with the CMP EJB.