Logical locking for Java Data Objects

A computer-implemented method for performing logical locking, the method comprising:

• initiating a transaction affecting a data object stored in one or more rows of a table in a data store, the data object having an object identifier;
• receiving a request for a logical optimistic read lock on the data object;
• determining the one or more rows in the table in the data store in which the data object is stored;
• formatting the request for the logical optimistic read lock on the data object into a standardized request to logically lock columns and the one or more rows in the table in which the data object is determined to be stored, the columns in the table based on the object identifier of the data object, wherein formatting the request into the standardized request includes:
• formatting an identification of the table having the one or more rows to be locked into a name parameter of the standardized request;
• formatting primary key values that identify the one or more rows to be locked into an argument parameter of the standardized request;
• and
• formatting a mode value that indicates an optimistic read lock of the one or more rows to be locked into a mode parameter of the standardized request;
• retrieving a copy of the one or more rows in the table in which the data object is determined to be stored from the table into a memory responsive to the standardized request;
• modifying the copy of the one or more rows in memory;
• promoting the optimistic read lock of the one or more rows to an exclusive write lock;
• committing the modified copy of the one or more rows in memory to the table in the data store;
• and
• ending the transaction.

An article of manufacture comprising:

• a machine-readable storage medium providing instructions that, when executed by a processor, cause the processor to
• receive a request to logically exclusively lock a data object stored in one or more rows of a table in a data store, the data object having an object identifier;
• determine the one or more rows in the table in the data store in which the data object is stored;
• format the request to logically exclusively lock the data object into a standardized request to logically lock columns and the one or more rows in the table in which the data object is determined to be stored, the columns in the table based on the object identifier of the data object, wherein to format the request into the standardized request includes:
• format an identification of the table having the one or more rows to be locked into a name parameter of the standardized request;
• format primary key values that identify the one or more rows to be locked into an argument parameter of the standardized request;
• and
• format a mode value that indicates a shared read lock of the one or more rows to be locked into a mode parameter of the standardized request;
• retrieve a copy of the one or more rows in the table in which the data object is determined to be stored from the table in the data store into a memory responsive to the standardized request;
• modify the copy of the one or more rows in memory;
• and
• commit the modified copy of the one or more rows in memory to the table in the data store.

An article of manufacture comprising:

• an machine-readable storage medium providing instructions that, when executed by a processor, cause the processor to
• initiate a transaction affecting a data object stored in one or more rows of a table in a data store, the data object having an object identifier;
• receive a request for a logical optimistic read lock on the data object;
• determine the one or more rows in the table in the data store in which the data object is stored;
• format the request for the logical optimistic read lock on the data object into a standardized request to logically lock columns and the one or more rows in the table in which the data object is determined to be stored, the columns in the table based on the object identifier of the data object, wherein to format the request into the standardized request includes:
• format an identification of the table having the one or more rows to be locked into a name parameter of the standardized request;
• format primary key values that identify the one or more rows to be locked into an argument parameter of the standardized request;
• and
• format a mode value that indicates an optimistic read lock of the one or more rows to be locked into a mode parameter of the standardized request;
• retrieve a copy of the one or more rows in the table in which the data object is determined to be stored from the table into a memory responsive to the standardized request;
• modify the copy of the one or more rows in memory;
• promote the optimistic read lock of the one or more rows to an exclusive write lock;
• commit the modified copy of the one or more rows in memory to the table in the data store;
• and
• end the transaction.