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.
Include Page | ||||
---|---|---|---|---|
|