Compensation for different connection and cursor characteristics among heterogeneous database management systems

摘要

A system, method and computer program product for providing a common interface to a plurality of heterogeneous database management systems, wherein data associated with a client is distributed among the plurality of heterogeneous database management systems. The system simulates support of multiple pending database actions on a single connection in any of the heterogenous database management systems which does not support multiple pending database actions on a single connection. Also, the system simulates support of cursors declared “with hold” in any of the heterogenous database management systems which does not support cursors declared “with hold”.