Welcome!

Weblogic Authors: Yeshim Deniz, Elizabeth White, Michael Meiner, Michael Bushong, Avi Rosenthal

Related Topics: Weblogic

Weblogic: Article

Transactions: That's enough of your source!

Transactions: That's enough of your source!

A common complaint in the transaction newsgroup is, "I've done my database updates in a JTA transaction, but they didn't complete as a unit!"

In many cases, the explanation for this unfortunate loss of ACID is that the database connections that were used in the logic weren't obtained from a transactional data source, or Tx Data Source as it's abbreviated in the console. The shorthand explanation for this is that any database connection that is to participate in a distributed transaction needs to expose an xa interface, so you need a data source that can pass back an xa connection and that references a pool of xa database connections. The data source that is capable of passing through an xa connection is, you guessed it, the Tx Data Source. The bottom line: when you set up a database connection, use a Tx Data Source and an xa-compliant jdbc driver if there's any chance that you want to access it in a distributed transaction. In fact, I would boldly go so far as to say that you should always use xa drivers (where available) and Tx Data Source data sources to avoid future problems as code and infrastructure reuse change the interactions between the elements of your system.

By way of illustration, the example server shipped with WebLogic Server 7.0 provides a demo connection pool of connections to the PointBase sample database called demoXApool. The Driver class name used by this pool is com.pointbase.xa.xaDataSource, which is the name of the PointBase driver class that exposes the xa interface. This pool is in turn accessed through the Tx Data Source called examples-dataSource-demoXAPool, which exposes the xa capabilities of the PointBase driver up to the calling layers, allowing database updates to participate in JTA distributed transaction processing.

Get Something for Nothing?
If you've been following this example in your console, you may have noticed a checkbox in the configuration of the Tx Data Source entitled "Emulate Two-Phase Commit for non-XA Driver". If you were feeling optimistic the moment you saw that, your mind may have started racing and you may have reached the conclusion that if you have a non xa-capable driver, you need to simply check this box and all will be well, by virtue of WebLogic Server's ability to somehow emulate xa at the click of a checkbox. If so, my friend, I advise you to wake up and smell the heuristics, preferably quickly, before you lose the integrity of your valuable business data. You may have been led even more quickly to this conclusion in the 6.x versions of the server where, if memory serves, this option was simply entitled "enable two-phase commit". It would be surprising if all the effort that database vendors put into supporting the xa standard was able to be emulated simply by checking a box, and of course the world being generally free from such surprises, this is not the case.

Recall from past articles that the xa interface allows a transaction manager to commit a database transaction in two phases. Instead of just saying "commit" - the standard transaction demarcation verb available in all database drivers - the TM can, through the offices of xa, say "prepare" and then when it has finally made up its mind say "commit". Without the xa interface, there is no way to achieve this, and in fact the "emulation" of two-phase commit provided by WebLogic Server is simply to say "Yes" to an instruction to prepare and then pass an instruction to commit through to the (non-xa) database connection as an ordinary commit instruction. If all goes well, this will yield something that looks like a distributed transaction.

If all goes badly, this will be the beginning of your (or your WebLogic administrator's) nightmare. By way of illustration of what could go wrong, imagine a failure mode whereby the non-xa database gets corrupted, or fails after the prepare has happened. When the time comes for the commit call to be issued, there will be no way back. The commit will fail due to the corruption or disconnection, but by this point all the other databases will be gaily committing their own portions of the transaction, despite the loss of the update. Real ACID would demand that all the other databases roll back to preserve the transactional integrity. As you can see, we have lost our ACID, and with it our consistent data. In fact, this "simulation" will only be guaranteed to work if nothing in the processing environment goes wrong during certain critical windows around the commit processing. Since transactions are supposed to be all about recovering from failures, especially tricky failures during critical windows, the simulation is of no real value. The advice must be, use it as a convenience during development if you don't have an xa database driver at hand, but never check that box in a production system.

Last One to the Moon by Magic
So the xa transaction simulation certainly isn't anything close to magic moon dust. But there is something that isŠ Last Resource Optimization or LRO.

Imagine a transaction spanning several resources (generally, a resource is a fancy word for a database connection) where all but one of the resources are xa compliant. Now imagine that at prepare time the transaction manager (TM) was to successfully prepare all the xa resources. Without the non-xa resource, with all the prepares in OK, the decision to commit would be logged by the TM, and the commits would be issued. With the non-xa resource, we could limit the window for failure down to a very small duration if we were to log the decision and then immediately commit the single non-xa resource with a single phase commit instruction. If this single phase commit were to succeed, then we could go ahead with the normal second phase commitment of the rest of the resources. With this scheme, we would only be vulnerable to failure in the small window between the time the commit decision is logged and the time the non-xa commit completes. After that point, if anything failed, the non-xa resource would have been committed and eventually the xa resources would be rolled forward by the standard recovery processing. In fact we could go a step further and record the transaction id in the non-xa resource. Now we could recover the transaction with certainty, because during recovery processing the TM could check in the non-xa datastore to see if the non-xa commit succeeded or not - if the in-doubt transaction id was stored there, the commit happened, otherwise it didn't. On that basis, the rest of the resources could be recovered to their pre or post transaction states as appropriate.

In a world filled with nothing but xa resources, this LRO technique would be nothing more than an interesting curiosity, and most databases are xa compliant, so why am I boring you with this arcana? Well, many applications touch more than just databases - in these days of systems composed from a combination of bought and built functionality, most bespoke code accesses both databases (which are indeed generally xa compliant) and packaged applications (which generally are not). In fact, the whole point of the BEA WebLogic Platform is that most applications will involve elements of integration. In this scenario, to lever the maximum value out of the application server's transaction management capabilities, LRO would be a good feature.

A Little Bird Speaks of Clear Blue Water
As it turns out, a little bird told me that the next release of WebLogic Server is scheduled to support the small-window variant of LRO. When this is released, you will be able to build applications that use the transaction manager to protect data integrity across databases and an application view connected to an application through a J2EE CA adapter, even if the underlying application doesn't support xa. Or distribute a transaction across databases and a nontransactional message bus, or across multiple databases where one doesn't support xa, via a new supercharged version of the WebLogic jts driver.

Its features such as LRO, fitting as they do neatly beneath the J2EE API definitions without being specified by any of them, that sort the men from the boys and keep WebLogic Server ahead of the app server pack - a pack composed not only of competitive vendor's products but of open-source implementations and the like. J2EE support may be a commodity, in the same way as support for ANSI SQL in an RDBMS is, but it is in the application server beneath - the engine room of the modern enterprise - that commodity stops and clear blue water divides the best from the rest.

More Stories By Peter Holditch

Peter Holditch is a senior presales engineer in the UK for Azul Systems. Prior to joining Azul he spent nine years at BEA systems, going from being one of their first Professional Services consultants in Europe and finishing up as a principal presales engineer. He has an R&D background (originally having worked on BEA's Tuxedo product) and his technical interests are in high-throughput transaction systems. "Of the pitch" Peter likes to brew beer, build furniture, and undertake other ludicrously ambitious projects - but (generally) not all at the same time!

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.


@ThingsExpo Stories
Join IBM November 1 at 21st Cloud Expo at the Santa Clara Convention Center in Santa Clara, CA, and learn how IBM Watson can bring cognitive services and AI to intelligent, unmanned systems. Cognitive analysis impacts today’s systems with unparalleled ability that were previously available only to manned, back-end operations. Thanks to cloud processing, IBM Watson can bring cognitive services and AI to intelligent, unmanned systems. Imagine a robot vacuum that becomes your personal assistant tha...
SYS-CON Events announced today that TidalScale will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. TidalScale is the leading provider of Software-Defined Servers that bring flexibility to modern data centers by right-sizing servers on the fly to fit any data set or workload. TidalScale’s award-winning inverse hypervisor technology combines multiple commodity servers (including their ass...
As hybrid cloud becomes the de-facto standard mode of operation for most enterprises, new challenges arise on how to efficiently and economically share data across environments. In his session at 21st Cloud Expo, Dr. Allon Cohen, VP of Product at Elastifile, will explore new techniques and best practices that help enterprise IT benefit from the advantages of hybrid cloud environments by enabling data availability for both legacy enterprise and cloud-native mission critical applications. By rev...
Infoblox delivers Actionable Network Intelligence to enterprise, government, and service provider customers around the world. They are the industry leader in DNS, DHCP, and IP address management, the category known as DDI. We empower thousands of organizations to control and secure their networks from the core-enabling them to increase efficiency and visibility, improve customer service, and meet compliance requirements.
With major technology companies and startups seriously embracing Cloud strategies, now is the perfect time to attend 21st Cloud Expo October 31 - November 2, 2017, at the Santa Clara Convention Center, CA, and June 12-14, 2018, at the Javits Center in New York City, NY, and learn what is going on, contribute to the discussions, and ensure that your enterprise is on the right path to Digital Transformation.
Amazon is pursuing new markets and disrupting industries at an incredible pace. Almost every industry seems to be in its crosshairs. Companies and industries that once thought they were safe are now worried about being “Amazoned.”. The new watch word should be “Be afraid. Be very afraid.” In his session 21st Cloud Expo, Chris Kocher, a co-founder of Grey Heron, will address questions such as: What new areas is Amazon disrupting? How are they doing this? Where are they likely to go? What are th...
SYS-CON Events announced today that N3N will exhibit at SYS-CON's @ThingsExpo, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. N3N’s solutions increase the effectiveness of operations and control centers, increase the value of IoT investments, and facilitate real-time operational decision making. N3N enables operations teams with a four dimensional digital “big board” that consolidates real-time live video feeds alongside IoT sensor data a...
In his Opening Keynote at 21st Cloud Expo, John Considine, General Manager of IBM Cloud Infrastructure, will lead you through the exciting evolution of the cloud. He'll look at this major disruption from the perspective of technology, business models, and what this means for enterprises of all sizes. John Considine is General Manager of Cloud Infrastructure Services at IBM. In that role he is responsible for leading IBM’s public cloud infrastructure including strategy, development, and offering ...
Digital transformation is changing the face of business. The IDC predicts that enterprises will commit to a massive new scale of digital transformation, to stake out leadership positions in the "digital transformation economy." Accordingly, attendees at the upcoming Cloud Expo | @ThingsExpo at the Santa Clara Convention Center in Santa Clara, CA, Oct 31-Nov 2, will find fresh new content in a new track called Enterprise Cloud & Digital Transformation.
Smart cities have the potential to change our lives at so many levels for citizens: less pollution, reduced parking obstacles, better health, education and more energy savings. Real-time data streaming and the Internet of Things (IoT) possess the power to turn this vision into a reality. However, most organizations today are building their data infrastructure to focus solely on addressing immediate business needs vs. a platform capable of quickly adapting emerging technologies to address future ...
Most technology leaders, contemporary and from the hardware era, are reshaping their businesses to do software. They hope to capture value from emerging technologies such as IoT, SDN, and AI. Ultimately, irrespective of the vertical, it is about deriving value from independent software applications participating in an ecosystem as one comprehensive solution. In his session at @ThingsExpo, Kausik Sridhar, founder and CTO of Pulzze Systems, will discuss how given the magnitude of today's applicati...
SYS-CON Events announced today that NetApp has been named “Bronze Sponsor” of SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. NetApp is the data authority for hybrid cloud. NetApp provides a full range of hybrid cloud data services that simplify management of applications and data across cloud and on-premises environments to accelerate digital transformation. Together with their partners, NetApp emp...
As popularity of the smart home is growing and continues to go mainstream, technological factors play a greater role. The IoT protocol houses the interoperability battery consumption, security, and configuration of a smart home device, and it can be difficult for companies to choose the right kind for their product. For both DIY and professionally installed smart homes, developers need to consider each of these elements for their product to be successful in the market and current smart homes.
SYS-CON Events announced today that Avere Systems, a leading provider of enterprise storage for the hybrid cloud, will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Avere delivers a more modern architectural approach to storage that doesn't require the overprovisioning of storage capacity to achieve performance, overspending on expensive storage media for inactive data or the overbui...
Widespread fragmentation is stalling the growth of the IIoT and making it difficult for partners to work together. The number of software platforms, apps, hardware and connectivity standards is creating paralysis among businesses that are afraid of being locked into a solution. EdgeX Foundry is unifying the community around a common IoT edge framework and an ecosystem of interoperable components.
SYS-CON Events announced today that Avere Systems, a leading provider of hybrid cloud enablement solutions, will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Avere Systems was created by file systems experts determined to reinvent storage by changing the way enterprises thought about and bought storage resources. With decades of experience behind the company’s founders, Avere got its ...
High-velocity engineering teams are applying not only continuous delivery processes, but also lessons in experimentation from established leaders like Amazon, Netflix, and Facebook. These companies have made experimentation a foundation for their release processes, allowing them to try out major feature releases and redesigns within smaller groups before making them broadly available. In his session at 21st Cloud Expo, Brian Lucas, Senior Staff Engineer at Optimizely, will discuss how by using...
In this strange new world where more and more power is drawn from business technology, companies are effectively straddling two paths on the road to innovation and transformation into digital enterprises. The first path is the heritage trail – with “legacy” technology forming the background. Here, extant technologies are transformed by core IT teams to provide more API-driven approaches. Legacy systems can restrict companies that are transitioning into digital enterprises. To truly become a lead...
SYS-CON Events announced today that CAST Software will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. CAST was founded more than 25 years ago to make the invisible visible. Built around the idea that even the best analytics on the market still leave blind spots for technical teams looking to deliver better software and prevent outages, CAST provides the software intelligence that matter ...
SYS-CON Events announced today that Daiya Industry will exhibit at the Japanese Pavilion at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Ruby Development Inc. builds new services in short period of time and provides a continuous support of those services based on Ruby on Rails. For more information, please visit https://github.com/RubyDevInc.