The service platform provides various service adapters, for various purposes (such as for other systems, databases, or files). Also, general custom adapters, which are developed by using the custom adapter development framework, are provided to support systems using protocols that are not supported by the provided service adapters.

The table below describes the types of service adapters that can be used in the service platform.

For details about the definitions of individual service adapters, see Chapter 3. Defining Adapters.

Table 1-2 Types of available service adapters

Type	Purpose
SOAP adapter	Used to call a service component by using a Web service (SOAP communication).
Session Bean adapter	Used to call a service component by using Session Bean.
MDB (WS-R) adapter	Used to call a service component created by MDB (Message Driven Bean), by using WS-R (WS-Reliability).
MDB (DB queue) adapter	Used to call an asynchronous service component by using the DB queue.
DB adapter	Used when a database operation is used as a service component.#
TP1 adapter	Used to call a service component in an existing OpenTP1 system.
File adapter	Used to directly perform input/output operations on a file in the local disk of the HCSC server.
Object Access adapter	Used to call a service component of an existing TPBroker system (Object Wrapper system).
Message Queue adapter	Used to send and receive messages to and from an existing message queue (IBM WebSphere MQ system).
FTP adapter	Used to send and receive files between the service platform and the FTP server.
File operation adapter	Used to perform layout conversion, character code conversion, replication, deletion, compression, and expansion of files.
Mail adapter	Used to call the mail server that supports the SMTP protocol as a service component on the service platform.
HTTP adapter	Used to call a Web service (RESTful Web service) that is opened to the public in the REST style.
General custom adapter	Used to call a service component of a system using a protocol that is not supported by the service adapters provided with the service platform.

#

You need to define the database to be operated and the SQL to be executed.