Validation query throwing Oracle exception - 10.x
Validation query throwing Oracle exception - 10.x
- Saumya Sunder (Inactive) (Deactivated)
- Former user (Deleted)
Last updated: Feb 18, 2020 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.
, multiple selections available,
Need support? Create a request with our support team.