Bind to a data source
Overview
During either application assembly or deployment, bind the resource reference to the actual name of the resource in the run time environment. We can take this action in the assembly tool or as one of the steps during installation of the application EAR file.
Bean-managed persistence bean
When developing your bean-managed persistence (BMP) bean you generally lack knowledge about the name of the data source on the target application server. In your code, do not look up the data source directly. Instead, you look up the resource reference from the java:comp/env namespace file. Let us assume that you look up the resource reference named ref/ds as illustrated in the code below
javax.sql.DataSource dSource = (javax.sql.DataSource)((new InitialContext()).lookup("java:/comp/env/ref/ds"));In the assembly tool, you specify the name ref/ds in the Resource Reference page on the General Tab. If you know the name of the data source one can specify it in this Resource References page on the Bindings Tab. Note that if you do not specify it here , provide this JNDI name when you install the application EAR file.
Container-managed persistence bean
The data source binding process for the container-managed persistence (CMP) bean is the same process that you perform for BMP beans. Use the data source JNDI name as a WebSphere binding property for each bean during application assembly.
Servlets and JavaServer Pages Files
In a servlet application, you look up the DataSource exactly as you look it up in the BMP bean case.
See Also
Connection factory
Data sources
Unshareable and shareable connections
Create and configure a JDBC provider and data source using the JMX API
Configure data access for the Application Client
Create or change a resource reference
Assemble data access applications
Migrate a V4.0 data access application to v6
Create and configure a JDBC provider and data source