Validation Query Throwing Oracle Exception

Symptoms

One or more SQL Macro returns the following error:

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

Cause

Oracle requires a FROM clause on the validation query. Most other databases it is sufficient to use SELECT 1

Resolution

Add a valid FROM clause for Oracle