Difference Between "SQL ISVALID" And "SQL SELECT 1 FROM DUAL" When Datasource Is Testing DB Connection
(Doc ID 2236149.1)
Last updated on DECEMBER 16, 2023
Applies to:
Oracle WebLogic Server - Version 12.1.3.0.0 and laterInformation in this document applies to any platform.
Goal
To test database connection, [SQL SELECT 1 FROM DUAL] is used before WLS 12.1.2 and [SQL ISVALID] is used from WLS 12.1.3.
What is the difference between them?
Solution
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
Goal |
Solution |
References |