2.1 Creating Data Sources for RESTful WebService

Please follow the below steps to create data Sources for RESTful WebService.
  1. Login to Oracle Weblogic 14c em (http://hostname:port/em).

    Figure 2-1 Create RESTful WebService 1



  2. Click WebLogic Domain > JDBC Data Sources.
    The following window is displayed.

    Figure 2-2 Create RESTful WebService 3



  3. Click Lock & Edit on the Change Center. Click ‘Create’ and select ‘Generic Data Source’.
    The following window is displayed.

    Figure 2-3 Create RESTful WebService 4



  4. Specify the following details:
    1. Enter Data source Name: OfsllREST
    2. Click on Select
  5. Select the Database Driver ‘Oracle's Driver(Thin) for Services connections;Versions:Any’
  6. Click Ok.
  7. Specify the following details:
    • Enter the JNDI Name as ‘jdbc/OfsllWSDS’.
    • Click Next.


  8. Click Next.
  9. Enter the Database details.
    • Click Ok.
    The following window is displayed.

  10. Enter OFSLL DB schema “Password” and Confirm Password”.
    • Click Test Database Connection. On completion, displays a confirmation message as ‘Connection test succeeded’.


  11. Initial capacity and Maximum capacity is defaulted to 30, if the number of concurrent users are more this needs to be increased.
  12. Click Advanced and update the ‘Inactive Connection Timeout’ to 300 seconds.
    • Click Next.

    The following window is displayed.



  13. Click Next.
  14. Click Next.
    • Select target Server as ‘WS_ManagedServer’.
    The following window is displayed.

  15. Click Create to activate the changes
  16. Activate Changes from Change Center.