Data source configuration can be performed entirely in the Oracle Enterprise Manager 10g Application Server Control Console. The online help in the Application Server Control Console provides useful information on data source settings.
Use the following procedure to update the repository configuration in Waveset to point to an Oracle Application Server Data Source.
This section is organized into the following sections:
This example procedure describes configuration steps to use an Oracle database driver. Specific entries you make will differ, depending on your database type.
Log in to the Oracle 10g Application Server Control console (by default, http://localhost:port/me).
On the Cluster Topology page select View By Application Servers.
Click the OC4J home link, then on the OC4J:home page click the Administration link.
Click the Go to Task icon for Services -> JDBC Resources (Create/delete/view data sources and connection pools).
Under Connection Pools, click the Create button.
Select idm from Application drop-down list
Select the New Connection Pool radio button, then click Continue.
On the Create Connection Pool page, configure the new connection pool as follows:
Value |
Action |
---|---|
Name |
Choose a unique name that identifies your connection pool. For example, IdmOraConnPool. |
Connection Factory Class |
Use default value of oracle.jdbc.pool.OracleDataSource. |
JDBC URL |
Specify jdbc:oracle:thin:@//hostname:1521/orcl (or fill in the Connection Information to have a URL generated for you) |
Hostname |
Specify the host name of Oracle DB server. |
Port |
Specify the port (default is 1521) for the database server. |
Username |
Specify the database account users name used in the connection. |
Password |
Specify the cleartext password for the account user. |
Click the Test Connection button to ensure connectivity.
You may need to add additional properties on the Attributes and Properties pages depending on your installation. See the administrator’s guide for your target database.
Click the Finish button.
On the JDBC Resources page, under Data Sources, click the Create button.
Select idm from Application drop-down list.
Select the Managed Data Source radio button.
Click the Continue button.
On the Create Data Source - Managed Data Source page, configure the JDBC Data Source as follows:
Value |
Action |
---|---|
Name |
Choose a unique name for this data source. For example, IdmOraDataSource |
JNDI Name |
Specify the JNDI name. For example, jdbc/idmpool |
Transaction Level |
Use the default value of Global & Local Transactions. |
Connection Pool |
The name of the Connection Pool just created (IdmOraConnPool) should be displayed already. In this example we keep the default value. |
Login Timeout |
Set as desired for your installation. |
It is not necessary to enter Username and Cleartext Password information in the Credentials section unless you need to override the information already provided in the connection pool configuration.
Click the Finish button.
The connection information is saved in your Oracle Application Server’s data-sources.xml file located in the $J2EE/home/application-deployments/idm directory.
Set the WSHOME environment variable to point to your Waveset installation. For example:
set WSHOME=OracleAppServerInstallationDirectory/j2ee/home/applications/idm/idm
Make sure that the JAVA_HOME environment variable is set correctly. For example:
set JAVA_HOME=/product/10.1.3.1/OracleAS_1/jdk |
Create a CLASSPATH environment variable and set it to include the location of the oc4j-internal.jar file. This file is part of the application server distribution and is located here:
OracleAppServerInstallationDirectory/j2ee/home/lib/oc4j-internal.jar
Change to the %WSHOME%\WEB-INF (Windows) or $WSHome/WEB-INF (UNIX) directory.
Make a backup of WEB-INF/ServerRepository.xml file and move it out of the directory. This is your direct connection setup from the original install of Waveset.
Point the repository to the new location using the Waveset lh command. For example:
../bin/lh setRepo -v -tOracle -icom.evermind.server.ApplicationInitialContextFactory -fjdbc/idmpool -n -oServerRepository.xml |
The -f location flag should match the value you selected for the JNDI Name field.
If there are no reported errors, restart your Oracle Application Server to pick up the changes. (This also restarts the Waveset system.)