|
To enable WebLogic Server and your LiveCycle deployment to connect
to a manually installed MySQL database, you must create a database
connection for WebLogic Server by setting up a connection pool and
a data source.
Create a new data source for MySQLStart the WebLogic Administration Console by typing http://[hostname]:[port]/console in
the URL line of a web browser.
Type the user name and password that you created for the
WebLogic Server domain and click Log In.
Under Change Center, click Lock & Edit.
Under Domain Structure, click Services > JDBC > Data Sources and,
in the right pane, click New.
On the next screen, set the following properties:
In the Name box, type IDP_DS.
In the JNDI name box, type IDP_DS.
In the Database Type list,
select MySQL and click Next.
In the Database Driver list, select MySQL's Driver (Type 4) Versions:using com.mysql.jdbc.Driver.
Click Next and select Supports Global Transactions and Emulate Two-Phase Commit.
Click Next and define the following properties
that apply to the database you created during your LiveCycle installation
preparations:
Database Name: The name of the database
you have created
Host Name: The name or IP address
of the computer on which MySQL is running
Port: Database
Port. The default is 3306.
Database User Name: The
name of the user you created on the MySQL database
Password and Confirm Password: The
password associated with the user
Click Next and then click Test Configuration to
verify the configuration settings
Note: If the
test is successful, a “Connection test succeeded” message appears. Click Next.
Otherwise, review the error message that appears and modify the settings
as required until the test succeeds.
On the next screen, select the server that the data source
will connect to (in this case, the managed server) and then click Finish.
Configure the connection pool settingsUnder Domain Structure, click Services > JDBC > Data Sources and,
in the right pane, click IDP_DS.
On the next screen, click the Configuration tab > Connection Pool tab.
In the Maximum Capacity box, type 30.
In the Statement Cache Size box, type 80.
Click Save and then click Activate Changes.
Restart WebLogic managed server.
Create a new data source for MySQL for Rights ManagementNote: This procedure applies only if you have Rights
Management installed.
Under Change Center, click Lock & Edit.
Under Domain Structure, click Services > JDBC > Data Sources and,
in the right pane, click New.
On the next screen, set the following properties:
In the Name box, type RM_DS.
In the JNDI name box, type EDC_DS.
In the Database Type list, select MYSQL and
click Next.
In the Database Driver list, select MySQL's Driver (Type 4) Versions:using com.mysql.jdbc.Driver.
Click Next and select Supports Global Transactions and One-Phase Commit.
Click Next and define the following properties that
apply to the MySQL database you created during your LiveCycle install
preparations:
Database Name: The name of the database
you have created
Host Name: The name or IP address
of the computer on which MySQL is running
Port: Database
Port. The default is 3306
Database User Name: The name
of the user you created on the MySQL database
Password and Confirm Password: The
password associated with the user
Click Next and then click Test Configuration to
verify the configuration settings.
Note: If the
test is successful, a “Connection test succeeded” message appears. Click Next.
Otherwise, review the error message that appears and modify the settings
as required until the test succeeds.
On the next screen, select the server that the data source
will connect to (in this case, the managed server) and then click Finish.
Configure the connection pool settingsUnder Domain Structure, click Services > JDBC > Data Sources and,
in the right pane, click RM_DS.
On the next screen, click the Configuration tab and
the Connection Pool tab, and set the following properties:
In the Initial Capacity box, type 1.
In the Maximum Capacity box, type 20.
In the Capacity Increment box, type 5.
In the Statement Cache Size box, type 80.
Restart WebLogic managed server.
|
|
|
