/
How to resolve an Oracle validation query throwing exception - 10.x

How to resolve an Oracle validation query throwing exception - 10.x

Owned by Former user (Deleted)

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 in the validation query. For most other databases, it is sufficient to use SELECT 1. 

Resolution

Add a valid FROM clause for Oracle queries.