1. WebServices Installation Guide
  2. Configure RESTful WebService
  3. Statement Timeout Configuration

6.2 Statement Timeout Configuration

When APIs are integrated with Client systems, you may need to specify how long your client system waits for an API call to complete before a timeout occurs. If the Client system times out earlier than the API call, you may see inappropriate responses.

Hence, a client timeout value higher than the API response time is required to avoid such a situation.

Ensure that the time out settings is always defined in decreasing order. Which means, the time out value of managed components configured between the 'Client Server' and 'OFSLL Managed Servers' should have decreasing value so that last managed server before OFSLL has least timeout value.

Follow the below steps to set the statement timeout value.

  1. Login to WebLogic Server 12c console (http://hostname:port/console) using the valid credentials.
  2. Click Domain Name > Services. The following screen is displayed:

    Figure 6-11 JDBC Data Sources window


    Description of Figure 6-11 follows
    Description of "Figure 6-11 JDBC Data Sources window"

  3. Click the Data Source from the LHS menu and click on the configured Restful data source (for example ‘OfsllREST’).
  4. Click Connection Pool tab. The following screen is displayed.

    Figure 6-12 Connection Pool tab


    Description of Figure 6-12 follows
    Description of "Figure 6-12 Connection Pool tab"

  5. Click Lock & Edit option from the Change Center menu.
  6. Scroll down and click the Advance option. The following screen is displayed.

    Figure 6-13 Advance option - Statement Timeout


    Description of Figure 6-13 follows
    Description of "Figure 6-13 Advance option - Statement Timeout"

  7. Set the Statement Timeout value as appropriate. This is the time after which a statement currently being executed will time out. For more information, refer to “Guidelines_OFSLL API Timeout Period.pdf” shared along with fix.
  8. Once done, for changes to take effect, you need to restart the Data Source. Click on the View changes and restarts from the Change Center menu.

Parent topic: Configure RESTful WebService