Configuring the Web Server ■ Deploying CCA Web Applications on WebLogic 8.1 SP5
2From the Database Type
3From the Database Server
4Click Continue.
5From the Define Connection Properties page, enter your database configuration information: a Name: Remove MyJDBC Connection Pool and enter the database name.
b Connection Properties:
❏Database Name: name of CCA database. For example, cc81.
❏Hostname: database server name or IP address. For example,
❏Port: Listening port of database server. By default, 1433 is used by Ms SQL Server.
❏Database User Name: name of user who has access to database. Refer to parameter %6 in Creating a New Database on MS SQL Server 2000 section. For example, cc81.
❏Password: password of the database user. For example, cc81.
6Click Next.
7From the Test Database Connection page, click Test Driver Configuration. If a green Connection Successful message appears, click Create and Deploy.
8After the Connection Pool is created, you can define the connection configuration of the JDBC connection pool.
a Click the Connection Pool that you created. b Select the Connections tab.
9Change the Initial Capacity to 25, and the Maximum Capacity to 50.
10Click Show at the bottom right of the page to display the Advanced Options that must be edited. You may need to scroll down the screen to see the options.
a Set the Test Frequency: 300
b Select the check box for Test Reserved Connections. c Set the Connection Creation Retry Frequency to 300 d Leave other fields as default.
11Click Apply.
Configuring the JDBC Data Source
Complete the steps in the following procedure to configure the JDBC data source.
To configure the JDBC data source
1In Services > JDBC > Data Sources, click the link Configure a new JDBC Data Source.
2From the Configure a JDBC Data Source page, enter your database name in both the Name and JNDI Name text boxes.
44