JDBC Connector Service 

Purpose

This component is a resource adapter based on the Java Database Connectivity (JDBC) standard to enable you to connect to databases. It provides functions for creating and managing DataSource objects, as well as database connection pooling.

Implementation Considerations

You must install this component if your applications use a relational database. In addition, you need the Connector Container Service installed as well.

Integration

The JDBC Connector Service is part of the J2EE Engine connector architecture, which is designed to implement the requirements of the J2EE Connector Architecture 1.0 standard. Within this frame the JDBC Connector Service is strongly related to the Connector Container Service since it is the central managing module for all types of connections to back-end systems.

For more information about the connector architecture in the J2EE Engine, refer to J2EE Connector Architecture in the Development Manual.

Features

JDBC Connector Service offers a wide range of functions to enable easy and fast connectivity to databases by various vendors:

·         Support for both JDBC 1.x and JDBC 2.0 drivers – the mechanism for obtaining a connection with JDBC 1.x or with a JDBC 2.0-compliant driver is different, but you can use either type of driver as JDBC Connector Service supports both mechanisms.

·         Connection pooling and re-using – when the client releases a connection, the JDBC Connector Service stores it in a pool on a per DataSource basis, and it can be reused next time a client sends a request for connection; system performance therefore improves since creating a new connection is resource-consuming.

·         Support for both local and distributed transactions – the JDBC Connector Service is implemented to work in a distributed environment, but it also supports local transaction optimization.

·         Database independence using the Database Interface (DBI) – the integration of the JDBC Connector Service to the DBI enables uniform access to various databases, thereby enhancing the platform independence provided by Java™ with the database independence provided by SAP DBI. Furthermore, it enables J2EE Engine to fully integrate within the SAP Web Application Server.

Using the JDBC Connector Service, you can:

●      Create either JDBC 1.x or JDBC 2.0 compatible DataSource objects

●      Import and export DataSource objects

●      Manage the connection pools

●      Manage the transaction isolation levels for the connections

●      Manage DataSource aliases

●      Deploy and remove JDBC drivers

●      Define and un-define JDBC drivers

●      Define the type of connections using the SQL Engine

●      Initialize your database

●      Monitor DataSource objects