JDBC Adapter 

Purpose

The JDBC adapter enables you to connect database systems to the Integration Server or the PCK. The adapter converts database content to XML messages and the other way around.

Database content can be read with any SQL statement, including stored procedures. A special XML format is defined for content coming from the Integration Server or PCK. This format enables SQL INSERT, UPDATE, SELECT, DELETE, or stored procedure statements to be processed. A message is always processed in exactly one database transaction.

Implementation Considerations

To be able to use the JDBC adapter you must install the JDBC driver for the database that you want to connect to. The required Java libraries are product-specific and must be obtained from the database vendor. Following installation, you must deploy the Java libraries on the J2EE server so that the JDBC adapter can access the required Java classes at runtime.

 

For an FAQ on the JDBC adapter, see SAP Note 831162.

 

Integration

You configure the adapter in the configuration part of the Integration Server/PCK.

The receiver JDBC adapter can be used for mapping lookups. See also: Mapping Lookups

Features

·        To send content from databases to the Integration Server/PCK, configure the sender JDBC adapter.

·        To save XML messages from the Integration Server/PCK in a database, configure the receiver JDBC adapter.

The receiver adapter supports system acknowledgments but not application acknowledgments.