Search Results


Monday, April 18, 2016

Weblogic Datasource Setup

How to create datasource for ADF application 11g/12c

  • Goto Weblogic Console
  • Select Data Sources on the Home Page
  • Click New → Generic Data Source
    • Enter the following and click Next
    • Name: AppDataSource
    • JNDI Name: jdbc/AppDS
    • Database Type: Oracle
  • Choose the JDBC driver type and click Next:
    • Database Driver: *Oracle’s Driver (Thin) for Instance Connections; Versions: Any
  • Leave the default Transcation Options and click Next :
  • Enter the database connection properties and click Next :
    • Database Name: TBD
    • Hostname: TBD
    • Port: TBD
    • Database User: apps
    • Password: TBD
    • oracle.jdbc.DRCPConnectionClass: --Blank-
  • Test the configuration and Click Next:
  • Select the Target Server: It must be targeted to the cluster or servers where the ADF app is deployed (Exclude AdminServer from the target).
  • And finish.

How to create XADatasource for SOA Suite 11g/12c

Datasource

  • Goto Weblogic Console
  • Select Data Sources on the Home Page
  • Click New → Generic Data Source
    • Enter the following and click Next
    • Name: AppDataSource
    • JNDI Name: jdbc/AppDS
    • Database Type: Oracle
  • Choose the JDBC driver type and click Next:
    • Database Driver: *Oracle’s Driver (Thin XA) for Instance Connections; Versions: Any
  • Leave the default Transcation Options and click Next :
  • Enter the database connection properties and click Next :
    • Database Name: TBD
    • Hostname: TBD
    • Port: TBD
    • Database User: apps
    • Password: TBD
    • oracle.jdbc.DRCPConnectionClass: --Blank-
  • Test the configuration and Click Next:
  • Select the Target Server: It must be targeted to the SOA cluster or SOA managed servers (Exclude AdminServer from the target).
  • And finish.
  • Remember to create JNDI name to access this datasource from DB adapter or AQ adapter .
    • This steps is only for SOA suite.

DB Adapter (Only for SOA)

  • Select Deployments on the Home Page
  • Click DbAdapter from the list
  • Select tabs Configuration > Outbound Connection Pools
  • Click on New button and select javax.resource.cci.ConnectionFactory
  • Enter JNDI Name : eis/DB/apps
    • This JNDI name should be same as the one entered in *.jca file.
  • Click on Finish 
  • Now expand the javax.resource.cci.ConnectionFactory and click on the JNDI name you just created.
  • Enter the data-source name.
    • For XA Datasources enter XADatasourceName
    • For non-xa datasources just enter DatasourceName
    • Remember to hit Enter on the keyboard as this form only registers data on keyboard enter.
  • Click on Save button
  • Go back to the Deployments page.
  • Select the DbAdapter and click on Update
  • Select Update option and click on finish
    • If its the first time, the user will be asked to create a directory path for plan file. Choose the location when asked.

AQ Adapter (Only for SOA)

  • Steps to create JNDI name for AQ adapter is same as DB adapter. It just needs repeating the above steps for AqAdapter in the deployments.


Post a Comment