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