Query Returns No Rows, But It Works After Executing Another Query
(Doc ID 3057938.1)
Last updated on NOVEMBER 08, 2024
Applies to:
Oracle JDeveloper - Version 12.2.1.0.0 and laterInformation in this document applies to any platform.
Symptoms
An application was built using a tabbed UI in early 11g.
It was later migrated to 12.1.3.0.0 and it worked correctly.
However, after migration to 12.2.1.4.0, it is seen that one of the queries in one of the tabs returns no rows, but if another tab is opened and a query is executed in this new tab, when returning to the first tab, the query now works.
A quick inspection of the logs shows that in the second attempt, JBO has the need to refresh the entity cache.
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |