How are transactions handled in OPO?

Question:
How are transactions handled in OPO?

Answer:

Transactions are the core of multi-user data processing integrity. A transaction defines an all-or-none unit of work. The classic example of a transaction is the transfer of money from one account to another. You want to make sure that the amount credited to one account is debited from the other account. If one of these actions does not take place, there will be a discrepancy in the overall amount of money in the accounts, which will lead to acute unhappiness on the part of either the customer or the financial institution.

A transaction that includes both of these actions will let the database handle the management of these actions and prevent a loss of data integrity. The transaction is either committed, which causes the results of both actions to be added to the database, or rolled back, which does not add either of the results to the database.

Oracle Power Objects implements transactions with the session object. All actions that occur through a particular session are handled together through the CommitWork() or RollbackWork() methods of the session. The session object’s IsWorkPending property is set to indicate whether there are any outstanding actions associated with the session object.

Power Objects also provides form level methods, CommitForm() or RollbackForm(), that will trigger the related session method for all sessions associated with containers on the form. If you have an MastSes and an DetSes session associated with the form and a repeater object on the form, the CommitForm() method for the form will trigger the CommitWork() method for both of the sessions.

Power Objects automatically tracks the status of the transactions on a form with the push buttons in the default toolbar. As soon as there is work pending for any session associated with the form, the Commit and Rollback push buttons in the default toolbar are enabled. If there is work pending in the form, Power Objects will not allow you to close the form without first committing or rolling back the changed data.

There are several implications you should be aware of when dealing with transactions. Data changed during a transaction is made available to other users of the database when the transaction ends.

All databases use locks to protect the integrity of data during transactions. Ending a transaction automatically releases any locks being held by the transaction. Since locks can reduce the overall throughput of a database, frequent commits can improve overall database performance.

Database actions for more than one form may be associated with a single session, and commits and roll backs affect all actions associated with a session, so you must be careful that any transaction-ending actions do not adversely affect other data actions. You may want to use more than one session to the same database to avoid potential problems.

Finally, ending a transaction destroys the connection for the transaction. If you have set the RowFetchMode property of a bound container to “Fetch As Needed” or “Fetch Count First” and have not retrieved all the data in the result set, ending a transaction will end the retrieval of data, which may lead to inconsistencies in the client application.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

The Latest

homes in the real estate industry

Exploring the Latest Tech Trends Impacting the Real Estate Industry

The real estate industry is changing thanks to the newest technological advancements. These new developments — from blockchain and AI to virtual reality and 3D printing — are poised to change how we buy and sell homes. Real estate brokers, buyers, sellers, wholesale real estate professionals, fix and flippers, and beyond may

man on floor with data

DevX Quick Guide to Data Ingestion

One of the biggest trends of the 21st century is the massive surge in internet usage. With major innovations such as smart technology, social media, and online shopping sites, the internet has become an essential part of everyday life for a large portion of the population. Due to this internet

payment via phone

7 Ways Technology Has Changed Traditional Payments

In today’s digital world, technology has changed how we make payments. From contactless cards to mobile wallets, it’s now easier to pay for goods and services without carrying cash or using a checkbook. This article will look at seven of the most significant ways technology has transformed traditional payment methods.