Oracle Weblogic Server: Creating a JDBC data source

The data source will be named 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 and jdbc/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, 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.
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.

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.