About this task
Using the administrative console, follow these steps to create a
proxy data source.
Procedure
- Select Resources > JDBC Providers.
- Create a cluster-wide Proxy DataSource JDBC provider. To create
a cluster-wide JDBC provider, set the scope to cluster level, then select
the cluster you want. Make sure you see a red arrow on the left of the cluster.
- Click New.
- Select Proxy as the database type.
- Select Proxy DataSource JDBC Provider as the provider type.
- Select connection pool data source as the implementation
type.
- Click Next.
- Select Proxy DataSource JDBC Provider from the list. Click OK.
- Click Apply on the Proxy DataSource JDBC Provider.
- Click Data Sources.
- Click New.
- Set Name to dsSampleDSProxy.
- Set JNDI Name to jdbc/dsSampleDSProxy.
- The Use this Data Source in container managed persistence (CMP) check
box is checked by default. Make sure it is checked.
- Leave Specify a user-defined data store helper field as
is. The helper class is com.ibm.websphere.rsadapter.ProxyDSDataStoreHelper.
- Select <CELL>/alias1 as the Component-managed Authentication
Alias.
- Leave others as the default.
- Click custom properties. Set jndiNames to jdbc/WestDS;jdbc/EastDS.
- Click Apply.
- Click Save to save all configurations. The test connection
will not work for Proxy DataSource.