7.1.3 Non-XA Enabled Data Source

This topic explains the systematic instructions to create the Non-XA enabled data source in the Weblogic application server.

Follow the steps given below to create the XA enabled data source for Gateway Application (MDB):

1. Start the Administration Console of WebLogic Application server.
   You can start the Application by opening the Oracle Weblogic Remote Console application post installing the application from the link https://github.com/oracle/weblogic-remote-console/releases.
   The WebLogic Remote Console screen is displayed.

   Figure 7-12 WebLogic Remote Console

   
   

   
   Description of "Figure 7-12 WebLogic Remote Console"

   
   
2. Click Providers and select Add Admin server Connection Provider.
   The user must enter the required URL, username, and password to establish a connection to the Admin Console.
   The Edit Admin Server Connection Provider popup window is displayed.

   Figure 7-13 Edit Admin Server Connection Provider

   
   

   
   Description of "Figure 7-13 Edit Admin Server Connection Provider"

   
   
3. Click Edit Tree icon after logging into the WebLogic Console.
   The following screen is displayed.

   Figure 7-14 Weblogic Remote Console_Edit Tree

   
   

   
   Description of "Figure 7-14 Weblogic Remote Console_Edit Tree"

   
   
4. Go to Services and then select Data Sources.
   The Data Sources screen is displayed.

   Figure 7-15 Weblogic Remote Console_Services_Data Sources

   
   

   
   Description of "Figure 7-15 Weblogic Remote Console_Services_Data Sources"

   
   
5. Double-click on the data source created to edit, make the necessary changes, and save them.
   The following screen is displayed.

   Figure 7-16 Modify Data Sources

   
   

   
   Description of "Figure 7-16 Modify Data Sources"

   
   
6. Click New to create a new data source.
   The following screen is displayed.

   Figure 7-17 Create a New Data Source

   
   

   
   Description of "Figure 7-17 Create a New Data Source"

   
   
7. On the Create a New JDBC System Resource screen, specify the fields.
   For more information on fields, refer to the field description table.

   Table 7-3 Create a New JDBC System Resource

   Field	Description
   JDBC Datasource Name	Name of the data source. SMSIS147OJETWLY
   JNDI Name	JNDI name which will be used for lookup. jdbc/SMSIS147OJETWLY_XA
   Database Type	Specify the database type as Oracle from the drop-down list. Oracle
   Data Source Type	Generic Data Source
   Database Driver	*Oracle's Driver (Thin) for Application Continuity Versions: Any
   Global Transactions Protocol	OnePhaseCommit
   Database Name	DB Service Name
   Host Name	DB Host Name
   Port	DB Port Number
   Database Username	Data Base user name
   Password	Data Base Password

   Figure 7-18 Specify Details

   
   

   
   Description of "Figure 7-18 Specify Details"

   
   
8. Click Create.
   The following screen is displayed.

   Figure 7-19 Click Create

   
   

   
   Description of "Figure 7-19 Click Create"

   
   
9. Click Test Configuration to test the Data source.
   The Applications get a database connection from a data source by looking up the data source on the Java Naming and Directory Interface (JNDI) tree and then requesting a connection. If the connection is established successfully, the message Successfully connected to this data source's database from the WebLogic domain's Administration Server is displayed.
   The following screen is displayed.

   Figure 7-20 Test Configuration Information Message

   
   

   
   Description of "Figure 7-20 Test Configuration Information Message"

   
   
10. You can view the data source created under Data Sources in the Services.
    SMSIS147OJETWLY_XA datasource has been created.
    The following screen is displayed.

    Figure 7-21 View Data Sources

    
    

    
    Description of "Figure 7-21 View Data Sources"

    
    
11. Click the View or Commit icon to view or commit the changes.
    The following screen is displayed.

    Figure 7-22 View or Commit Changes

    
    

    
    Description of "Figure 7-22 View or Commit Changes"

    
    
12. Select Commit Changes option to apply the changes.

    SMSIS147OJETWLY datasource is created

    The following screen is displayed.

    Figure 7-23 Changes Applied Information Message

    
    

    
    Description of "Figure 7-23 Changes Applied Information Message"

    
    

    Note:

    • You need to create another data source for Oracle FCIS with the JNDI name <Non-XA FCIS HOST JNDI name>_ASYNC. For example, if the Oracle FCIS HOST Non XA data source JNDI name is jdbc/fcjdevDS, then you need to create another data source for FCIS with the JNDI name jdbc/fcjdevDS_ASYNC.
    • While creating a branch using the Branch Parameters Maintenance (STDBRANC) screen, if you have created a data source for the branch, then you need to create a corresponding ASYNC data source with the JNDI name <Non-XA FCIS BRANCH JNDI name>_ASYNC.