Oracle Weblogic Server: Creating a JDBC data source
The data source will be named
Carry out the following steps to create a JDBC data source:
The Oracle driver class name used for non-XA data sources is
ds-nonXA
using the required JNDI jdbc/ds-nonXA
. The target will be the cluster PROD_Cluster
, the same target as that of the DBApp
application. The database username is dbuser
and the password is dbpwd
.Carry out the following steps to create a JDBC data source:
- Access the Administration Console with your web browser at
http://adminhost.domain.local:7001/console
. - Click on the Lock & Edit button to start a new edit session.
- Click on the plus sign to open the Services tree on the left, and then click on Data Sources.
- Click on the New button and then click on Generic Data Source.
- Type
ds-nonXA
in the Name field andjdbc/ds-nonXA
in the JNDI Name field. - Select the Oracle option from the Database Type drop-down menu. Click on the Next button.
- 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. - Leave the default values for the Transaction options and click on the Next button.
- On the Connection Properties page, type
dbservice
in the Database Name field,dbhost
in the Host Name field, and1521
in the Port field. Complete the Database User Name, Password, and Confirm Password fields by typingdbuser
anddbpwd
as the username and password respectively. Click on the Next button. - Click on the Next button on the Test Database Connection page.
- Select the All servers in the cluster radio button from the
PROD_Cluster
cluster. Click on the Finish button. - Then, click on the Activate Changes button.
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
.
0 Comments