Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I ensure that query results incorporate data inserted or updated in an as yet uncommitted transaction?

April 26, 2017Data ensure incorporate inserted query results transaction uncommitted updated

0

Posted

How do I ensure that query results incorporate data inserted or updated in an as yet uncommitted transaction?

1 Answer

0

Posted

Uuse conforming on a query. Calling the conformResultsInUnitOfWork() method on a query before it is executed will ensure that uncommited changes will be accounted for in the query result. This has the downside of requiring extra processing of a query result and should only be used when necessary. Refer to Using Conforming Queries and Descriptors in the Oracle TopLink Developer’s Guide for more information.