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 Java Database Connectivity (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.