To enable WebLogic Server and your AEM forms on JEE 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 MySQL
-
Start 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 AEM forms on
JEE 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 settings
-
Under 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 Management
Note:
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 AEM forms on
JEE 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 settings
-
Under 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.
|
|
|