Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Symptoms

One or more SQL macros return the following error:

Code Block
org.apache.tomcat.dbcp.dbcp.SQLNestedException:
Cannot create PoolableConnectionFactory (ORA-00923: FROM keyword not found where expected

Cause

Oracle requires a FROM clause in the validation query. For most databases, using SELECT 1 suffices

Resolution

Add a valid FROM clause to your Oracle validation query.

Image Removed

Include Page
SUPPORT:How to resolve an Oracle validation query throwing exception - 10.x
SUPPORT:How to resolve an Oracle validation query throwing exception - 10.x