My Oracle Support Banner

View Object Execute Query Not Fetching Latest Records From MySQL Database (Doc ID 2459383.1)

Last updated on OCTOBER 27, 2022

Applies to:

Oracle JDeveloper - Version and later
Information in this document applies to any platform.


View Object Execute Query is not fetching latest records from MySQL Database, inserted by another transaction.

For example:
-User A opens page, VO execute query runs and uses CreateInsert to insert new record in ADF table.
-User B adds new records to the MySQL DB in a different transaction.
-User B doesn't sees new record insert by User A, and vice-versa, when he/she performs an execute query to repopulate the web page.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.