Abstract:
In accordance with an embodiment, described herein is a system and method for providing data sources in a multitenant application server environment. The system includes a an application server environment with a plurality of partitions and a resource group template referenced by a resource group in one or more of the plurality of partitions; and a data source configuration defined as part of the resource group template. The data source configuration can be overridden with attributes specific to a particular referencing partition. A data source subsystem can create a data source object in accordance with the overridden data source configuration, for use in creating connections to a database associated with the particular referencing partition, monitoring and diagnosing the data source object.
Abstract:
A system and method for connection labeling for use with connection pools, including support for cloud-based multi-tenant environments using connection labeling. In accordance with an embodiment, the system comprises a connection pool, including a plurality of connection objects which provide connections that software applications can use to make requests to access the database, wherein each of the connections can be labeled according to the configuration of particular applications; and a connection pool logic that identifies connections labeled as high-cost connections, and controls the creation or repurposing of high-cost connections to serve requests from the multiple tenants or tenant applications.
Abstract:
A clustered database environment includes multiple database instances that appear as one server. An application server can use a data source and connection pools to connect with the clustered database. A notification service broadcasts notifications describing state changes in the database instances, which are then used by the data source and connection pools to control access to the database instances. A data source configuration allows for specification of a preferred affinity policy. A session affinity policy is used to provide database instance affinity for database access made under the context of a web session, whereby database operations are directed to a particular instance for a period of time when the application may be performing multiple, related updates to a specific data set. Directing such operations to a single database instance can be used to improve application performance due to increased local cache utilization.
Abstract:
A clustered database environment includes multiple database instances that appear as one server. An application server can use a data source and connection pools to connect with the clustered database. A notification service broadcasts notifications describing state changes in the database instances, which are then used by the data source and connection pools to control access to the database instances. A data source configuration allows for specification of a preferred affinity policy. A session affinity policy is used to provide database instance affinity for database access made under the context of a web session, whereby database operations are directed to a particular instance for a period of time when the application may be performing multiple, related updates to a specific data set. Directing such operations to a single database instance can be used to improve application performance due to increased local cache utilization.
Abstract:
A system and method can support transaction processing in a middleware environment. A processor, such as a remote method invocation stub in the middleware environment, can be associated with a transaction, wherein the transaction is from a first cluster. Then, the processor can handle a transactional request that is associated with the transaction, wherein the transactional request is to be sent to the first cluster. Furthermore, the processor can route the transactional request to a said cluster member in the first cluster, which is an existing participant of the transaction.
Abstract:
In accordance with an embodiment, described herein is a system and method for supporting proxy data sources in a multitenant application server environment, such as Java SE and Java EE environments. In multitenant environments, various tenants can have data sources that an administrative application can access without needing to know the actual data sources. A system and method provide a proxy data source mechanism such that applications in Java EE and Java SE environments can access tenant data sources, each tenant data source having a JNDI name that is tenant or partition specific, through the proxy data source, the proxy data source comprising a JNDI name which is not tenant or partition specific. The proxy data source can also provide for switching between tenant data sources based upon a caller context.
Abstract:
A system and method can support transaction processing in a middleware environment. A processor, such as a remote method invocation stub in the middleware environment, can be associated with a transaction, wherein the transaction is from a first cluster. Then, the processor can handle a transactional request that is associated with the transaction, wherein the transactional request is to be sent to the first cluster. Furthermore, the processor can route the transactional request to a said cluster member in the first cluster, which is an existing participant of the transaction.
Abstract:
In accordance with an embodiment, described herein is a system and method for supporting proxy data sources in a multitenant application server environment, such as Java SE and Java EE environments. In multitenant environments, various tenants can have data sources that an administrative application can access without needing to know the actual data sources. A system and method provide a proxy data source mechanism such that applications in Java EE and Java SE environments can access tenant data sources, each tenant data source having a JNDI name that is tenant or partition specific, through the proxy data source, the proxy data source comprising a JNDI name which is not tenant or partition specific. The proxy data source can also provide for switching between tenant data sources based upon a caller context.
Abstract:
A system and method for connection labeling for use with connection pools. In accordance with an embodiment, the system comprises a connection pool, including a plurality of connection objects which provide connections that software applications can use to make requests to access the database, wherein each of the connections can be labeled according to the configuration of particular applications; and a connection pool logic that identifies connections labeled as high-cost connections, and avoids using those high-cost connections to serve requests when the total number of connections is below a particular threshold value.
Abstract:
In accordance with an embodiment, an application server environment can include a plurality of partitions and a resource group template, which can be referenced by a resource group in one or more of the plurality of partitions. A data source configuration can be defined as part of the resource group template. The data source configuration can be overridden with attributes specific to a particular referencing partition. A data source subsystem can create a data source object in accordance with the overridden data source configuration, for use in creating connections to a database associated with the particular referencing partition, monitoring and diagnosing the data source object.