Creating and Configuring Request-Response Service

Request-Response Service often acts as a Request Reply server or Remote Procedural Call (RPC) server. When running Request-Response Service, the adapter receives requests from other applications, parses them, and translates them into queries to the database to retrieve data. The output data is wrapped in an MInstance and sent back to the caller.

For details, see the following configurations:
  1. Request-Response Implementation
  2. Creating Request-Response Service
  3. Fetching a Schema Object for Custom RPC Service
  4. Selecting a Service Mode
  5. Using Quotes in Microsoft SQL Server
  6. Using the REF Data Type with Oracle Databases
  • Request-Response Implementation
    With Request-Response Service, client applications can send SQL statements, stored procedures, functions, or packages on a specified subject to an adapter configuration. The adapter processes the request and returns the results in a response to the client.
  • Creating Request-Response Service
    Before you configure Request-Response Service, you have to create a service of Request-Response Service.
  • Fetching a Schema Object for Custom RPC Service
    You must fetch a stored procedure, function, or package when you create custom RPC Service. However, you do not have to fetch a schema object for Request-Reply RPC Service and standard RPC Service.
  • Selecting a Service Mode
    You can configure Request-Response Service to use different modes to interact with other applications. Request-Response Service supports three service modes: Request-Reply mode, standard RPC mode, and custom RPC mode. You have to select a service mode depending on your specific requirements.
  • Using Quotes in Microsoft SQL Server
    When you construct a request in a client application to send to the adapter with a Microsoft SQL Server database, you must note the use of double quotation marks in quotes.
  • Using the REF Data Type with Oracle Databases
    The adapter supports the use of the REF data type (cursor) as an OUT parameter only in an Oracle stored procedure. The adapter returns a result in the same way as it does a result set from a SELECT query. The exact usage depends on the driver used.