Under typical circumstances, the JDBC connections should not need
to be recreated. The dynamic cluster clones the JDBC connector template from
the WC_demo application server.
About this task
Do the following to configure dynamic operations:
Procedure
- Launch the Deployment Manager Administration Console.
- Select Resources > JDBC Providers.
- Delete any targets in the Node, Cluster or Server box and click Apply.
The scope is now set to the Cell level.
- Create a new JDBC provider. The information will match what the
provider already created for the single application server, but at the Cell
level:
- Database Type: DB2
- Provider Type: DB2 Universal JDBC Driver Provider
- Implementation Type: Connection pool data source
- Name: demo - WebSphere Commerce JDBC Provider
- Description: demo - WebSphere Commerce JDBC Provider
- Class Path: C:/WebSphere/SQLLIB/java/db2java.zip, for
example
- Native Library Path: *blank
- Implementation class name: COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource
- Click Apply Changes.
- Create a data source:
- Name: WebSphere Commerce DB2 DataSource demo
- JNDI Name:jdbc/WebSphere Commerce DB2 DataSource demo
- Use this Data Source in container managed persistence (CMP): Select this
check box.
- Description: WebSphere Commerce DB2 DataSource demo
- Data store helper class name: Click this button.
- Component managed authentication alias: WC_demo - authDataAlias
- Container managed authentication alias: WC_demo - authDataAlias
- Mapping configuration alias: DefaultPrincipalMapping
- Database name: mall
- Connection Pool properties:
- Connection timeout: 180
- Maximum connections: 65
- Minimum connections: 5
- Reap time: 180
- Unused timeout: 1800
- Aged timeout: 1800
- Purge policy: Entire Pool
- Data Source properties:
- Statement cache size: 50
- Enable multithreaded access detection: Deselect.
- Enable database reauthentication: Deselect.
- Enable JMS one-phase optimization support: Deselect.
- Manage cached handles: Deselect.
- Log missing transaction context: Deselect.
- Pretest connections: Deselect.
- Custom Properties:
- Name: URL
- Value: jdbc:db2:mall
- Type: java.lang.String
- Save changes to the master repository.
- Use the Test Connection function to ensure that the database configuration
is correct.