Abstract: Embodiments of the present invention address deficiencies of the art in respect to programmatic database access and provide a method, system and computer program product for programmatic partial updating of a row. In one embodiment, a data processing system for programmatic partial updating of a row in a database can include a database proxy driver configured to expose an interface for interacting with the database and to accept an execution of a prepared statement without requiring set values for all fields bound by the prepared statement. The interface can include, for example, a Java Database Connectivity (JDBC) compliant interface. The prepared statement can include a binding to multiple fields in a designated row and a set of setter methods defined for a subset of the multiple fields.

Abstract: A container managed persistent (CMP) enterprise java bean (EJB) framework includes support for accessing multiple data sources within one deployment. A CMP EJB includes a number of different attributes that can be a variety of values. A session EJB that acts as a front-end to the CMP EJP includes a resource reference for each of the different data sources that the entity CMP EJB may utilize. The application server environment includes a map that defines mapping information between the attributes of the CMP EJB and the resource references of the session EJB. Using the mapping information during runtime, the application server connects to the appropriate data source.

Abstract: A method, apparatus, system, and signal-bearing medium that in an embodiment receive a specification of a method in a container-managed persistence bean and a specification of a procedure in a backend data store, generate code in a helper class associated with the container-managed persistence bean, determine a connector based on a connection factory type, and access the procedure via a backend-specific protocol and the connector. The code in the helper class performs the accessing. In this way, the container-managed persistence bean may access the backend data store without knowledge of the backend-specific protocol.

Abstract: An apparatus and method enable batch processing of database updates without modifying generated code, i.e., without redeployment of the application server or application. A batch mechanism intercepts calls from the generated code, compiles updates into batches, and processes the updates to the database in batches. In this manner the batch mechanism takes advantage of the batch processing capabilities of the database without modifying the generated code.