System and method for using a gridlink data source to connect an application server with a clustered database

A method to support connecting an application server with a clustered database having a heterogeneous plurality of data providers, said method comprising:

• providing an application server operating on one or more microprocessor;
• providing a notification service operating on a clustered database;
• wherein the notification service is used by the clustered database to broadcast notifications that describe a state change in the clustered database;
• providing single a data source on the application server wherein the single data source operates to connect the application server with the clustered database, and wherein the single data source comprises a connection pool which manages a heterogeneous set of connections to the heterogeneous plurality of data providers in the clustered database, wherein particular connections of said heterogeneous set of connections are configured for connecting to particular data providers of said heterogeneous plurality of data providers;
• registering the single data source with the notification service of the clustered database to receive said notifications that describe a state change in the clustered database;
• receiving with the single data source, from the notification service of the clustered database, notifications that describe a state change in the clustered database;
• and
• wherein, in response to receiving said notifications that describe a state change in the clustered database, the single data source configures said connection pool to manage said heterogeneous set of connections between the application server and the heterogeneous plurality of data providers of the clustered database adaptively according to the state change of the clustered database at run time.

A non-transitory computer readable storage medium including instructions stored thereon for supporting connecting an application server with a clustered database having a heterogeneous plurality of data providers, wherein said instructions, when executed cause a computer system to perform steps comprising:

• providing an application server operating on one or more microprocessor;
• providing a notification service operating on a clustered database;
• wherein the notification service is used by the clustered database to broadcast notifications that describe a state change in the clustered database;
• providing a single data source on the application server wherein the single data source operates to connect the application server with the clustered database, and wherein the single data source comprises a connection pool which manages a heterogeneous set of connections to the heterogeneous plurality of data providers in the clustered database, wherein particular connections of said heterogeneous set of connections are configured for connecting to particular data providers of said heterogeneous plurality of data providers;
• registering the single data source with the notification service of the clustered database to receive said notifications that describe a state change in the clustered database;
• receiving with the single data source, from the notification service of the clustered database, notifications that describe a state change in the clustered database;
• and
• wherein, in response to receiving said notifications that describe a state change in the clustered database, the single data source configures said single data source to manage said heterogeneous set of connections between the application server and the heterogeneous plurality of data providers of the clustered database adaptively according to the state change of the clustered database at run time.