Method and apparatus for distributed database access

摘要

In a distributed computing environment having a plurality of computers connected by a communications network (10), a distributed database access system, method and computer program product including a plurality of clients represented by software running on a computer (12) connected to the communications network (22), a plurality of databases and a connection manager (16). The connection manager maintains a plurality of database connection pools with each pool maintaining one or more database connections to a database (18). Upon request from a client for database access (20), the connection manager places the client in communication with a database connection selected from a particular database connection pool (14). The plurality of databases can include at least one database storing data in a first data storage schema and at least one database storing data in a second data storage schema and the client request for database access can include a reference to a data storage schema. The invention may also be implemented within a transaction processing system.