Databases Reference
In-Depth Information
6. Select the Oracle option from the Database Type drop-down menu. Click on the
Next button.
7. Choose
*Oracle's Driver (Thin) for Service connections;
Versions:9.0.1 and later
from the Database Driver drop-down menu.
Click on the Next button.
8. Leave the default values for the Transaction options and click on the Next button.
9. On the Connection Properties page, type
dbservice
in the Database Name field,
dbhost
in the Host Name field, and
1521
in the Port field. Complete the Database
User Name, Password, and Confirm Password fields by typing
dbuser
and
dbpwd
as the username and password respectively. Click on the Next button.
10. Click on the Next button on the Test Database Connection page.
11. Select the All servers in the cluster radio button from the
PROD_Cluster
cluster.
Click on the Finish button.
12. Then, click on the Activate Changes button.
How it works...
A new non-XA JDBC data source was created with the parameters required by the
DBApp
application. The non-XA Oracle JDBC driver is the thin version. All other parameters were
left as their default values.
The Oracle driver class name used for non-XA data sources is
oracle.jdbc.OracleDriver
.
There's more...
We will now see how to create the JDBC data source through WLST.
Creating the JDBC data source using WLST
1. Log in as a
wls
user to shell and start WLST:
[wls@prod01]$ $WL_HOME/common/bin/wlst.sh
2. Connect to the Administration Server using
wlsadmin
as the user,
<pwd>
as the
password, and
t3://adminhost.domain.local:7001
as the server URL:
wls:/offline> connect("wlsadmin","<pwd>","t3://adminhost.domain.
local:7001")
Search WWH ::
Custom Search