![]() ![]() ![]() ![]() ![]() ![]() ![]() |
This section provides examples for specific tasks using the Configuration Wizard. The topics include:
The following example explains the procedure to create a new Oracle WebLogic Integration domain that uses a database other than the default PointBase database.
Note: | Always define p13nDataSource and cgDataSource-nonXA with a non-XA driver. For example, when configuring a domain for Oracle, use Oracle Driver (Type 4) with these data sources. |
Note: | For every other data source, a tab is displayed in the Configure JDBC Data Sources panel for Database Type and Driver configuration. The remaining data sources can be defined with either an XA or non-XA Driver, as required. When each data source is configured, click Test Connections to display the Test Data Source Connections window. Test each database source to verify database connectivity. Go back to the Configure JDBC Data Sources window to check and correct any database connectivity issue before proceeding. |
Note: | Ensure that the database to which you want to test the connection is running. |
Click Next to proceed to the Run Database Scripts window.
Note: | In the Results pane, verify that Database Load Successful is returned for each Run Script execution. Otherwise, correct the problem before proceeding. |
In the Create WebLogic Domain window, type a name and location for your new Oracle WebLogic Integration domain, click Create. Once the domain is created, the server for Oracle WebLogic Integration is ready to be started.
The following example explains the procedure to create a new Oracle WebLogic Portal domain that uses a database other than the default PointBase database. For additional information about configuring an Enterprise-Quality Database, see the WebLogic Portal Database Administration Guide at the following URL:
http://download.oracle.com/docs/cd/E13219_01/wlp/docs103/db/index.html
Note: | The WebLogic Server check box is selected by default since it is a prerequisite for all Oracle WebLogic domains. |
Note: | The WebLogic Portal checkbox is selected by default since it is a prerequisite for WebLogic Portal GroupSpace. |
Please keep the following considerations in mind:
BEA_HOME/portal/db/jdbc/README.txt
. This Readme file includes additional important information about database specific data source settings and XA JDBC Driver usage. It also describes a process for switching a default PointBase domain to a domain using an Enterprise Quality Database, without using the Configuration Wizard guide to modify each data source.
The MySQL JDBC driver is not fully XA compatible, therefore Oracle WebLogic Portal does not support using com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
. Data sources that require XA, and those that are XA capable, should use the com.myself.jdbc.Driver
with the global-transactions-protocol LoggingLastResource
instead.
Always define portalDataSourceAlwaysXA
with an XA driver. For example, when configuring a domain for Oracle, use Oracle Driver (Type 4 XA).
Always define p13nDataSource
and cgDataSource-nonXA
with a non-XA driver. For example, when configuring a domain for Oracle, use Oracle Driver (Type 4) with these data sources.
For every other data source, a tab is displayed in the Configure JDBC Data Sources panel for Database Type and Driver configuration. The remaining data sources can be defined with either an XA or non-XA Driver, as required. When each data source is configured, click Test Connections to display the Test Data Source Connections window. Test each database source to verify database connectivity. Go back to the Configure JDBC Data Sources window to check and correct any database connectivity issue before proceeding.
Note: | If you selected the WebLogic Portal GroupSpace Framework check box in step 3, and you want to use a database other than PointBase for the GroupSpace Database, appsGroupSpaceDataSource will require data source configuration. For example, to use an Oracle database with the WebLogic Portal GroupSpace Framework configure appsGroupSpaceDataSource , to use Oracle Driver (Type 4) and specify a user name and password that is unique for WebLogic Groupspace. For more information, see the WebLogic Portal Database Administration Guide at the following URL:http://download.oracle.com/docs/cd/E12840_01/wlp/docs103/db/oracle.html#wp1070839 Ensure that the database to which you want to test the connection is running. |
Also, if you selected WebLogic Portal GroupSpace Framework in Step 3, select the appsGroupSpaceDataSource
in Available JDBC Data Sources, and then click Run Scripts to load the database objects for the WebLogic Portal GroupSpace Framework.
Note: | In the Results pane, verify that Database Load Successful is returned for each Run Script execution. Otherwise, correct the problem before proceeding. |
The following example explains how to create a new Oracle Service Bus domain that uses a database other than PointBase for your JMS Reporting Provider.
The JMS Reporting Provider in the Service Bus template is preconfigured to use the PointBase database provided with your installation. In this example, we want to select a different database. Select Yes and click Next.
Servers can be reached through the following URL: protocol
://
listen-address
:
listen-port
For more information, see Configure the Administration Server.
In this example, you can either accept the default values, or enter configuration information specific to your Administration Server.
Click Next to proceed to the Configure Managed Servers window.
Click Next to proceed to the Configure Machines window.
Click Next to proceed to the Configure JDBC Data Sources window.
The JMS Reporting Provider data source (wlsbjmsrpDataSource
) is preconfigured to use the PointBase database. To use an alternate database, make the following edits in this window:
Note: | For a list of the supported drivers, see “Supported Database Configurations” in Supported Configurations for Oracle Service Bus 10g Release 3 (10.3) at
http://download.oracle.com/docs/cd/E12840_01/platform/configs_osb10gr3/osb10gr3/index.html . |
When you have completed all the required fields in this window, click Test Connections to display the Test Data Source Connections window.
Note: | Make sure that the database to which you want to test the connection is running. |
To test the connection from the wlsbjmsrpDataSource
data source to the database you specified, click Test. Verify that the test was successful, then click OK to return to the Configure JDBC Data Sources window.
Click Next to proceed to the Run Database Scripts window.
If you selected Development for the server start mode in Step 5, the database tables are created automatically when the JMS Reporting Provider is deployed.
If you selected Production for the server start mode in Step 5, you must execute the database scripts to create the JMS Reporting Provider tables, as described below. To do so:
wlsbjmsrpDataSource
.\wlserver_10.3\common\lib\jdbc.log
where:
BEA_HOME
is the directory containing the product installation.To confirm that the tables were created successfully, review the results in the Results pane.
In this example, you do not need to modify the JMS file store definition.
The Domain Summary pane shows the Deployment view by default. By selecting different options from the Summary View drop-down list, you can see different views of the domain summary, for example, the Cluster view.
Select an item in the Domain Summary pane on the left and review the associated details in the Details pane on the right. You can make limited adjustments by clicking Previous to return to a prior window.
After reviewing the contents of your domain, click Next to go to the Create WebLogic Domain window.
For example, you may want to name this servicebus_domain
.
By default, the domain is created in BEA_HOME
\user_projects\domains\
domain
, where BEA_HOME
is the directory that contains the product installation, and domain
is the domain name that you specify (servicebus_domain
in this example). Click Create.
![]() ![]() ![]() |