Oracle International Corporation

Oic Acquisition I Corporation

Oic Acquisition Corporation

James Sutherland

Yaoping Wang

Douglas Clarke

Andrei Ilitchev

In an EclipseLink environment, persistence units are associated with a single data source. However, in accordance with an embodiment, a user can define multiple persistence units, each with a different set of entity types (i.e., classes) stored in multiple data sources, and expose them through a single composite persistence unit which combines the entities from across the multiple data sources through a single persistence context. A plurality of different types of data sources can be used, including Java Transaction API (JTA) and non-JTA data sources as well as EclipseLink's native JDBC connection pools. Each member persistence unit continues mapping its classes to its own data source. Therefore, a composite persistence unit allows one to map different entities to different data sources. Composite persistence units can be created at runtime.

Systems and methods for composite persistence units

Instructions are generated to manipulate target objects and relationships in a relational database when a source object having a one-to-many relationship of privately owned type with the target objects is manipulated. To generate instructions, mapping meta-data is used which contains information as to how object classes of the object model map to tables in the database and how relationships map to foreign keys.

System and method for managing object to relational one-to-many mapping

A retrieval system generates a retrieval query for batch reading of related objects when a source object is read from the database. The related objects include nested objects and/or many-to-many relationship objects. It generates a single retrieval query for each type in each level of nested objects using its parent query. Also it generates a retrieval query to retrieve a collection of target objects having many-to-many relationships with a collection of source objects.

System and method for retrieval of objects from object to relational mappings

A system for integrating object changes occurring to an object in a first object storage system with a second object storage system. The system operates by first receiving from a first object storage systems a notification of an event relating to an object in the first object storage system. The system sets up a representation of the object in a second object storage system in response to the notification and determines object changes made to the object in the first object storage system by using the representation in the second object storage system. Finally, the system determines object changes with the representation in the second storage system.

Growing community of inventors

Ottawa, Canada

James Sutherland